The ETL Developer will support the organization’s transition from SQL Server–based data infrastructure to Snowflake. While the role is formally housed within the Data Governance team to ensure adherence to enterprise data standards, security, and quality practices, the position will be 100% dedicated to supporting the Research, Evaluation, and Analytics (REA) department. This role will design, build, and optimize ELT pipelines and enable high-quality, well-governed analytic datasets to support research, evaluation, reporting, and decision-making across the organization.

This position plays a critical role in modernizing the organization’s data infrastructure while ensuring data quality, trust, and usability for research and analytics. The work directly supports evidence-based decision-making by enabling timely access to reliable, well-structured data.

Key Responsibilities

Data Migration & ELT Development

• Design, develop, and maintain ELT pipelines to migrate data from SQL Server to Snowflake

• Refactor and modernize existing SQL Server–based processes for Snowflake architecture and performance

• Implement efficient data loading, transformation, and validation processes using Snowflake-native capabilities

• Optimize queries, storage, and compute usage for cost and performance

Data Governance & Quality

• Partner with the Data Governance team to ensure ELT processes align with data standards, definitions, and quality rules

• Implement data validation, auditing, and reconciliation checks during migration

• Support metadata documentation, data lineage, and transparency for analytical datasets

• Ensure compliance with privacy, security, and regulatory requirements

Research, Evaluation, and Analytics Support

• Work closely with REA analysts, researchers, and evaluators to understand data needs and analytic workflows

• Translate research and reporting requirements into scalable ELT solutions

• Support development of clean, analysis-ready datasets optimized for statistical analysis and reporting tools

• Troubleshoot data issues impacting analytics, dashboards, and research outputs

Collaboration & Knowledge Transfer

• Collaborate with data engineers, analysts, and governance partners across teams

• Document ELT processes, migration decisions, and best practices

• Support knowledge transfer to internal staff to ensure sustainability beyond the contract period