Microsoft Fabric Data Lead (P&C Preferred)

Derex Technologies Inc•Erie, PA

7d•Onsite

About The Position

The Microsoft Fabric Core Lead Engineer leads the design, development, implementation, and support of enterprise-scale data and analytics solutions using Microsoft Fabric. The role provides technical leadership, makes architecture decisions, mentors engineering teams, and ensures delivery of scalable, secure, and high-performing data platforms. The position designs enterprise data platforms using Microsoft Fabric components, develops data pipelines and models, integrates data from cloud and on-premises systems, and supports analytics, AI, and business intelligence workloads. It also covers platform performance optimization, security and governance, DevOps automation, AI and advanced analytics, production operations, stakeholder engagement, and team mentoring. The role is located in Pennsylvania and requires onsite presence from the first day.

Requirements

Bachelor's or master's degree in Computer Science, Information Technology, Engineering, or a related field.
10 or more years of experience in data engineering, data warehousing, or cloud data platform development.
4 or more years of hands-on experience with Microsoft Azure Data Platform technologies.
2 or more years of hands-on experience with Microsoft Fabric in enterprise implementations.
Strong expertise in SQL, PySpark, Python, and Spark optimization.
Experience with Microsoft Fabric components including OneLake, Lakehouse, Data Warehouse, Data Factory, Power BI, and Real-Time Intelligence.
Experience with Azure Data Lake Storage (ADLS), Azure DevOps, GitHub, and CI/CD pipelines.
Strong knowledge of dimensional data modeling, ETL/ELT architecture, and data governance.
Experience leading technical teams and delivering large-scale enterprise data modernization programs.

Nice To Haves

Microsoft Certified: Fabric Analytics Engineer Associate (DP-600).
Microsoft Azure Data Engineer Associate (DP-203).
Experience with Databricks, Synapse Analytics, Azure AI Services, or Microsoft Purview.
Knowledge of Agile/Scrum delivery methodologies.
Strong communication, stakeholder management, and problem-solving skills.
Property and Casualty (P&C) experience is preferred, as indicated in the job title.

Responsibilities

Lead end-to-end implementation of Microsoft Fabric solutions across enterprise programs.
Define technical architecture, engineering standards, and best practices for Microsoft Fabric adoption.
Provide technical leadership to data engineers and developers; review solution designs, code, and deployment strategies.
Design and implement enterprise data platforms using OneLake, Lakehouse, Data Warehouse, Data Factory, Real-Time Intelligence, Data Engineering, and Power BI.
Architect scalable, cloud-native data solutions for analytics, AI, and business intelligence workloads, and establish reusable design patterns and reference architectures.
Design and develop ETL/ELT pipelines using Microsoft Fabric Data Factory and Spark Notebooks; integrate structured, semi-structured, and unstructured data from cloud and on-premises systems.
Implement data transformation, cleansing, validation, orchestration, and reliable, performant data ingestion processes.
Design dimensional models, Lakehouse architectures, and enterprise data warehouses; develop semantic models and datasets for Power BI reporting and self-service analytics.
Collaborate with business teams to translate analytical requirements into scalable data solutions.
Optimize Spark workloads, SQL Warehouse performance, and OneLake storage utilization; apply partitioning, indexing, caching, and workload optimization strategies, and resolve performance bottlenecks.
Implement enterprise security using Microsoft Entra ID, RBAC, and Fabric workspace security; define data quality, lineage, cataloging, auditing, and compliance governance policies.
Ensure compliance with enterprise security, privacy, and regulatory standards.
Implement CI/CD pipelines using Azure DevOps or GitHub and automate deployments of Fabric artifacts across Development, QA, UAT, and Production environments.
Manage source control, release management, and deployment automation.
Enable AI, machine learning, and Copilot capabilities in Microsoft Fabric; support data science workloads and collaborate with AI teams to operationalize predictive analytics and intelligent data solutions.
Lead production deployments and post-production support; monitor platform health, troubleshoot incidents, and ensure SLA compliance.
Implement disaster recovery, backup, and business continuity strategies.
Collaborate with enterprise architects, product owners, business stakeholders, and cross-functional teams; participate in architecture reviews and technical governance meetings.
Communicate technical solutions and project status to senior leadership.
Mentor engineers, conduct code and design reviews, lead knowledge-sharing sessions, and drive continuous improvement and engineering excellence.