Job Purpose

Design and deliver data transformation pipelines, semantic models, and BI solutions that enable reliable, self-service analytics across the organization. The role bridges data engineering and business intelligence, owning the analytical data layer from source transformation through to governed, business-ready reporting assets.

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.
• Maintain clear documentation for all pipelines, semantic models, metric definitions, and report logic.
• Participate actively in code reviews and contribute to improving team standards for analytics engineering.

Qualifications (Academic, Training, Languages)

• Bachelor's degree in Computer Science, Information Technology, Business Analytics, Statistics, or a related field.
• Fluent in English Language.
• ITIL Certification is an advantage but not mandatory.
• Robust SQL skills and solid working knowledge of Python for data transformation tasks.
• Working knowledge of dbt for tra

📌 Data Analytics Engineer I (Pune)
🏢 Air Arabia
📍 Pune