Hiring: Senior Data Engineer – Power BI | Databricks | SQL Server | SSIS

We are looking for an experienced Senior Data Engineer with 8–12 years of hands-on experience in SQL Server, ETL development, Azure Data Factory, Azure Databricks, and Power BI.

The ideal candidate should have strong expertise in building scalable data pipelines, developing complex SQL queries, designing data warehouse solutions, and creating advanced Power BI dashboards using DAX. The role requires someone who can work with both legacy SSIS-based ETL solutions and modern cloud-based data platforms.

Job Details

- Job Title: Senior Data Engineer
- Experience: 8–12 Years
- Work Mode: Remote
- Shift Timing: 12:30 PM – 9:30 PM IST
- Employment Type: [Full-Time / Contract]
- Location: Remote

Key Responsibilities
- Design, develop, and maintain scalable ETL workflows using SSIS, Azure Data Factory (ADF), and Azure Databricks.
- Write complex and optimized SQL Server queries (T-SQL) for data transformation, integration, and reporting.
- Develop and maintain data pipelines for enterprise data warehousing and analytics solutions.
- Support, maintain, and enhance existing legacy SSIS packages and troubleshoot ETL-related issues.
- Develop interactive dashboards, reports, and visualizations using Power BI.
- Create advanced DAX measures, calculated columns, calculated tables, KPIs, and time-intelligence calculations.
- Design and optimize Power BI semantic models and datasets for performance and scalability.
- Implement data quality checks, data cleansing, validation, and auditing processes.
- Work on dimensional data modeling, including Star and Snowflake schemas.
- Optimize Power BI reports, DAX queries, and data refresh processes.




- Collaborate with Data Scientists, BI Developers, analysts, and business stakeholders to understand reporting and analytics requirements.
- Contribute to the design and implementation of scalable, secure, and reliable data engineering solutions.
- Maintain technical documentation and follow organizational development standards.

Required Technical Skills 1. Power BI & Advanced DAX

- Strong hands-on experience in Power BI dashboard and report development.
- Advanced knowledge of DAX, including complex measures, calculated columns, calculated tables, and time-intelligence functions.
- Experience with Power BI semantic models, datasets, and Row-Level Security (RLS).
- Solid understanding of Power BI performance optimization and data refresh management.

2. SQL Server & Database Development

- Strong expertise in Microsoft SQL Server.
- Proficiency in complex T-SQL queries, stored procedures, and query optimization.
- Experience with data transformation, database design, and performance tuning.

3. ETL & Data Integration

- Hands-on experience with SSIS package development, maintenance, and troubleshooting.
- Strong experience with Azure Data Factory (ADF).
- Experience designing and implementing data ingestion and transformation pipelines.
- Ability to work with and enhance legacy SSIS-based solutions.

4. Azure Databricks & Big Data





- Strong hands-on experience with Azure Databricks.
- Understanding of large-scale data processing and integration.
- Working knowledge of Python and PySpark.
- Experience building scalable data processing workflows.

5. Data Warehousing & Modeling

- Strong understanding of Data Warehousing concepts.
- Experience with dimensional modeling, Star Schema, and Snowflake Schema.
- Knowledge of data quality, cleansing, validation, and auditing.
- Experience designing analytical data structures and reporting layers.

Preferred Skills
- Exposure to Microsoft Fabric and OneLake.
- Experience with Power BI Premium / Microsoft Fabric environments.
- Knowledge of SSAS Tabular Models.
- Experience with DataOps and CI/CD pipelines.
- Familiarity with modern cloud analytics platforms.
- Microsoft Azure or Power BI certifications.

Experience & Qualifications
- 8–12 years of relevant experience in Data Engineering, BI Development, and Microsoft Data Technologies.
- Strong hands-on expertise in SQL Server, SSIS, Azure Data Factory, Azure Databricks, and Power BI.
- Proven experience developing enterprise-level data pipelines and reporting solutions.
- Strong analytical, troubleshooting, and problem-solving skills.
- Excellent communication skills and fluent English.
- Ability to collaborate with cross-functional and global teams.
- Comfortable working in the 12:30 PM – 9:30 PM IST shift.

Interested Candidates If you have strong experience in Power BI, Advanced DAX, SQL Server, SSIS, Azure Data Factory, and Azure Databricks, we would love to connect with you.

Apply now or tag someone who might be a great fit!

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