Data Analytics Engineer I

Job Purpose

Key Result Responsibilities

• Design and maintain modular, well-tested ELT pipelines using tools such as dbt, Azure Data Factory, or equivalent orchestration frameworks.
• Build and maintain the semantic/analytical data layer in Snowflake or Microsoft Fabric, including fact and dimension tables, conformed metrics, and reusable dbt models.
• Develop production-grade Power BI reports and dashboards, including well-structured data models, DAX measures, and row-level security configurations.
• Define and implement data quality rules, testing frameworks, and monitoring to ensure accuracy and consistency of analytics outputs.

Key Result Responsibilities-Continued

• Collaborate with data analysts, business stakeholders, and data engineers to translate reporting requirements into robust, governed data assets.
• Apply and enforce dimensional modelling principles (star schema, slowly changing dimensions) to support efficient BI consumption.
• Work within Azure and Snowflake environments to manage datasets, optimize query performance, and control data access.