Senior Data Engineer, ETL, Data Platform
JerseySTEM
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
Job Level
About the role
- 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
Benefits
- pro-bono (unpaid) position
- minimum six-month commitment of approximately six flexible hours per week
- $100 refundable deposit, returned after six months of active membership
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
ETLMySQLAPIsCDCincremental loadingdimensional modelingdata warehousingSQLPythondata quality
Soft Skills
technical leadershipindependent operationownership