Program Director, CDL

Design and build data pipelines using Azure Data Factory to ingest data from the student information system into a Microsoft Fabric Lakehouse.

Develop and maintain Bronze and Gold layer Delta tables following Medallion Architecture principles.

Build and optimize Power BI semantic models, including relationships, DAX measures, and row-level security across multiple business domains.

Create denormalized SQL views on SQL Server to pre-stage data for Lakehouse ingestion.

Maintain and improve incremental load patterns using watermark-based pipeline strategies.

Collaborate with the Data Architect to design Gold layer table structures that support clean, maintainable reporting.

Assist in retraining reporting staff on Power BI and the new Fabric environment alongside the Data Architect.

Contribute to data governance standards, including naming conventions, documentation, and model design guidelines.

Support the future development of conversational AI agents built on top of the Fabric data layer.

Monitor pipeline health, troubleshoot failures, and maintain data quality across the Lakehouse.

Requirements

Hands‑on experience with Microsoft Fabric, including Lakehouses, Delta Lake, and OneLake.

Proficiency in SQL — complex joins, CTEs, window functions, and query optimization.

Experience building and maintaining Azure Data Factory pipelines.

Familiarity with Medallion Architecture (Bronze, Silver, and Gold layers).

Power BI experience, including semantic model design and DAX measure development.

Ability to communicate technical concepts clearly to non-technical audiences.

Comfort working independently in a small team environment with minimal supervision.

Strong attention to data quality and validation.

Experience with Python or PySpark for data transformation.

Microsoft certifications such as PL-300, DP-700, or AZ-900.

Experience with SQL Server, including stored procedures, views, and replication.

Familiarity with Direct Lake mode in Power BI semantic models.

Experience with incremental load patterns and watermark-based pipeline strategies.

Prior work in education, nonprofit, or mission-driven organizations.

Core Competencies
Demonstrates expertise in designing and building data pipelines using Azure Data Factory and Microsoft Fabric, with a strong focus on data quality, governance, and reporting standards. Proficient in SQL, Power BI, and Medallion Architecture, with the ability to communicate technical concepts effectively to diverse audiences.

Highest-signal resume keywords

Azure Data Factory Pipeline Development

Power BI Semantic Model Design

SQL Proficiency

Medallion Architecture Familiarity

Microsoft Fabric Experience

ATS Optimization Keywords
Hard Skills

SQL

DAX

Python

PySpark

Delta Lake

Incremental Load Patterns

Watermark-Based Pipeline Strategies

Complex Joins

CTEs

Query Optimization

Soft Skills

Clear Communication

Attention to Detail

Independent Work

Team Collaboration

Certifications & Qualifications

PL-300

DP-700

AZ-900

Industry Keywords

Education

Nonprofit

Mission-Driven Organizations

Data Governance

Reporting Standards

Tools & Technologies

Microsoft Fabric

Power BI

SQL Server

Lakehouse

Direct Lake Mode

#J-18808-Ljbffr