ANALYTICS ENGINEER-REMOTE

<span class="jobdescription"><p align="center"> </p> <ul> <li>We have an opening for an <strong>Analytics Engineer </strong>position.</li> <li><strong>Location</strong>: Remote with occasional travel <em>Note: online applications accepted <u>only</u>.</em></li> <li><strong>Schedule</strong>:8-5PMCT</li> <li><strong>Pay Range</strong>: $115,000- $130,000</li> </ul> <p>ESFM is the corporate Integrated Facilities Management (IFM) division of Compass Group USA and a Keystone member of the International WELL Building Institute (IWBI). </p> <p> </p> <p><strong>We Make Applying Easy! </strong>Want to apply to this job via text messaging? Text <strong>JOB</strong> to <strong>75000 </strong>and search <strong>requisition ID number</strong><strong> <strong>1480849</strong>.</strong></p> <p><span style="font-size:10.0px">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: <a href="http://olivia.paradox.ai/moSkg">http://olivia.paradox.ai/moSkg</a></span></p> <p>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.</p> <p> </p> <p>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.</p> <p> </p> <p>In 2020, ESFM (formerly Eurest Services) won the George Graves Award for Facility Management Achievement from the International Facilities Management Association (IFMA).</p> <p> </p><div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:16.0px;word-wrap:break-word"><h2 style="font-size:1.0em;margin:0.0px"><u><b>Job Summary</b></u></h2> </div><div><p>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.</p> <p> </p> <p>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.</p></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:16.0px;word-wrap:break-word"><h2 style="font-size:1.0em;margin:0.0px"><u><b>Core Responsibilities</b></u></h2> </div><div><p><strong>Data Modeling & Transformation</strong></p> <ul> <li>Design and maintain dbt models that transform raw data into trusted, analytics-ready datasets.</li> <li>Apply dimensional modeling (Kimball) to build optimized star schemas for reporting and self-service analytics.</li> <li>Implement testing frameworks (dbt tests, unit tests) to ensure data quality and reliability.</li> </ul> <p><strong>Data Integration & ELT</strong></p> <ul> <li>Develop and manage automated ELT pipelines in dbt and Snowflake.</li> <li>Integrate new data sources (e.g., ServiceNow, SaaS platforms) and collaborate with data engineers to optimize workflows and orchestration.</li> </ul> <p> </p> <p><strong>Analytics Enablement</strong></p> <ul> <li>Build and maintain semantic layers in Power BI and Looker (LookML) for consistent KPIs and definitions.</li> <li>Align data models with business objectives and optimize for performance and ease of use.</li> </ul> <p> </p> <p><strong>Engineering Best Practices</strong></p> <ul> <li>Use Git/GitHub for version control and CI/CD tools (e.g., dbt Cloud, GitHub Actions) for safe, automated deployments.</li> <li>Monitor and optimize Snowflake performance, ensuring scalability and cost efficiency.</li> <li>Apply observability practices (logging, query monitoring) to proactively detect and resolve issues.</li> </ul> <p> </p> <p><strong>Collaboration & Governance</strong></p> <ul> <li>Partner with analysts, data scientists, and business teams to deliver actionable insights.</li> <li>Communicate technical concepts clearly and promote data governance, documentation, and best practices.</li> <li>Maintain security, access controls, and documentation across data models, pipelines, and BI platforms.</li> </ul> <p><strong>Continuous Improvement</strong></p> <ul> <li>Stay current with modern data stack tools and recommend enhancements to improve efficiency and scalability.</li> </ul> <p> </p></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:16.0px;word-wrap:break-word"><h2 style="font-size:1.0em;margin:0.0px"><u><b>Qualifications</b></u></h2> </div><div><p> </p> <ul> <li>Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related field; or equivalent experience.</li> <li>3+ years of experience in analytics engineering, data engineering, or a related role.</li> <li>Hands-on expertise designing star schemas, fact tables, and conformed dimensions following Kimball best practices</li> <li>Proven hands-on experience with dbt for ELT pipeline development.</li> <li>Strong proficiency with Snowflake, including query optimization and performance tuning.</li> <li>Demonstrated application of Kimball dimensional modeling and star schema design.</li> <li>Experience designing semantic models in Power BI and/or Looker (LookML preferred).</li> <li>Advanced SQL skills with large, complex datasets.</li> <li>Proficiency with Git/GitHub for version control and collaborative workflows.</li> <li>Experience managing multi-environment workflows (dev → staging → prod).</li> <li>Knowledge of data observability, governance, and role-based access security.</li> <li>Certifications or equivalent practical expertise with Snowflake, Google Looker, Power BI, and dbt tools.</li> <li>Excellent communication skills with both technical and business stakeholders.</li> <li>Strong sense of ownership, accountability, and attention to detail.</li> </ul> <p> </p> <p><strong>Preferred / Bonus Skills:</strong></p> <ul> <li>Experience implementing CI/CD pipelines for dbt or data engineering workflows.</li> <li>Exposure to Python for scripting, automation, or data integration.</li> <li>Familiarity with ServiceNow data structures or other enterprise SaaS systems.</li> <li>Knowledge of data quality frameworks (e.g., Great Expectations, Monte Carlo, Soda).</li> </ul></div></div></div><p><span style="font-size:14.0px"><span style="font-family:Arial, Helvetica, sans-serif"><b>Associates at ESFM are offered many fantastic benefits.</b></span></span></p> <p><b>Full-time and part-time positions offer </b>the following benefits to associates: <span style="font-family:Arial, Helvetica, sans-serif">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</span></p> <p><b>Full-time positions also offer</b> the following benefits to associates: <span style="font-family:Arial, Helvetica, sans-serif">Medical, Dental, Vision, Life Insurance/AD, Disability Insurance, Commuter Benefits, Employee Assistance Program, Flexible Spending Accounts (FSAs)</span></p> <p><span style="font-size:11.0pt"><span><span style="font-family:Calibri, sans-serif"><em>Associates may also be eligible for paid and/or unpaid time off benefits in accordance with applicable federal, state, and local laws. </em><em><span style="color:black">For positions in Washington State, Maryland, or to be performed Remotely,</span><a href="https://www.compass-usa.com/wp-content/uploads/2023/08/2023_WageTransparency_ESFM.pdf" style="color:#0563c1;text-decoration:underline"> click here</a></em><em><span style="color:black"> for paid time off benefits information.</span></em></span></span></span></p> <p><b>About Compass Group: Achieving leadership in the foodservice and facility management industry</b></p> <p> </p> <p>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.</p> <p> </p> <p>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. </p> <p>Applications are accepted on an ongoing basis.</p> <p>ESFM maintains a drug-free workplace.</p> <p><span>ESFM</span> </p> </span>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...