Senior Data Engineering & Strategy Consultant (Microsoft Fabric)

Gokool Digital; Hyderabad; Vor Ort; INR 4.000.000 - 6.000.000; Vollzeit

Zusammenfassung

Gokool Digital is seeking a Senior Data Engineering & Strategy Consultant to bridge high-level data strategy with hands-on execution. You will design and optimize enterprise data platforms using Microsoft Fabric and Azure Data Factory, aligning architectures with Data Governance and Data Quality frameworks.

As a senior member of consulting teams, you will deliver data solutions for strict Statements of Work, implement Medallion architectures, and ensure seamless integration with Power BI

Qualifikationen

• 3+ years of practical experience in a consulting-based senior role.
• Proven track record delivering against corporate SOWs.
• Strong knowledge of data and analytics strategies and roadmaps.
• Solid understanding of DMBOK data governance.

Aufgaben

• Design and implement Medallion Architectures (Bronze, Silver, Gold) on Fabric.
• Build ETL/ELT pipelines with Azure Data Factory / Fabric Data Pipelines.
• Ingest data from Dynamics 365 CE and Dynamics 365 F&O.
• Implement watermark-based incremental ingestion.
• Model Fact and Dimension tables in Gold layer for Power BI.
• Apply data governance, data quality, MDM, and reference data management.
• Collaborate on SOW-based consulting deliveries.
• Manage DevOps and Agile deployment pipelines.

Kenntnisse

Data strategy

Data governance

ETL/ELT pipelines

SQL transformation

Microsoft Fabric

Power BI integration

Git/DevOps

Agile/Scrum

DMBOK knowledge

Tools

Azure Data Factory

Microsoft Fabric

Power BI

Dataflows Gen2

Dynamics 365 CE

Dynamics 365 F&O

Jobbeschreibung

We are seeking a highly articulate and technically elite Senior Data Engineering & Strategy Consultant. In this role, you will act as a key participant on consulting teams, bridging the gap between high-level data strategy and hands‑on execution. You will design, build, and optimize enterprise data platforms using Microsoft Fabric and Azure Data Factory, while ensuring all architectures align with robust Data Governance and Data Quality frameworks.

Key Responsibilities

• Architecture & Data Engineering: Design and implement robust Medallion Architectures (Bronze, Silver, Gold layers) using Microsoft Fabric (Lakehouse, Warehouse, Pipelines, and Dataflows Gen2).
• Data Ingestion & Pipeline Orchestration: Build highly efficient ETL/ELT pipelines using Azure Data Factory / Fabric Data Pipelines to ingest complex data ecosystems out of Dynamics 365 CE and Dynamics 365 F&O.
• Incremental & Delta Ingestion: Build watermark-based ingestion systems utilizing metadata tracking via timestamp keys like ModifiedOn and ModifiedDateTime.
• Modeling & Reporting Integration: Build high-performance Fact and Dimension tables in the Gold layer using relational and star schema modeling. Align structures to feed Power BI semantic layers seamlessly.
• Data Strategy & Governance: Apply strong knowledge of data governance processes, data quality management controls, master data management (MDM), and reference data management.
• Consulting Delivery: Collaborate as a senior member of a consulting team to reliably deliver data-related solutions to strict Statements of Work (SOWs).
• Troubleshooting & QA: Proactively identify, debug, and resolve pipeline execution errors and data quality issues.
• DevOps & Agile Practices: Manage the data lifecycle using Git/DevOps and deployment pipelines within structured Agile/Scrum environments.

Qualifications & Experience Requirements

Consulting & Strategic Experience

• At least 3 years of practical experience in a consulting-based role (Senior Role) focusing heavily on delivering enterprise data solutions.
• Proven track record of being a key participant in consulting teams delivering directly against corporate SOWs.
• Strong knowledge of high-level data and analytics strategies, including supporting roadmaps, initiatives, and data programs.
• Solid understanding of best-practice data governance frameworks (e.g., DMBOK).
• Experience planning, strategizing, and executing large-scale data migration programs.

Core Technical Stack

• Microsoft Fabric Expert: In-depth knowledge of OneLake, Lakehouses, Warehouses, Pipelines, and Dataflows.
• Orchestration & Transformation: Deep experience with Azure Data Factory. Expert-level SQL transformation skills (T‑SQL, views, complex joins, and stored procedures).
• Source Ecosystems: Prior experience ingesting and transforming data from Dynamics 365 CE and Dynamics 365 F&O.
• Modern Architecture Knowledge: Strong understanding of relational modeling, star schema modeling, Big Data, and Cloud Data Warehouse designs.

Preferred Qualifications

• Added Advantage: Practical proficiency with Python or PySpark inside Spark environments for advanced transformations.
• Relevant industry certifications (e.g., DP-600: Implementing Analytics Solutions Using Microsoft Fabric, DP-203, or Data Governance certifications) are highly regarded.