Senior Data & AI Engineer - Microsoft Fabric

Exponentia.ai; Mumbai; On-site; INR 1,800,000 - 3,500,000; Full time

Job summary

Exponentia.ai in Mumbai is seeking a Senior Engineer - Data & AI to architect and optimize enterprise-scale data platforms using Microsoft Fabric. You will lead end-to-end cloud data solutions and collaborate across architects, analysts, and stakeholders.

The ideal candidate brings 6+ years in data engineering with hands-on Fabric experience, strong SQL/Python, and Azure data services expertise. This role focuses on scalable, secure analytics platforms for BI and AI.

Qualifications

• 6+ years in Data Engineering, Cloud Data Platforms, or Analytics Engineering.
• 2+ years hands-on with Microsoft Fabric and related Azure data tools.
• Strong in SQL, Python, and PySpark; experience with data modeling.

Responsibilities

• Architect, build, and optimize enterprise data platforms using Fabric.
• Design scalable Data Lakehouse architectures and ELT/ETL pipelines.
• Implement data governance, security, monitoring, and cost controls.
• Lead technical discussions, reviews, and mentor engineers.
• Deliver end-to-end cloud data solutions and collaborate with stakeholders.

Skills

Microsoft Fabric

Data Engineering

Power BI

Python

SQL

PySpark

OneLake

Lakehouse

Azure Data Factory

Azure Synapse

CI/CD

ETL/ELT

Data Governance

Security

Education

Bachelor's or Master's in CS

Tools

Azure DevOps

Git

Microsoft Purview

Job description

About the Role

We are seeking a Senior Engineer - Data & AI who can architect, build, and optimize enterprise-scale data platforms using Microsoft Fabric. This role requires a strong technical leader with expertise in modern data engineering, analytics, cloud-native architectures, and enterprise data integration.

Job Description

We are seeking a Senior Engineer - Data & AI who can architect, build, and optimize enterprise-scale data platforms using Microsoft Fabric. This role requires a strong technical leader with expertise in modern data engineering, analytics, cloud-native architectures, and enterprise data integration.

You will collaborate with solution architects, business analysts, data scientists, and stakeholders to design scalable, secure, and high-performing data solutions that enable business intelligence, AI, and advanced analytics. The ideal candidate is passionate about Microsoft Fabric, has strong hands-on engineering skills, and thrives in delivering end-to-end cloud data solutions.

Key Fabric Platform Engineering

• Design, develop, and maintain enterprise data platforms using Microsoft Fabric.
• Build scalable Lakehouse architectures using OneLake, Lakehouse, Warehouse, and Data Engineering capabilities.
• Develop robust ELT/ETL pipelines using Fabric Data Factory and Dataflows Gen2.
• Optimize data ingestion, transformation, and storage for performance and scalability.
• Implement enterprise-grade data governance, monitoring, and security practices.

Cloud Data Engineering

• Design and implement modern cloud-based data architectures.
• Develop batch and near real-time data pipelines from multiple enterprise sources.
• Integrate structured, semi-structured, and unstructured data into unified analytics platforms.
• Build reusable frameworks for ingestion, transformation, orchestration, and deployment.
• Optimize workloads for performance, reliability, and cost efficiency.

Solution Architecture & Technical Leadership

• Collaborate with solution architects to define scalable enterprise data solutions.
• Translate business requirements into technical designs and implementation strategies.
• Lead technical discussions, architecture reviews, and solution design workshops.
• Mentor engineering teams and promote engineering best practices.
• Drive reusable architecture patterns and coding standards.

Delivery & Agile Execution

• Own end-to-end delivery of Microsoft Fabric solutions.
• Participate in Agile ceremonies and sprint planning activities.
• Perform code reviews, performance optimization, and production support.
• Collaborate with DevOps teams for CI/CD implementation and deployment automation.
• Ensure timely delivery while maintaining engineering quality standards.

Stakeholder Collaboration

• Work closely with business stakeholders, product owners, and consulting teams.
• Participate in solution discovery workshops and client discussions.
• Communicate technical concepts effectively to business users.
• Align technical solutions with business objectives and enterprise architecture standards.

Nice To Have

• Develop semantic models and enterprise reporting solutions.
• Enable Power BI Direct Lake and Fabric-native reporting capabilities.
• Design analytics-ready datasets for business users and executive dashboards.
• Support self-service analytics by implementing reusable semantic models.
• Ensure high data quality and consistency across reporting solutions.

Ideal Candidate Profile

• 6+ years of experience in Data Engineering, Cloud Data Platforms, or Analytics Engineering.
• 2+ years of hands-on experience with Microsoft Fabric.
• Strong expertise in:
• Microsoft Fabric
• OneLake
• Lakehouse
• Fabric Warehouse
• Data Factory
• Dataflows Gen2
• Real-Time Analytics
• Power BI
• Strong programming experience in:
• SQL (Advanced)
• Python
• PySpark
• Experience in:
• Data Modeling (Star Schema, Snowflake Schema, Kimball)
• ETL/ELT Frameworks
• Data Warehousing
• Delta Lake
• CI/CD implementation
• Experience integrating data from Azure SQL, SQL Server, REST APIs, SAP, Oracle, SharePoint, Dynamics 365, and other enterprise systems.
• Strong understanding of Azure ecosystem including Azure Storage, Azure Data Factory, Azure Synapse, Azure Key Vault, and Azure Active Directory.
• Experience implementing enterprise data governance, security, lineage, and monitoring.
• Experience working in consulting or client-facing environments.
• Strong analytical, troubleshooting, and problem-solving skills.

Preferred Qualifications

• Bachelor\'s or Master\'s degree in Computer Science, Engineering, Information Technology, or related field.
• Microsoft Certifications such as:
• DP-600: Fabric Analytics Engineer Associate
• DP-700: Fabric Data Engineer Associate
• DP-203: Azure Data Engineer Associate
• Experience with:
• Azure DevOps
• Git
• Microsoft Purview
• AI/ML data pipelines
• Generative AI solutions
• Microsoft Copilot
• Familiarity with Agile delivery methodologies and DevOps practices.

(ref:hirist.tech)