Senior Fabric Data Engineer

Provitious Technologies; Gandhinagar; On-site; INR 2,800,000 - 5,600,000; Full time

Job summary

Provitious Technologies is seeking an experienced Microsoft Fabric Data Engineer to design a global HR analytics platform, integrating regional HRIS sources and building governed data layers using OneLake and Fabric. You will craft secure pipelines, ensure data quality, and enable Power BI reporting across regions.

Responsibilities include designing ingestion pipelines, mapping and transforming data, handling multilingual formats, and implementing robust data governance and security practices

Qualifications

• Experience designing and implementing enterprise HR data platforms.
• Strong data integration, modeling, and governance capabilities.
• Proven track record with Microsoft Fabric and modern Azure data services.
• Experience handling confidential/sensitive data and data lineage.

Responsibilities

• Design and implement ingestion pipelines using Microsoft Fabric Data Factory.
• Integrate HRIS systems via REST APIs, SFTP, CSV, Excel and secure interfaces.
• Build Bronze, Silver and Gold data layers in OneLake/Fabric.
• Develop source-specific mapping and transformation logic.
• Handle multilingual data, formats, and translations; implement loading strategies.
• Develop data quality, validation, and lineage monitoring.
• Support Power BI semantic models and reporting.

Skills

Power BI

DAX

HRIS Integration

HR Data Models

Data Governance

Microsoft Purview

Enterprise Data Warehousing

REST APIs

Data Validation

Data Lineage

Tools

Microsoft Fabric

OneLake

Fabric Data Factory

Lakehouse

Delta Lake

Parquet

Azure Key Vault

Job description

Company Description

Provitious Technologies helps businesses automate, scale, and innovate through smart, measurable technology solutions. The company designs adaptive systems that enhance performance, offering services such as Custom Software Development, Business Process Automation, and Microsoft Power Platform solutions. With core expertise in Power BI, Power Automate, PowerApps, Cloud Computing, DevOps, and IT Consulting, Provitious Technologies serves diverse industries including Real Estate, Healthcare, Supply Chain, Finance, Government, and more. Guided by precision and collaboration, the team focuses on simplifying technology, empowering teams, and enabling data-driven decisions. Based in India, Provitious Technologies partners with clients worldwide to build efficient, scalable, and seamless digital solutions.

Job Description

We are looking for an experienced Microsoft Fabric Data Engineer to design and implement a global HR data platform using Microsoft Fabric, OneLake and Data Factory.

The candidate will work on integrating multiple regional HRIS platforms and heterogeneous data sources into a governed enterprise HR analytics platform, supporting secure data processing, transformation, quality validation and Power BI reporting.

Key Responsibilities

• Design and implement ingestion pipelines using Microsoft Fabric Data Factory.
• Integrate HRIS systems through REST APIs, SFTP, CSV, Excel and secure file-based interfaces.
• Build Bronze, Silver and Gold data layers in OneLake/Fabric.
• Develop source-specific mapping and transformation logic.
• Handle multilingual data, different layouts, date formats, number formats and code translations.
• Implement incremental and full-load strategies.
• Develop duplicate prevention and reconciliation processes.
• Implement error handling, retry and exception/replay mechanisms.
• Build data quality and freshness validation.
• Develop canonical/global HR data models.
• Implement secure handling of confidential HR data.
• Work with the security architect to implement least-privilege access.
• Support Power BI semantic models and reporting.
• Implement monitoring, audit and data lineage.
• Support onboarding of additional HRIS systems.

Required Skiis

Microsoft Fabric: Microsoft Fabric, OneLake, Fabric Data Factory, Lakehouse, Fabric Pipelines, Dataflows Gen2

Data Engineering: SQL, ETL/ELT, Data Transformation, Data Modeling, Bronze/Silver/Gold Architecture, Delta Lake, Parquet

Data Integration: REST APIs, JSON, SFTP, CSV, Excel, API Authentication, Secure File Transfer, Incremental and Full Data Loads

Data Quality & Processing: Data Validation, Data Reconciliation, Duplicate Detection, Error Handling, Retry Mechanisms, Data Mapping, Data Lineage

Security & Governance: Microsoft Entra ID, Role-Based Access Control (RBAC), Fabric Permissions, OneLake Security, Managed Identities, Azure Key Vault, Least-Privilege Access

Azure & Cloud: Microsoft Azure, Azure Storage, Azure Integration Services, Cloud Data Platforms

Preferred Skills:Power BI, DAX, HRIS Integration, HR Data Models, Data Governance, Microsoft Purview, Enterprise Data Warehousing

5+ years data engineering experience with at least: 2+ years Microsoft Fabric / modern Azure data platform experience and demonstrated experience with:

• Multiple source integrations
• Enterprise data platforms
• Confidential/sensitive data
• Data warehouse/lakehouse implementations
• Production-grade data pipelines