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.

• Hands‑on experience with Microsoft Fabric, including Lake houses, Delta Lake, and One Lake.
• 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.

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.

• Azure Data Factory Pipeline Development
• Power BI Semantic Model Design
• SQL Proficiency
• Medallion Architecture Familiarity
• Microsoft Fabric Experience

• SQL
• DAX
• Python
• Py Spark
• Delta Lake
• Incremental Load Patterns
• Watermark-Based Pipeline Strategies
• Complex Joins
• CTEs
• Query Optimization

• Clear Communication
• Attention to Detail
• Independent Work
• Team Collaboration

• PL-300
• DP-700
• AZ-900

• Education
• Nonprofit
• Mission-Driven Organizations
• Data Governance
• Reporting Standards

• Microsoft Fabric
• Power BI
• SQL Server
• Lakehouse
• Direct Lake Mode