Compass Group USA is seeking a Senior Data Engineer to build new pipelines aligned with business needs and to implement scalable data solutions. The role involves working closely with Data Analytics and Reporting teams, monitoring pipeline performance, and troubleshooting data-related issues.
Responsibilities:
- Build new pipelines in alignment with business needs for required projects and requests
- Define, build, test, and implement scalable data pipelines using Python and SQL
- Build stored procedures and views in Redshift and Snowflake
- Work closely with Data Analytics and Reporting teams to align on strategy and to develop data models that feed business intelligence tools
- Monitor legacy pipelines in production and monitor pipeline performance and efficiency
- Improve efficiencies within existing data structures
- Document new and existing data solutions
- Interpret business requirements and design the best data solutions to meet them
- Troubleshoot data related issues including missing data, poor data quality, etc
- Maintain code via CI/CD process as defined in our Azure DevOps platform
- Work M-F 9am – 5pm EST and overtime and weekends as needed to meet project deadlines and to ensure system stability
- Work On Call production support 1 week out of every month
Requirements:
- Bachelor's degree in Information Technology, Computer Engineering or related field or foreign equivalent
- two (2) years of data engineering experience
- two (2) years of experience with SQL
- two (2) years of experience with Python
- two (2) years of experience with Extract, Transform, Load (ETL)
- two (2) years of experience with Snowflake
- two (2) years of experience with Redshift
- two (2) years of experience with AWS Services