ANALYTICS ENGINEER-REMOTE
ESFM® USA
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
Qualifications
- 3+ years of experience in analytics engineering or data engineering.
- Hands-on experience designing star schemas and fact tables.
- Proven experience with dbt for ELT pipeline development.
Responsibilities
- Design and maintain data models that transform raw data into analytics-ready datasets.
- Develop and manage automated ELT pipelines in dbt and Snowflake.
- Build and maintain semantic layers in Power BI for consistent KPIs.
Skills
Education
Tools
Job description
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).
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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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 (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.
- 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).
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: 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.
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.
ESFM maintains a drug‑free workplace.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
