Senior Business Intelligence Specialist

Fragomen; Ernakulam; On-site; INR 800,000 - 1,300,000; Full time

Job summary

Fragomen is seeking a Senior Data Engineer to design scalable data platforms using Microsoft Fabric, building Lakehouse and Data Warehouse solutions aligned with Medallion Architecture. You will mentor engineers and collaborate with product/BI leaders to evolve the analytics platform.

You will drive best practices, data governance, and security, handling large-scale ingestion and analytics workloads while ensuring reliability and cost efficiency across environments.

Qualifications

• 8-10+ years of data engineering experience in modern data platforms.
• Hands-on with Microsoft Fabric components and SQL Server/T-SQL.
• Experience with on-premises to cloud data integration and Medallion Architecture.
• Strong data governance, security, and DevOps practices.

Responsibilities

• Architect end-to-end Lakehouse and Data Warehouse solutions with Microsoft Fabric.
• Lead design following Medallion Architecture and data modelling standards.
• Establish data engineering standards for pipelines, security, and lifecycle.
• Drive large-scale data ingestion, real-time pipelines, and analytics workloads.
• Coach engineers and align with Product/BI leaders on data strategy.
• Enforce CI/CD strategies across environments and manage releases.

Skills

Microsoft Fabric

Lakehouse

Data Warehouse

Medallion Architecture

SQL Server

T-SQL

Data governance

DevOps

Cost optimization

Azure

Education

Bachelors or Masters in CS/IT

Tools

Notebooks

Dataflows

Purview

Semantic Models

Job description

Job Description

We are seeking an experienced Senior Data Engineer to design, architect, and optimize scalable data platforms using Microsoft Fabric. The role focuses on building enterprise-grade Lakehouse and Data Warehouse solutions following the Medallion architecture, developing robust data pipelines from SQL Server (on-prem) sources, and enabling analytics and reporting at scale. This role requires a blend of technical expertise, problem-solving skills, and the ability to work collaboratively with cross-functional team.

Youll mentor engineers, drive best practices, and partner with product/BI leaders to evolve the analytics platform.

Key Responsibilities

• Architect and implement end-to-end Lakehouse and Data Warehouse solutions using Microsoft Fabric
• Design and implement enterprise-grade Lakehouse and Data Warehouse solutions following the Medallion Architecture
• Establish and enforce data engineering standards for data modelling, pipelines, naming conventions, security, and lifecycle management
• Lead delivery of complex, high-impact data initiatives, including large-scale ingestion, near-real-time pipelines, and performance-optimized analytics workloads
• Ensure the platform meets enterprise requirements for scalability, reliability, cost efficiency, and performance
• Champion data governance & security (Purview classifications, RBAC/ABAC, PII handling, row-level/object-level security).
• Design and enforce CI/CD strategies across environments; orchestrate releases and incident/problem management.
• Act as a trusted advisor to Product, BI, and Analytics leaders on data strategy, SLAs, and roadmap planning

Technical Skill

• Bachelors or Masters degree in Computer Science, IT, or equivalent experience.
• 8 - 10+ years of experience in data engineering and modern data platforms
• Proven hands-on expertise with Microsoft Fabric, including Lakehouse, Warehouse, Pipelines, Notebooks, Dataflows, and Semantic Models
• Strong background in SQL Server and T-SQL, with experience integrating on-premises and cloud data sources
• Deep understanding of modern data architecture patterns, including Medallion Architecture, CDC, and SCD modelling
• Demonstrated experience delivering enterprise-scale, high-volume data platforms
• Strong track record in data governance, security, DevOps, and cost optimization
• Ability to communicate complex technical concepts to executive and non-technical stakeholders
• Azure experience preferred, exposure to other cloud platforms (AWS, GCP) is a plus
• Nice to have Certifications like DP-600, DP-203, AZ-305

All offers and/or employment contracts are contingent upon the successful completion of the Firms pre-employment screening process. This process may include verifying the candidates identity, confirming legal authorization to work in the offered positions location, and conducting a comprehensive background check, where permitted by local regulations. We use limited AIassisted tools for administrative screening purposes only - never for decisionmaking. All hiring decisions are made by people. Applicants may have rights to information and explanations regarding the use of such tools, or request human review, as required by applicable regional laws. .