Design, implement, monitor, and maintain production-grade ETL/ELT pipelines integrating Salesforce, iCIMS, Jira, APIs, and other data sources into a MySQL warehouse. Responsibilities include data modeling, schema mapping, access governance, API scripting, data quality management, operational resilience, and establishing integration standards. The role provides technical leadership and owns pipelines end to end in a remote, six-month pro-bono commitment.
About JerseySTEM
All JerseySTEM roles are pro-bono (unpaid) positions.JerseySTEM is a mission-driven professional network of pro-bono contributors dedicated to improving access to STEM education and career pathways for underserved middle school girls in New Jersey.
Members contribute their professional skills and leverage their networks in service of the organization’s gender-equity agenda.Membership is a minimum six-month commitment of approximately six flexible hours per week and includes a $100 refundable deposit, returned after six months of active membership. K–12 educators, retirees, veterans, interns, and students are exempt from the deposit.
OverviewJerseySTEM is seeking experienced Data Engineers to stabilize and scale core data pipelines that power analytics and reporting. The current platform complexity requires ownership from engineers who can design, implement, and maintain production grade workflows across multiple data sources.This role focuses on operational reliability, sound data modeling, and long term platform sustainability.
Responsibilities- Pipeline Engineering: 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.
Security & Access Governance: Defining and auditing data access permissions, ensuring security guardrails are maintained as user access privileges rotate.
- API Management: Writing and debugging custom scripts and database queries to interact with native platform APIs.
- Data Mapping & Classification: 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.
- Operational Resilience: Manage schema changes, late arriving data, and source inconsistencies. Ensure data quality, consistency
- Provide technical leadership and define data integration best practices and standards
- 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
- ETL pipelines are stable, incremental, and predictable
- API ingestion runs with minimal manual intervention
- Data models are trusted and analytics ready
- Analytics teams focus on insights rather than resolving data issues
Similar Jobs
Security • Cybersecurity
Own end-to-end delivery of technical IT projects from intake and procurement through deployment and closeout. Manage SaaS rollouts, system integrations, requirements, vendor milestones, security reviews, testing, go-live, risks, dependencies, and stakeholder communications. Maintain project plans and reporting in Jira and Confluence, enforce lifecycle handoffs, manage change control, and report portfolio health. Improve delivery processes through templates, automation, intake criteria, and standardized reporting while coordinating Procurement, Engineering, IT Security, vendors, and business stakeholders.
Top Skills:
Ai ToolsApi IntegrationsConfluenceJIRAJira AutomationMicrosoft 365ExcelMicrosoft TeamsMiddlewareSAMLSharepointSso
Security • Cybersecurity
Serve as a trusted technical advisor for critical infrastructure customers across Australia and APAC. Lead onboarding, adoption, workshops, training, account reviews, and value-realization planning while improving customers’ OT cybersecurity maturity. Guide integrations, security workflows, risk reduction, and cyber resilience initiatives. Monitor account health, address adoption risks, collaborate with internal teams, and provide customer feedback. Travel throughout Australia, New Zealand, and APAC up to 30%.
Top Skills:
AescsfDcsIsa/Iec 62443Nist CsfOt/Ics CybersecuritySans Ics Five Critical ControlsScada
Security • Cybersecurity
Serve as the primary technical advisor for federal customers using the Dragos OT cybersecurity platform. Lead onboarding, implementation, adoption, account reviews, roadmap alignment, optimization, customer health monitoring, and recovery plans. Partner with Customer Success, Support, Product, and Sales while delivering cybersecurity training, workshops, and executive briefings. Apply ICS/OT expertise to help customers operationalize security use cases, improve maturity, mitigate risk, and achieve measurable value.
Top Skills:
DcsDragos PlatformElasticFirewallsFortisiemIcsQradarScadaSIEMSpan/TapsSplunkVlans
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
