Sr. Data Engineer- Microsoft BI

R3 Consultant; Navi Mumbai; On-site; INR 4,500,000 - 6,500,000; Full time

Job summary

R3 Consultant in Mumbai (Airoli) seeks a Senior Data Engineer Microsoft BI with 8+ years' experience to design and implement enterprise BI solutions in a banking environment.

You will develop and maintain MSBI components, ETL with SSIS, reports with SSRS and dashboards in Power BI, and build SSAS Tabular models. Collaboration with analysts, architects, and cross-functional teams is essential.

Qualifications

• 8+ years of experience in Microsoft BI/MSBI technologies.
• Strong expertise in SSIS, SSRS, and SSAS.
• Proficient in SQL Server 2017/2022 and advanced SQL.
• Experience building data warehouses and data modelling.
• Develops dashboards and reports with Power BI.
• Knowledge of Azure DevOps and CI/CD pipelines.
• Experience in banking/financial services environment.
• Experience with Agile/SDLC methodologies.

Responsibilities

• Design, develop, and maintain Microsoft BI solutions to meet business requirements.
• Build and maintain ETL workflows using SSIS.
• Develop reports and dashboards using SSRS and Power BI.
• Design and maintain SSAS Tabular models with MDX/DAX.
• Work on SQL Server 2017/2022, complex SQL queries, and query optimization.
• Design and maintain data warehouse architecture, data models, and historization.
• Develop CI/CD pipelines using Azure DevOps.
• Collaborate with business analysts, architects, product managers, and cross-functional teams.
• Participate in code reviews, technical documentation, testing, deployment, and production support.
• Mentor junior team members and promote coding standards and quality practices.

Skills

MSBI stack experience

SSIS

SSRS

SSAS

SQL Server 2017/2022

ETL development

Power BI

MDX/DAX

Data warehousing

Azure DevOps

Agile/SDLC

Banking domain

Education

Bachelor's degree in Computer Science

Tools

Kubernetes

Airflow

PySpark

Vertica

PowerShell

Tableau

Cognos

Qlik

Job description

Job Title: Senior Data Engineer Microsoft BI

Experience: 8+ Years
Location: Airoli, Mumbai
Industry Preference: Banking / Financial Services

Job Summary

We are seeking an experienced Senior Data Engineer Microsoft BI with strong expertise in the Microsoft Business Intelligence (MSBI) stack, data warehousing, data modelling, and enterprise BI solutions. The candidate will design and develop BI solutions, maintain existing applications, optimize data processing, and collaborate with business analysts, architects, and technical teams in a banking environment.

Key Responsibilities

• Design, develop, and maintain Microsoft BI solutions to meet business requirements.
• Develop and support BI applications, enhancements, bug fixes, and production issues.
• Build and maintain ETL workflows using SQL Server Integration Services (SSIS).
• Develop reports and dashboards using SSRS and Power BI.
• Design and maintain SSAS Tabular models, using MDX/DAX as required.
• Work on SQL Server 2017/2022, complex SQL queries, query optimization, and data manipulation.
• Design and maintain data warehouse architecture, data models, and data historization.
• Develop and maintain CI/CD pipelines using Azure DevOps.
• Collaborate with business analysts, architects, product managers, and cross-functional teams.
• Participate in code reviews, technical documentation, testing, deployment, and production support.
• Identify opportunities for process automation and build proof of concepts for new solutions.
• Mentor junior team members and promote coding standards and quality practices.

Mandatory Skills

• 8+ years of experience in Microsoft BI / MSBI technologies
• Strong expertise in SSIS, SSRS, and SSAS
• SQL Server 2017/2022, complex SQL queries, and query optimization
• ETL development and data integration
• Power BI reporting and dashboard development
• SSAS Tabular Modelling, MDX, and DAX
• Data warehousing, data modelling, and historization
• Azure DevOps and CI/CD pipelines
• Experience with Agile/SDLC methodologies
• Experience in a banking or financial services environment

Good-to-Have Skills

• C# development for SSIS
• Python, PySpark, and Airflow
• Kubernetes and microservices
• Vertica or other MPP databases
• PowerShell scripting
• Cognos, Tableau, or Qlik

Education: Bachelor's degree in Computer Science or a related discipline, or relevant MSBI experience.

Preferred Candidate Profile: Senior-level candidates with strong hands-on experience across SSIS, SSRS, SSAS, SQL Server, and Power BI, preferably in banking or financial services, are encouraged to apply.