Nakupuna Companies

Data Engineer

• 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