ANALYTICS ENGINEER-REMOTE (REMOTE, TX, US, REMOTE)

• 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 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: 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.
• E

Apply tot his job Apply To this Job