Data Engineer

About This Role

This role involves designing, building, and maintaining robust data pipelines and data warehouse infrastructure to ensure reliable, scalable, and secure data integration for reporting and analytics.

Responsibilities

• 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

• Hands-on experience designing and maintaining ETL/ELT pipelines using Python and SQL
• Working knowledge of data warehouse concepts, schema design, and performance optimization
• Experience implementing data quality checks, logging, and monitoring to detect pipeline failures and data anomalies
• Ability to troubleshoot and remediate data discrepancies and integration issues across multiple source systems
• Experience collaborating with BI developers and analysts to validate transformations and definitions
• Advanced SQL skills (PostgreSQL, Redshift)
• Experience with Python-based ETL development and automation

Qualifications

• Bachelor’s degree in Engineering, Computer Science, or equivalent
• 5+ years of data engineering experience designing ETL/ELT pipelines and data warehouse architecture

Nice to Have

• Familiarity with Salesforce data models
• Experience implementing monitoring, logging, and data quality checks

Skills

* Required skills