Business Intelligence (BI) Developer / Data Engineer

The client is a nonprofit organization focused on social-emotional learning and child development, operating at meaningful scale with a growing data and analytics function. The team has already designed and implemented a Microsoft Azure/Fabric lakehouse and is now ready to expand it — bringing in priority source-system data from five distinct platforms. With an established medallion architecture, naming conventions, and security standards already in place, this engagement is focused on execution: source assessment, pipeline development, transformation, validation, documentation, and a clean internal handoff. The selected contractor will work directly with internal technology leaders and reporting stakeholders to define source-to-target mappings, build reliable ingestion and transformation pipelines, and prepare curated datasets ready for Power BI and analytics consumption. Source systems in scope include an MDR platform, an internal LMS, Marketo, Zendesk, and ADP (with required anonymization/de-identification of HR and payroll data) . Timeline : 4 mont hsLevel of Suppo rt: 160 hours per mon thStart Date : AS APRat e: $80/ho urObjective s:Assess priority source systems (MDR, LMS, Marketo, Zendesk, ADP) including documentation, APIs, schemas, data quality issues, refresh needs, and business rul esDefine source-to-target mappings, transformation logic, history requirements, data quality rules, and dependencies for each sour ceBuild and configure ingestion, transformation, validation, and load processes using Microsoft Fabric, Azure, SQL, Dataflows Gen2, notebooks, and pipelin esAlign all pipeline work with the existing bronze/silver/gold medallion architecture, naming conventions, refresh patterns, and security standar dsAnonymize and de-identify ADP HR and payroll data in compliance with privacy and least-privilege access requirements before any broader u sePrepare curated reporting datasets and semantic model inputs suitable for Power BI and analytics consumpti onDocument pipelines, source-to-target mappings, data lineage, refresh schedules, monitoring procedures, and failure handli ngConduct knowledge transfer sessions and deliver handoff materials so internal staff can monitor, troubleshoot, maintain, and extend the solution independent ly Ideal Candida te:Hands-on BI Developer or Data Engineer with strong experience in Microsoft Fabric, Azure data services, OneLake, Dataflows Gen2, notebooks, and pipeline configurat ionProven experience integrating third-party source systems via APIs, exports, and semi-structured data formats — including undocumented or inconsistently structured syst emsSolid SQL proficiency with experience in source-system profiling, source-to-target mapping, dimensional modeling, and data transformat ionExperience working within medallion lakehouse architectures (bronze/silver/gold) and adhering to established design standards and naming conventi onsPower BI integration experience including semantic modeling, DAX, report-ready dataset design, refresh strategy, and performance optimizat ionFamiliarity with HR/payroll data handling, including anonymization, de-identification, and least-privilege access requireme ntsExperience with GTM and marketing platforms such as Marketo, as well as customer support platforms such as Zendesk, prefer redStrong documentation skills and ability to deliver clear operational handoff materials for internal technical te amsExcellent stakeholder communication with demonstrated ability to run discovery, surface risks, and align on requirements with non-technical business us ersComfortable operating independently in a defined-scope, time-boxed engagement with a fixed handoff d ate