Business Intelligence (BI) Developer / Data Engineer

InTandem is a nonprofit organization focused on social-emotional learning and child development, operating at meaningful scale with a growing data and analytics function. The Business Intelligence (BI) Developer / Data Engineer will work with internal technology leaders to build reliable data ingestion and transformation pipelines, prepare datasets for analytics, and ensure compliance with data privacy standards.

Responsibilities:

• Assess priority source systems (MDR, LMS, Marketo, Zendesk, ADP) including documentation, APIs, schemas, data quality issues, refresh needs, and business rules
• Define source-to-target mappings, transformation logic, history requirements, data quality rules, and dependencies for each source
• Build and configure ingestion, transformation, validation, and load processes using Microsoft Fabric, Azure, SQL, Dataflows Gen2, notebooks, and pipelines
• Align all pipeline work with the existing bronze/silver/gold medallion architecture, naming conventions, refresh patterns, and security standards
• Anonymize and de-identify ADP HR and payroll data in compliance with privacy and least-privilege access requirements before any broader use
• Prepare curated reporting datasets and semantic model inputs suitable for Power BI and analytics consumption
• Document pipelines, source-to-target mappings, data lineage, refresh schedules, monitoring procedures, and failure handling
• Conduct knowledge transfer sessions and deliver handoff materials so internal staff can monitor, troubleshoot, maintain, and extend the solution independently

Requirements:

• Hands-on BI Developer or Data Engineer with strong experience in Microsoft Fabric, Azure data services, OneLake, Dataflows Gen2, notebooks, and pipeline configuration
• Proven experience integrating third-party source systems via APIs, exports, and semi-structured data formats — including undocumented or inconsistently structured systems
• Solid SQL proficiency with experience in source-system profiling, source-to-target mapping, dimensional modeling, and data transformation
• Experience working within medallion lakehouse architectures (bronze/silver/gold) and adhering to established design standards and naming conventions
• Power BI integration experience including semantic modeling, DAX, report-ready dataset design, refresh strategy, and performance optimization
• Familiarity with HR/payroll data handling, including anonymization, de-identification, and least-privilege access requirements
• Experience with GTM and marketing platforms such as Marketo, as well as customer support platforms such as Zendesk
• Strong documentation skills and ability to deliver clear operational handoff materials for internal technical teams
• Excellent stakeholder communication with demonstrated ability to run discovery, surface risks, and align on requirements with non-technical business users
• Comfortable operating independently in a defined-scope, time-boxed engagement with a fixed handoff date