Bi Data Modelling Engineer

Who we are Born in 2014 Yoti is a digital identity and biometric technology company that makes it safer for people to prove who they are The Yoti app was designed with privacy at its core giving people a secure way to prove their identity and share third-party credentials with organisations and other people Today we have over seventeen million app downloads around the world We ve expanded our offering to a suite of business solutions that span identity verification age verification and estimation e-signing AI anti-spoofing technologies and we continue to think of innovative new offerings From day one we ve been working to fix an outdated identity system This is not a journey we make on our own but with policy advisors think tanks researchers academics humanitarian bodies our users and everyday people We are committed to solving identity problems through grassroots research and social purpose initiatives Purpose of the Role It is worth noting that this role does not involve creating reports dashboards or conducting business analysis or drawing business insights This role is part of Yoti s BI engineering team and the primary responsibility of this role is to build and maintain robust scalable data models and a semantic layer that allows analysts and data scientists to conduct their own analyses Our data although high in integrity is collected from a diverse set of platforms and services across Yoti The BI Data Modelling Engineer will design data models and semantic structures dimensions views measures using LookML and Airflow to unify this data and enable self-service reporting in Looker Alongside data modelling you will be involved in monitoring optimising and enhancing the BI pipeline and infrastructure Role Dimensions Member of the BI Team reporting to the Data Engineer Principal Responsibilities Semantic Layer Data Modeling Core Focus Undertake a wide range of data modelling requirements with varying levels of complexity Design and develop data models in LookML and Airflow creating views explores joins dimensions and measures to unify data from different services Assist in defining and building data architecture for data warehouse and big data solutions including fact and dimensional modelling ETL ELT and BI Pipeline Management Support data engineering efforts related to ELT ETL pipelines and ensure proper ingestion into the data warehouse e g Redshift Postgres Monitor optimize and enhance the BI pipeline and infrastructure Support the delivery and migration of new data where change remains a constant and a continuous improvement cycle regime prevails Collaboration and Documentation Own and maintain model documentation and LookML Airflow codebase in Git Work with the analyst team to maximise the benefits of business intelligence and data analytics in line with their business objectives Provide input into data management practices including data classification data retention data usage data destruction and other aspects of data usage across technical and non-technical solutions Create well-structured and descriptive code and documentation for data architecture processes and reporting Operational and Technical Support Support Business As Usual BAU activities including troubleshooting performance monitoring and data validation Create and maintain SQL Server jobs SSIS packages and stored procedures Identify communicate and resolve data quality and data reconciliation issues Troubleshoot and diagnose performance issues Knowledge Skills Qualifications and Experience Essential Skills Git code management Excellent command of SQL for relational databases like Redshift and Postgres Familiarity with BI tools such as Looker Power BI Knowledge of data master data and metadata-related standards processes and technology Desirable Skills Experience with Python and Airflow Knowledge of AWS Strong communication skills with both business and engineering stakeholders including the ability to translate technical findings into actionable insights or requirements for non-technical users Ability to communicate with nontechnical business users to determine specific business requirements for reports and business intelligence solutions Strong troubleshooting skills and the ability to diagnose performance issues effectively What s in it for you Medical Insurance cover of INR 5 lakhs Life Insurance Accidental cover Gratuity as per law PF as per law 18 days paid leave 6 sick day leave Yearly 10 declared holidays Yearly 5 fully paid Selfie Days - for your own personal development volunteering charity events etc Quarterly Team and company activities Social clubs Continuous learning opportunities Annual Training budgets conferences etc This is a great opportunity to join a company that is leading the way for innovative and responsible identity verification We re looking for people who can adapt to a fast-paced environment as well as champion our brand and what we stand for We value a positive attitude and people who have a collaborative creative and transparent approach to solving problems We believe in equal opportunities It takes a diverse community of passionate talented and committed people to build a simpler more secure way of proving identity We re an equal opportunity employer so we welcome applications from people of all backgrounds with different outlooks and experiences We are proud to be a Disability Confident employer and we re committed to making our recruitment process as inclusive and accessible as possible If you have a disability or long-term condition and need any adjustments or support during the application or interview process please let us know we ll do everything we can to support you and to enable you to bring your best self to our hiring process Talent Pool If we consider that you might be suitable for other roles in the future we will keep your details so we can contact you about these other roles If you do not want us to keep your details for this purpose please e-mail or let us know at any stage of the recruitment process For more information please read our