Nonprofit
Published 1 month ago

TECH211: Senior Data Engineer - ETL | Data Integration

Remote, Volunteer must be in United States
I Want to Help


  • Details

    Available Times:
    Weekdays daytime, evenings, Weekends daytime, evenings
    Time Commitment:
    A few hours per week
    Commitment Details:
    6 hours per week for 6 months
    Recurrence:
    Recurring
    Volunteers Needed:
    99
    Cause Areas:
    Community Development, Education, Science & Technology, Volunteering, Women
    Benefits:
    Training Provided, Academic Credit Available
    Good For:
    Age 55+
    Participation Requirements:
    Attend Orientation
    Age Requirement:
    18+

    Description

    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

    Location

    Remote
    Volunteer must be in United States
    Associated Location
    Virtual Locations, Florham Park, New Jersey, US

    How to Volunteer for This Opportunity

    Thank you for your interest in joining our cause.

    Please apply through our iCIMS platform.

    you will receive an automatic email once you apply and we will follow up with you soon after.

    Illustration

    Discover Your Calling

    Find opportunities to change the world with the latest social-impact job, internship, and volunteer listings. Plus, explore resources for taking action in your community.