Compass Group USA · 5 hours ago
Sr. Data Engineer - DBT
Maximize your interview chances
AdviceFood and Beverage
H1B Sponsor Likely
Insider Connection @Compass Group USA
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Design, build, test, and implement scalable data pipelines using Python and SQL.
Maintain and optimize our Snowflake data warehouse’s performance, including data ingestion and query optimization.
Design and implement analytical data models using SQL in dbt and Snowflake, focusing on accuracy, performance, and scalability
Own and maintain the semantic layer of our data modeling, defining and managing metrics, dimensions, and joins to ensure consistent and accurate reporting across the organization
Collaborate with the internal stakeholders to understand their data needs and translate them into effective data models and metrics
Perform analysis and critical thinking to troubleshoot data-related issues and implement checks/scripts to enhance data quality.
Collaborate with other data engineers and architect to develop new pipelines and/or optimize existing ones.
Maintain code via CI/CD processes as defined in our Azure DevOps platform
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Highly self-motivated and detail-oriented with strong communication skills.
5+ years of experience in Data Engineering roles, with a focus on building and implementing scalable data pipelines for data ingestion and data transformation.
Expertise in Snowflake, including data ingestion and performance optimization.
Strong experience using ETL software (Fivetran, dbt, Airflow, etc.)
Strong SQL skills for writing efficient queries and optimizing existing ones.
Proficiency in Python for data extraction from APIs using AWS Lambda, Glue, etc.
Experience with AWS services such as Lambda, Airflow, Glue, S3, SNS, etc.
Company
Compass Group USA
Compass Group is redefining the food and facility services landscape with innovation and passion through the lens of what’s next.
H1B Sponsorship
Compass Group USA has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (41)
2022 (46)
2021 (112)
2020 (56)
Funding
Current Stage
Late StageLeadership Team
Recent News
Company data provided by crunchbase