Senior Data Engineer

Atain; Pune District; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

Atain is seeking a Senior Data Engineer to join our data team in Pune. The role focuses on SQL Server, ETL with SSIS and ADF, and cloud data integration using Azure Databricks. You will work with Power BI, DAX development, and dimensional modeling to support enterprise reporting and analytics.

Legacy SSIS solutions are part of the landscape while modern data platform strategies are pursued. The ideal candidate will design, build, and optimize data pipelines, dashboards, and semantic models,

Qualifications

• 8-12 years of hands-on experience with Microsoft SQL Server and T-SQL.
• Strong ETL development experience using SSIS and Azure Data Factory.
• Experience with Azure Databricks for big data processing.
• Experience with Power BI, DAX, and data modeling concepts.
• Proficiency in data quality, cleansing, validation, and auditing.

Responsibilities

• Design, develop, and maintain robust ETL workflows using SSIS, ADF and Databricks.
• Write complex SQL Server queries for data transformation, analysis and reporting.
• Perform data modeling and warehousing for enterprise analytics.
• Enhance and troubleshoot existing SSIS pipelines and legacy ETL.
• Develop, optimize, and publish dashboards and reports in Power BI.
• Create and maintain advanced DAX measures and time-intelligence calculations.
• Design semantic models and optimize Power BI datasets for performance.
• Implement data quality checks and validation routines.
• Collaborate with BI developers, analysts and stakeholders to translate requirements.
• Contribute to scalable and secure data pipeline architecture and documentation.
• Troubleshoot and optimize DAX queries and report performance.

Skills

Advanced SQL Server

ETL development

DAX development

Dimensional modeling

Data warehousing

Power BI

Data quality

Data validation

Data modeling

Cloud data integration

Tools

SSIS

Azure Data Factory

Azure Databricks

Power BI

Job description

• Advanced SQL Server, ETL development using SSIS, Azure Data Factory (ADF), Azure Databricks, Power BI, Advanced DAX (Data Analysis Expressions), Data Warehousing, Data Modeling, Data Quality and Validation

Job Summary

We are seeking a highly skilled and experienced Senior Data Engineer to join our growing data team. The ideal candidate will have strong expertise in SQL Server, ETL development, and cloud-based data integration tools such as Azure Data Factory and Azure Databricks. The role also requires hands-on experience with Power BI, DAX development, and dimensional data modeling to support enterprise reporting and analytics initiatives. This position requires a proactive mindset and a willingness to work with legacy SSIS solutions while actively contributing to modern data platform strategies.

Key Responsibilities

• Design, develop, and maintain robust ETL workflows using SSIS, Azure Data Factory, and Databricks.
• Write complex, optimized SQL Server queries for data transformation, analysis, and reporting.
• Perform data modeling, integration, and warehousing in support of enterprise analytics initiatives.
• Support and enhance existing SSIS packages; troubleshoot and resolve issues related to older ETL pipelines.
• Develop, optimize, and publish dashboards and reports using Power BI.
• Create and maintain advanced DAX measures, calculated columns, calculated tables, KPIs, and time-intelligence calculations to support business reporting requirements.
• Design semantic models and optimize Power BI datasets for performance, scalability, and usability.
• Implement data quality checks and validation routines to ensure the accuracy and consistency of data.
• Collaborate with cross-functional teams including BI developers, analysts, and business stakeholders to translate business requirements into scalable data and reporting solutions.
• Contribute to the architecture, design, and implementation of scalable and secure data pipelines.
• Document technical designs, solutions, and processes as per organizational standards.
• Troubleshoot and optimize DAX queries, report performance, and data refresh processes within the Power BI ecosystem.

Required Skills

• 8-12 years of hands-on experience with Microsoft SQL Server and writing complex T-SQL queries.
• Strong ETL development experience using SSIS and Azure Data Factory.
• Experience with Azure Databricks for big data processing and integration.
• Willingness and capability to work with and improve legacy SSIS-based solutions.
• Strong understanding of Data Warehousing concepts, star/snowflake schema, and dimensional modeling.
• Proficiency in Power BI for data visualization, dashboard development, and reporting.
• Strong hands-on experience in writing complex DAX measures, calculated columns, calculated tables, KPIs, and time-intelligence functions.
• Experience with Power BI data modeling, semantic models, row-level security (RLS), and performance optimization.
• Strong background in data quality, cleansing, validation, and auditing.
• Experience with the Microsoft technology stack (Azure, SQL Server, SSRS, SSAS, Power BI, etc.).
• Experience working with business stakeholders to develop analytical solutions and executive dashboards using Power BI and DAX.

Preferred Skills

• Experience with Power BI Premium/Fabric environments.
• Knowledge of SSAS Tabular Models and advanced DAX optimization techniques.
• Exposure to Microsoft Fabric, OneLake, and modern cloud analytics platforms.
• Microsoft Azure or Power BI certifications are a plus.

This addition makes DAX a clearly evaluated competency rather than an implied Power BI skill, helping attract stronger BI/Data Engineering candidates with reporting and analytics expertise.

About IGT Solutions:

About Atain:

(http://www.atain.com)

Atain is an enterprise orchestration partner that aligns people, processes, and platforms with AI to redefine work and deliver assured outcomes. It is enabled through the SMART Framework driving superior metrics with AI-redefined work, the TechBud platform, a GenAI foundation built on zero-pilot architecture and ISO 42001 standards, a robust partner ecosystem, and deep domain expertise. Atain's Unified Hub continuously senses, predicts, and re-orchestrates work across people, processes, and platforms to deliver assured outcomes. The centers of skill and scale combine deep expertise with AI to deliver assured outcomes. For more information, visit www.atain.com

Atain is ISO 27001:2013, CMMI SVC Level 5 and ISAE-3402 compliant for IT, and COPC Certified v6.0, ISO 27001:2013 and PCI DSS 3.2 certified for BPO processes. The organization follows Six Sigma rigor for process improvements.

It is our policy to provide equal employment opportunities to all individuals based on job-related qualifications and ability to perform a job, without regard to age, gender, gender identity, sexual orientation, race, color, religion, creed, national origin, disability, genetic information, veteran status, citizenship or marital status, and to maintain a non-discriminatory environment free from intimidation, harassment or bias based upon these grounds.