Senior Data Engineer - ETL | Data Integration

📋 Description

• Design, configure, monitor, and maintain production-grade ETL/ELT pipelines ingesting data from
• Implement change data capture (CDC) and incremental loading for reliable data refreshes.
• Integrate external APIs and third-party systems; develop/debug custom scripts and queries for
• Normalize and map complex data schemas from Salesforce CRM, iCIMS, Jira, and other platforms.
• Design and maintain analytical data models (fact/dimension) for reporting and analytics.
• Manage schema changes, late-arriving data, and data quality to ensure consistency.

🎯 Requirements

• Five+ years in data engineering, data platforms, or similar field.
• Strong MySQL experience in analytical/data warehouse environments.
• Proven experience integrating external APIs/third-party systems.
• Demonstrated CDC/incremental loading or similar data synchronization patterns.
• Deep understanding of dimensional modeling, data warehouse architecture, and analytical structures.
• Advanced SQL and strong Python or equivalent language.

🎁 Benefits

• Pro-bono volunteer position with no monetary compensation.
• Flexible commitment of ~six hours per week; six-month minimum commitment.
• Opportunity to contribute to meaningful data and analytics initiatives.
• Ownership of production data pipelines and platform reliability.
• Networking within a community of pro-bono STEM professionals.
• Refundable member deposit applicable in typical scenarios.