Note: The job is a remote job and is open to candidates in USA. JerseySTEM is a mission-driven professional network supporting STEM education and career pathways for underserved middle school girls in New Jersey. The Senior Data Engineer will stabilize and scale production-grade ETL/ELT pipelines, integrate data from multiple third-party systems, and ensure reliable data modeling, security, and operational resilience. The role also provides technical leadership and establishes data integration standards and best practices.
Responsibilities
- Designing, configuring, and monitoring production grade ETL/ELT pipelines to ingest unstructured and structured data from third party data sources into our MySQL operational data warehouse using integrate.io, Google Apps Script/JavaScript
- Defining and auditing data access permissions, ensuring security guardrails are maintained as user access privileges rotate
- Writing and debugging custom scripts and database queries to interact with native platform APIs
- Normalizing and mapping complex, disparate schemas from Salesforce CRM, iCIMS talent data, and Jira ticketing systems, and others. Design and maintain analytical models including fact and dimension tables
- Manage schema changes, late arriving data, and source inconsistencies. Ensure data quality, consistency
- Provide technical leadership and define data integration best practices and standards
Skills
- * FIVE or more years of hands on experience in data engineering or data platform roles
- * Technology requirements: Google Apps Script/JavaScript, Integrate.io or similar ETL platforms, mySQL, Python
- * Proven experience integrating external APIs and third party systems
- * Deep understanding of dimensional modeling and warehouse architecture
- * Ability to operate independently in a remote environment and own pipelines end to end
Company Overview