United States only- We have an opening for an Analytics Engineer position.
- Location: Remote with occasional travel Note: online applications accepted only.
- Schedule:8-5PMCT
- Pay Range: $115,000- $130,000
ESFM is the corporate Integrated Facilities Management (IFM) division of Compass Group USA and a Keystone member of the International WELL Building Institute (IWBI).
We Make Applying Easy! Want to apply to this job via text messaging? Text JOB to 75000 and search requisition ID number1480849.
The advertised program is a conversational recruiting assistant that helps you apply to jobs with Compass Group. Message frequency varies. Message and data rates may apply. Text STOP to opt out or HELP for help. Terms and conditions: http://olivia.paradox.ai/moSkg
Rooted in hospitality, ESFM elevates the workplace experience as the single source of innovative FM solutions that ensure a safe, healthy, and sustainable environment. ESFM’s clients include many household names from Life Science, Technology, Oil & Gas and Manufacturing markets.
ESFM self-performs 80% of all IFM solutions provided to clients. Their portfolio of service categories includes Environment, Health & Safety, Facilities Maintenance & Engineering, Sustainability, Janitorial & Industrial Cleaning, Laboratory Support and Workplace solutions. This self-performance model creates a consistent hospitality experience for clients, resulting in higher engagement and productivity from their employees.
In 2020, ESFM (formerly Eurest Services) won the George Graves Award for Facility Management Achievement from the International Facilities Management Association (IFMA).
Job Summary
The Analytics Engineer plays a pivotal role in shaping ESFM’s modern data platform and enabling the business to make better, faster, and more trusted decisions. This role is responsible for designing and maintaining scalable data models in Snowflake, developing robust ELT pipelines with dbt, and enabling consistent analytics across Power BI and Google Looker.
By applying dimensional modeling principles and engineering best practices, the Analytics Engineer will translate business needs into reliable, reusable, and performant data products. This position sits at the intersection of data engineering and business intelligence, ensuring stakeholders have access to clean, governed, and analytics-ready data for self-service insights.
Core Responsibilities
Data Modeling & Transformation
- Design and maintain dbt models that transform raw data into trusted, analytics-ready datasets.
- Apply dimensional modeling (Kimball) to build optimized star schemas for reporting and self-service analytics.
- Implement testing frameworks (dbt tests, unit tests) to ensure data quality and reliability.
Data Integration & ELT
- Develop and manage automated ELT pipelines in dbt and Snowflake.
- Integrate new data sources (e.g., ServiceNow, SaaS platforms) and collaborate with data engineers to optimize workflows and orchestration.
Analytics Enablement
- Build and maintain semantic layers in Power BI and Looker (LookML) for consistent KPIs and definitions.
- Align data models with business objectives and optimize for performance and ease of use.
Engineering Best Practices
- Use Git/GitHub for version control and CI/CD tools (e.g., dbt Cloud, GitHub Actions) for safe, automated deployments.
- Monitor and optimize Snowflake performance, ensuring scalability and cost efficiency.
- Apply observability practices (logging, query monitoring) to proactively detect and resolve issues.
Collaboration & Governance
- Partner with analysts, data scientists, and business teams to deliver actionable insights.
- Communicate technical concepts clearly and promote data governance, documentation, and best practices.
- Maintain security, access controls, and documentation across data models, pipelines, and BI platforms.
Continuous Improvement
- Stay current with modern data stack tools and recommend enhancements to improve efficiency and scalability.
Qualifications
- Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related field; or equivalent experience.
- 3+ years of experience in analytics engineering, data engineering, or a related role.
- Hands-on expertise designing star schemas, fact tables, and conformed dimensions following Kimball best practices
- Proven hands-on experience with dbt for ELT pipeline development.
- Strong proficiency with Snowflake, including query optimization and performance tuning.
- Demonstrated application of Kimball dimensional modeling and star schema design.
- Experience designing semantic models in Power BI and/or Looker (LookML preferred).
- Advanced SQL skills with large, complex datasets.
- Proficiency with Git/GitHub for version control and collaborative workflows.
- Experience managing multi-environment workflows (dev → staging → prod).
- Knowledge of data observability, governance, and role-based access security.
- Certifications or equivalent practical expertise with Snowflake, Google Looker, Power BI, and dbt tools.
- Excellent communication skills with both technical and business stakeholders.
- Strong sense of ownership, accountability, and attention to detail.
Preferred / Bonus Skills:
- Experience implementing CI/CD pipelines for dbt or data engineering workflows.
- Exposure to Python for scripting, automation, or data integration.
- Familiarity with ServiceNow data structures or other enterprise SaaS systems.
- Knowledge of data quality frameworks (e.g., Great Expectations, Monte Carlo, Soda).
Associates at ESFM are offered many fantastic benefits.
Full-time and part-time positions offer the following benefits to associates: Retirement Plan, Associate Shopping Program, Health and Wellness Programs, Discount Marketplace, Identity Theft Protection, Pet Insurance, Voluntary Benefits, including Critical Illness Insurance, Accident Insurance, Hospital Indemnity Insurance, Legal Services, and Choice Auto and Home Program
Full-time positions also offer the following benefits to associates: Medical, Dental, Vision, Life Insurance/AD, Disability Insurance, Commuter Benefits, Employee Assistance Program, Flexible Spending Accounts (FSAs)
Associates may also be eligible for paid and/or unpaid time off benefits in accordance with applicable federal, state, and local laws. For positions in Washington State, Maryland, or to be performed Remotely, click here for paid time off benefits information.
About Compass Group: Achieving leadership in the foodservice and facility management industry
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.
Applications are accepted on an ongoing basis.
United Kingdom
CA and US only
