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
Artificial Intelligence • Big Data • Healthtech • Machine Learning • Analytics • Biotech • Generative AI
Leads a regional sales team responsible for MRD testing revenue, expenses, business planning, customer relationships, sales strategy, and account development. Recruits, trains, manages, and evaluates Clinical Account Executives across several states, while overseeing CRM usage and cross-functional initiatives. The role requires executive-level consultative selling, oncology and molecular diagnostics expertise, financial acumen, and approximately 50% travel throughout the territory.
Top Skills:
ExcelMS OfficePowerPointSaaSSalesforceSequencing Technology
Artificial Intelligence • Big Data • Healthtech • Machine Learning • Analytics • Biotech • Generative AI
Lead global pharmaceutical and biotechnology client accounts for Tempus diagnostics and CRO offerings. Develop account strategies, exceed revenue goals, build executive and R&D relationships, negotiate complex agreements, identify opportunities across client portfolios, coordinate cross-functional teams, and support precision medicine case studies. Requires deep life sciences sales experience, diagnostic and drug development knowledge, and approximately 30% domestic and international travel.
Top Skills:
AICompanion DiagnosticsMultiomicsSequencing Diagnostics
Artificial Intelligence • Fintech • Hardware • Information Technology • Sales • Software • Transportation
Lead a team supporting Enterprise and Strategic accounts across the quote-to-cash lifecycle. Build dashboards and analytics to track operational metrics and SLAs, partner cross-functionally to design scalable workflows, and drive process improvements and projects to completion.
Top Skills:
AIExcelSQL
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
