Design, build, and maintain ETL/ELT pipelines using Python and SQL to ingest data from Salesforce Education Cloud, flat files, and API endpoints into the data warehouse
Implement robust error handling, logging, and automated monitoring to detect and track data quality issues
Define schemas and curate unified student datasets with targeted completeness and accuracy for downstream reporting and modeling
Optimize AWS Redshift and PostgreSQL performance through tuning, query optimization, and storage management
Serve as escalation point for complex data discrepancies and pipeline failures; provide root-cause analysis and permanent fixes
Coordinate with analysts and BI developers to validate transformations and resolve mismatches

Requirements

5+ years of data engineering experience designing ETL/ELT pipelines and data warehouse architecture
Advanced SQL skills (PostgreSQL, Redshift)
Experience with Python-based ETL development and automation
Familiarity with Salesforce data models is preferred
Experience implementing monitoring, logging, and data quality checks
Must be a U.S. Citizen
Must have an active Secret clearance.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

ETLELTPythonSQLAWS RedshiftPostgreSQLdata quality checksdata warehouse architecturequery optimizationerror handling

root-cause analysisproblem-solvingcommunicationcollaborationanalytical thinking

Secret clearance