ETL Manager

Ariel Partners•New York, NY

1d•$95 - $110

About The Position

The ETL Manager is responsible for leading the design, development, implementation, and technical oversight of enterprise data integration solutions supporting the New York City Department of Education's (NYC DOE) Special Education Office. This role oversees the development of data marts and data warehouses by designing Extract, Transform, and Load (ETL) processes that integrate data from multiple source systems into secure, reliable, and high-performing reporting environments. The ETL Manager ensures all data integration activities align with business priorities, enterprise architecture standards, and the Software Development Life Cycle (SDLC) to support regulatory reporting, operational analytics, and business intelligence initiatives.

Requirements

Bachelor's degree in Computer Science, Information Systems, Data Management, or a related field.
Minimum 8 years of experience designing, developing, and managing enterprise ETL and data warehouse solutions.
Extensive experience with Microsoft SQL Server, SQL programming, stored procedures, and database optimization.
Experience designing and supporting enterprise data marts and data warehouses.
Strong knowledge of ETL architecture, data integration, data transformation, and data quality principles.
Experience supporting Business Intelligence and reporting environments.
Proficiency with Microsoft Visio for technical documentation and data flow modeling.
Experience with Business Intelligence (BI) tools and reporting platforms.
Strong analytical, troubleshooting, and problem-solving skills.
Excellent written and verbal communication skills.
Experience working within Agile and/or Waterfall SDLC methodologies.

Nice To Haves

Experience supporting large-scale government, education, or public sector technology projects is preferred.

Responsibilities

Lead the technical oversight of enterprise ETL development and data integration initiatives supporting the Special Education Office.
Design, develop, and implement scalable ETL solutions to extract, transform, and load data into enterprise data marts and data warehouses.
Analyze business requirements and translate them into efficient data integration and transformation solutions.
Design and maintain data mapping specifications, ETL workflows, and technical documentation.
Collaborate with business analysts, data architects, developers, and reporting teams to ensure accurate and timely data delivery.
Optimize ETL processes for performance, reliability, scalability, and data quality.
Troubleshoot data integration issues and implement corrective actions.
Ensure compliance with enterprise data governance, security, and development standards.
Integrate established Software Development Life Cycle (SDLC) methodologies and best practices into daily team activities.
Support Business Intelligence, reporting, dashboard development, and regulatory reporting initiatives.
Mentor technical staff and provide guidance on ETL design, SQL development, and data management best practices.