ETL Manager
On-siteManhattan, New York, United States
Job Summary
Lead technical oversight of enterprise ETL development and data integration initiatives for 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 to translate them into efficient data integration and transformation solutions, while designing and maintaining 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, and troubleshoot data integration issues to implement corrective actions. Ensure compliance with enterprise data governance, security, and development standards while integrating established SDLC methodologies into daily team activities. Mentor technical staff on ETL design, SQL development, and data management best practices.
Required Qualifications
- 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
- Strong analytical, troubleshooting, and problem-solving skills
- Excellent written and verbal communication skills
- Experience working within Agile and/or Waterfall SDLC methodologies
Desired Qualifications
- Experience supporting large-scale government, education, or public sector technology projects
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.