Analytics Engineer-Remote
We have an opening for an Analytics Engineer position.
Location
:
Remote with occasional travel.
Note:
online applications accepted only.
Schedule
: 8-5 PM CT.
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).
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 SummaryThe 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 ResponsibilitiesData 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., Service Now, 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/Git Hub for version control and CI/CD tools (e.g., dbt Cloud, Git Hub 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.
- 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…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).