Compass Group USA
SENIOR DATA ENGINEER- REMOTE
Compass Group USA, Charlotte, North Carolina, United States, 28245
Compass Technology
Salary : $120,000-$140,000 Who We Are Compass Technology is a dedicated internal team for Compass Group delivering enterprise-wide initiatives that support our diverse customer base and enhance our business operations. Our domain encompasses a vast spectrum of opportunities, from hands-on desk support to Cybersecurity, Cloud Engineering, AI, and Modern Application development. We are committed to building robust IT infrastructures, driving digital transformation, and much more. Compass Group is the leading foodservice management and support services company, with $26 billion in revenue in 2023. In 2023, Compass Group was named one of Forbes' America's Best Large Employers along Springbuk's Healthiest 100 Workplaces in America (since 2019). Job Summary We are looking for a hands-on Senior Data Engineer/Analytics Engineer with expertise in developing data pipelines and transforming data to be consumed downstream. This role is crucial in designing, building, and maintaining our data infrastructure, focusing on creating scalable pipelines, ensuring data integrity, and optimizing performance. Key skills include strong Snowflake expertise, advanced SQL proficiency, data extraction from APIs using Python and AWS Lambda, and experience with ETL/ELT processes. Workflow automation using AWS Airflow is essential, and experience with Fivetran and dbt or similar tools are also a must have.
Job 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 Job Qualifications 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. Apply to Compass Group today! Click here to Learn More about the Compass Story Compass Group is an equal opportunity employer. At Compass, we are committed to treating all Applicants and Associates fairly based on their abilities, achievements, and experience without regard to race, national origin, sex, age, disability, veteran status, sexual orientation, gender identity, or any other classification protected by law. Qualified candidates must be able to perform the essential functions of this position satisfactorily with or without a reasonable accommodation. Disclaimer: this job post is not necessarily an exhaustive list of all essential responsibilities, skills, tasks, or requirements associated with this position. While this is intended to be an accurate reflection of the position posted, the Company reserves the right to modify or change the essential functions of the job based on business necessity. We will consider for employment all qualified applicants, including those with a criminal history (including relevant driving history), in a manner consistent with all applicable federal, state, and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, the San Francisco Fair Chance Ordinance, and the New York Fair Chance Act. Compass Technology maintains a drug-free workplace. Applications are accepted on an ongoing basis. Associates at Corporate are offered many fantastic benefits. Medical Dental Vision Life Insurance/ AD Disability Insurance Retirement Plan Paid Time Off Holiday Time Off (varies by site/state) Associate Shopping Program Health and Wellness Programs Discount Marketplace Identity Theft Protection Pet Insurance Commuter Benefits Employee Assistance Program Flexible Spending Accounts (FSAs) Req ID: 1348314 Compass Technology MARY DICKSON
Salary : $120,000-$140,000 Who We Are Compass Technology is a dedicated internal team for Compass Group delivering enterprise-wide initiatives that support our diverse customer base and enhance our business operations. Our domain encompasses a vast spectrum of opportunities, from hands-on desk support to Cybersecurity, Cloud Engineering, AI, and Modern Application development. We are committed to building robust IT infrastructures, driving digital transformation, and much more. Compass Group is the leading foodservice management and support services company, with $26 billion in revenue in 2023. In 2023, Compass Group was named one of Forbes' America's Best Large Employers along Springbuk's Healthiest 100 Workplaces in America (since 2019). Job Summary We are looking for a hands-on Senior Data Engineer/Analytics Engineer with expertise in developing data pipelines and transforming data to be consumed downstream. This role is crucial in designing, building, and maintaining our data infrastructure, focusing on creating scalable pipelines, ensuring data integrity, and optimizing performance. Key skills include strong Snowflake expertise, advanced SQL proficiency, data extraction from APIs using Python and AWS Lambda, and experience with ETL/ELT processes. Workflow automation using AWS Airflow is essential, and experience with Fivetran and dbt or similar tools are also a must have.
Job 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 Job Qualifications 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. Apply to Compass Group today! Click here to Learn More about the Compass Story Compass Group is an equal opportunity employer. At Compass, we are committed to treating all Applicants and Associates fairly based on their abilities, achievements, and experience without regard to race, national origin, sex, age, disability, veteran status, sexual orientation, gender identity, or any other classification protected by law. Qualified candidates must be able to perform the essential functions of this position satisfactorily with or without a reasonable accommodation. Disclaimer: this job post is not necessarily an exhaustive list of all essential responsibilities, skills, tasks, or requirements associated with this position. While this is intended to be an accurate reflection of the position posted, the Company reserves the right to modify or change the essential functions of the job based on business necessity. We will consider for employment all qualified applicants, including those with a criminal history (including relevant driving history), in a manner consistent with all applicable federal, state, and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, the San Francisco Fair Chance Ordinance, and the New York Fair Chance Act. Compass Technology maintains a drug-free workplace. Applications are accepted on an ongoing basis. Associates at Corporate are offered many fantastic benefits. Medical Dental Vision Life Insurance/ AD Disability Insurance Retirement Plan Paid Time Off Holiday Time Off (varies by site/state) Associate Shopping Program Health and Wellness Programs Discount Marketplace Identity Theft Protection Pet Insurance Commuter Benefits Employee Assistance Program Flexible Spending Accounts (FSAs) Req ID: 1348314 Compass Technology MARY DICKSON