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

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 peopleteam@yoti.com or let us know at any stage of the recruitment process. For more information please read our Applicant Privacy Notice.