Data/ETL L2 Support Engineer - Remote

Job description

Job Summary We are looking for an experienced Data/ETL Production Support Engineer with strong SQL and ETL experience and hands-on exposure to Python automation. The candidate will support healthcare data pipelines, file processing, database tables, and ETL workflows. The role involves monitoring incoming files, validating data loads, performing source-to-target reconciliation, troubleshooting data discrepancies, and automating repetitive validation activities using Python. The ideal candidate should be comfortable working with a high volume of files and tables and should have experience supporting production data processes in a healthcare environment. Provide production support for healthcare data and ETL processes. Monitor scheduled file arrivals and ETL jobs. Validate database tables after ETL processing. Perform source-to-target data validation and reconciliation. Support onboarding of new files and database tables. Validate new tables against source files and ETL mappings. Investigate ETL failures and data discrepancies. Identify root causes and coordinate with Data Engineering/Development teams for resolution. Develop Python scripts to automate repetitive file and database validation activities. Improve existing manual validation processes through automation. Monitor production jobs and provide timely issue resolution. Maintain validation procedures, support documentation, and operational runbooks. Work with business and technical teams to understand healthcare data requirements. Follow healthcare data security and compliance requirements when handling sensitive data.