Senior Data Engineer – Power BI, Azure Databricks, SQL Server & SSIS (India)

Senior Data Engineer – Power BI, Azure Databricks, SQL Server & SSIS (India)

19 Nov
|
Philodesign Technologies
|
India

19 Nov

Philodesign Technologies

India

We're Hiring: Senior Data Engineer – Power BI, Azure Databricks, SQL Server & SSIS

Experience: 8–12 Years

Work Mode: 100% Remote

Shift Timing: 12:30 PM – 9:30 PM IST

Employment Type: As per project engagement terms

About the Role

We are looking for an experienced Senior Data Engineer with strong expertise in Microsoft SQL Server, SSIS, Azure Data Factory (ADF), Azure Databricks, and Power BI.

The ideal candidate should have a strong combination of data engineering, ETL development, data warehousing, and business intelligence expertise. The role involves developing scalable data pipelines, optimizing complex SQL queries, maintaining legacy SSIS solutions, and building advanced Power BI dashboards and semantic models using DAX.

Candidates should be comfortable working across both traditional Microsoft data technologies and modern cloud-based data platforms.

Key Responsibilities

- Design, develop, and maintain scalable ETL workflows using SSIS, Azure Data Factory (ADF), and Azure Databricks.
- Write and optimize complex SQL Server queries, stored procedures, and T-SQL scripts.
- Develop and manage data ingestion, transformation, and integration pipelines.
- Maintain, enhance, and troubleshoot existing legacy SSIS packages and ETL workflows.
- Build interactive Power BI dashboards, reports, and analytical solutions.
- Develop advanced DAX measures, calculated columns, calculated tables, KPIs, and time-intelligence calculations.
- Design and optimize Power BI semantic models, datasets, and data refresh processes.
- Implement dimensional data models, Star/Snowflake schemas, and data warehousing solutions.
- Ensure data quality, validation, consistency, and reliability across data pipelines.
- Implement Row-Level Security (RLS) and optimize Power BI report performance.
- Collaborate with business stakeholders, BI developers, analysts, and data teams to deliver scalable analytics solutions.
- Contribute to modern data platform initiatives and continuously improve existing data engineering processes.

Mandatory Technical Skills
- SQL Server:



Advanced SQL, complex T-SQL queries, stored procedures, and performance tuning.
- SSIS: Strong hands-on experience in ETL development, package maintenance, and troubleshooting.
- Azure Data Factory: Data integration, pipeline development, orchestration, and transformation.
- Azure Databricks: Hands-on experience with data processing, integration, and large-scale transformations.
- Power BI: Dashboard development, reporting, semantic modeling, and dataset optimization.
- Advanced DAX: Measures, calculated columns, calculated tables, KPIs, and time-intelligence functions.
- Data Warehousing: Dimensional modeling, Star/Snowflake schemas, and analytical data structures.
- Python/PySpark: Working knowledge for data engineering and transformation activities.

Required Experience
- 8–12 years of overall IT experience with substantial hands-on experience in Data Engineering.
- Strong expertise in Microsoft SQL Server and ETL development.
- Practical experience with SSIS, Azure Data Factory, and Azure Databricks.
- Strong Power BI development and advanced DAX capabilities.
- Experience with data modeling, data quality, and performance optimization.
- Ability to work with legacy ETL systems while contributing to modern cloud data platforms.
- Strong communication skills and fluency in English.
- Ability to collaborate with cross-functional and business stakeholder teams.

Good to Have
- Microsoft Fabric and OneLake.
- Power BI Premium / Fabric environments.
- SSAS Tabular models and advanced DAX optimization.
- DataOps, CI/CD, and deployment automation.
- Microsoft Azure or Power BI certifications.

What We Offer
- Fully remote working opportunity.
- Opportunity to work on enterprise-level data engineering and analytics initiatives.
- Exposure to modern Microsoft Azure data technologies.
- Compensation budget of up to ₹1.9 LPM.

Interested Candidates If you have strong hands-on experience in SQL Server, SSIS, Azure Databricks, ADF, and advanced Power BI/DAX development, we would love to connect with you.

Apply now or share this chance with relevant professionals in your network!

📌 Senior Data Engineer – Power BI, Azure Databricks, SQL Server & SSIS (India)
🏢 Philodesign Technologies
📍 India

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior data engineer – power bi, azure databricks, sql server & ssis (india) / india

Subscribe to this job alert:

Get the latest job offers by email for: senior data engineer – power bi, azure databricks, sql server & ssis (india) / india