ETL Engineer (Python, SQL)

Responsibilities

• Maintain and enhance existing data pipelines, including making code updates to current pipeline loads
• Design and build new ETL pipelines to support new data sources and business requirements
• Develop and maintain SQL-based data models, including creating new tables and leveraging existing tables
• Develop SQL views and procedures
• Improve pipeline reliability, performance, and readability by simplifying and standardizing SQL logic
• Partner with external stakeholders to understand data feeds to create new data pipelines
• Troubleshoot data quality issues and pipeline failures, ensuring accurate and timely data delivery

Requirements

• 5+ years data migration/ETL experience
• Strong experience in Python (Pandas preferred) and SQL (PostgreSQL or other similar)
• Bachelor's degree
• Strong SQL skills, including complex queries, transformations, data modeling, stored procedures, query analysis, and performance troubleshooting
• Able to work with existing legacy pipelines and refactor them into cleaner, more maintainable solutions

Qualifications

Not specified

Skills

• Data migration/ETL experience
• Python (Pandas preferred)
• SQL (PostgreSQL or other similar)
• Strong SQL skills
• Complex queries, transformations, data modeling, stored procedures, query analysis, and performance troubleshooting
• Working with existing legacy pipelines and refactoring them into cleaner, more maintainable solutions

Benefits

Not specified

Pay

$60-$65.50/hour w2Salary Range when converting permanent: $100,000-$110,000 plus 10% bonus

Schedule

M-F 8:30am-5pm ET

Employment Type

Contract-to-Hire