JerseySTEM Logo

JerseySTEM

TECH211: Senior Data Engineer - ETL | Data Integration

Posted An Hour Ago
Be an Early Applicant
Remote
Hiring Remotely in United States
Senior level
Remote
Hiring Remotely in United States
Senior level
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.
The summary above was generated by AI
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.

Overview

JerseySTEM 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
Qualifications
  • 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
What Success Looks Like
  • 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

3 Minutes Ago
Remote or Hybrid
USA
Senior level
Senior level
Machine Learning • Payments • Security • Software • Financial Services
Facilitates Scrum ceremonies, coaches Agile teams and stakeholders, removes impediments, manages risks and dependencies, and supports CI/CD and continuous delivery. Partners with Product Owners to prioritize backlogs, tracks delivery metrics, improves team velocity and predictability, and protects teams from distractions. The role also provides guidance to less experienced Scrum Masters and promotes Agile principles across complex, cross-functional technology teams.
Top Skills: AgileCi/CdDevOpsScrum
59 Minutes Ago
Remote or Hybrid
CA, USA
164K-297K Annually
Expert/Leader
164K-297K Annually
Expert/Leader
eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Lead global ecosystem partnerships for Block’s Afterpay, Cash App, and Square products. Develop partner strategies, build executive relationships, design scalable partnership programs, commercialize B2B and B2B2C payment products, negotiate agreements, and expand distribution through third-party platforms. Collaborate with Product, Engineering, Sales, Marketing, Finance, Compliance, and Legal teams to maximize partner performance and commercial growth.
Top Skills: Agentic CommerceB2B PaymentsB2B2C PaymentsFintech
59 Minutes Ago
Remote or Hybrid
45K-85K Annually
Junior
45K-85K Annually
Junior
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handle inbound calls and warm leads, consult customers on insurance needs, recommend appropriate property and casualty coverages, and convert prospects into policyholders. Representatives receive paid training and licensing support, work remotely, maintain a professional home workspace, and follow a schedule including one weekend day. The role requires strong communication, persuasion, organization, PC proficiency, and at least two years of sales or service-related experience.
Top Skills: High-Speed Wired InternetPc

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account