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
Cloud • Security • Software • Cybersecurity • Automation
Own strategic public sector accounts for GitLab’s AI-powered DevSecOps platform. Develop account plans, navigate government procurement and contracting, build relationships with agency leaders, manage opportunities from pipeline through expansion, and drive adoption. Collaborate with engineering, customer success, support, system integrators, resellers, and other partners to deliver modernization outcomes. Represent customer feedback internally and help shape GitLab’s public sector strategy.
Top Skills:
Ci/CdDevsecopsGitlab
Cloud • Healthtech • Professional Services • Software • Pharmaceutical
Processes and quality-checks external and local laboratory data throughout clinical trials. Reviews protocols, eCRF designs, vendor data transfers, normal ranges, reconciliation logs, exception listings, and clinical database alignment. Supports study start-up, data documentation, issue resolution, reporting, metrics, and vendor agreements while ensuring ICH/GCP, SOP, and data integrity standards. Collaborates with clinical data management, project teams, clients, laboratories, and vendors.
Top Skills:
21 Cfr Part 11Clinical Data AnalyticsEcrfElluminate Clinical Data Cloud
Cloud • Healthtech • Professional Services • Software • Pharmaceutical
Perform centralized medical coding and serious adverse event reconciliation for clinical trials. The role maintains coding guidelines and SAE plans, codes using MedDRA and WHODrug, reviews coding accuracy, resolves discrepancies with clinical and safety teams, documents decisions, supports dictionary versioning, and tests coding tools and deployments while ensuring compliance with clinical research regulations and quality standards.
Top Skills:
Elluminate Clinical Data CloudMeddraWhodrug
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
