Data Analytics Engineer I

ISA; Maharashtra; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

ISA is seeking an Analytics Engineer to 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. 2–4 years of relevant experience preferred.

Qualifications

• Fluent in English.
• Bachelor's degree in Computer Science, IT, Analytics, Statistics, or related field.
• Strong SQL skills and Python for data transformation tasks.
• Working knowledge of dbt for transformation layer development, tests, documentation, and lineage.
• Hands-on experience with Power BI: data modelling, DAX, report design, and governance.

Responsibilities

• Design and maintain modular, well-tested ELT pipelines using 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 and reusable dbt models.
• Develop production-grade Power BI reports and dashboards with well-structured data models and row-level security.
• Define and implement data quality rules, testing frameworks, and monitoring for analytics outputs.
• Collaborate with data analysts, business stakeholders, and data engineers to translate reporting requirements into robust, governed data assets.
• Apply dimensional modelling principles (star schema, SCD types) 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 pipelines, metrics, and report logic; participate in code reviews.

Skills

English fluency

Education

Bachelor's degree in Computer Science or related field

Tools

SQL

Python

dbt

Azure Data Factory

Snowflake

Microsoft Fabric

Power BI

DAX

Job description

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.

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.
• Strong SQL skills and solid working knowledge of Python for data transformation tasks.
• Working knowledge of dbt for transformation layer development, including tests, documentation, and lineage.
• Hands-on experience with Power BI: data modelling, DAX, report design, and workspace governance.
• Demonstrable experience delivering Power BI solutions in a professional setting.
• Familiarity with Microsoft Fabric or Azure Data Factory for pipeline orchestration and data movement.
• Solid understanding of dimensional modelling (star/snowflake schema, SCD types).
• Understanding of BI governance principles: semantic model management, certified datasets, and access control in Power BI.

Work Experience

• With 2-4 years of hands-on experience in analytics engineering, data engineering, or BI development.
• Experience with Snowflake or Azure Synapse Analytics for data warehousing and query optimization.
• Experience with Git-based version control and collaborative development workflows.