DATA202: Senior Data Engineer, ETL and Data Platform

JerseySTEM is a mission-driven professional network dedicated to improving access to STEM education for underserved middle school girls in New Jersey. They are seeking experienced Data Engineers to stabilize and scale core data pipelines that power analytics and reporting, focusing on operational reliability and long-term platform sustainability.

Responsibilities:

• Design, build, and maintain production grade ETL pipelines using MySQL and external data sources
• Integrate third party systems and APIs, including Integrate.io
• Implement CDC and incremental loading strategies for efficient and reliable refresh
• Manage schema changes, late arriving data, and source inconsistencies
• Design and maintain analytical models including fact and dimension tables
• Build and evolve data marts and a centralized data warehouse
• Implement monitoring, documentation, and pipeline standards
• Ensure data quality, consistency, and operational resilience
• Provide technical leadership and define data engineering best practices

Requirements:

• Seven or more years of hands on experience in data engineering or data platform roles
• Strong experience working with MySQL in analytical or hybrid environments
• Proven experience integrating external APIs and third party systems
• Demonstrated experience implementing CDC or incremental load patterns
• Deep understanding of dimensional modeling and warehouse architecture
• Advanced SQL skills and strong proficiency in Python or similar languages
• Ability to operate independently and own pipelines end to end