Job description

Position Title: SENIOR BI ANALYST, FINANCE Salary: $90,000 - $120,000 Pay Grade: 15 Other Forms of Compensation: BONUS ESFM is the corporate facilities management (FM) division of Compass Group USA, a Gold-level Corporate Sustaining Partner of the International Facility Management Association (IFMA), and a Platinum Corporate Member of the Association of Energy Engineers (AEE). ESFM self-performs 80% of all FM services provided to clients. Our portfolio of solution categories includes Facilities Maintenance & Engineering, ESG Programming, Laboratory Support Services, Janitorial & Industrial Cleaning, Landscaping & Grounds Management, Workplace Solutions and Managed Services. This self-performance model creates a consistent hospitality experience for clients, resulting in higher engagement and productivity from their employees. ESFM’s clients include many household names from the life sciences, technology, oil & gas and manufacturing markets. This position is eligible for an Employee Referral Bonus! If you know someone that is qualified for this role, please use the ‘job search’ in PeopleHub to refer your referral and email them a link to apply. Your referral will be able to apply by clicking the link in the email. You can check the status through your profile, accessible via Careers in PeopleHub, by clicking on ‘referral tracking.’ For Employee Referral guidelines, FAQs and the Compass Employee Referral Policy, email MyReferral@compass-usa.com. Job Summary We are seeking a SENIOR BI ANALYST, FINANCE t to partner with Finance, Operations and client teams. The ideal candidate combines Power BI development with Power Apps and Power Automate experience to replace manual processes with solutions that improve decision-making. This consultative role extends beyond dashboards. The analyst will challenge processes, translate business needs into technical solutions, communicate insights to non-technical stakeholders, and increase adoption through documentation and training. Key Responsibilities • Partner with Finance, Operations, account teams and leaders to identify reporting needs and pain points, then translate them into specifications, data models, application designs and implementation plans. • Automate manual reporting, data-entry and workflows using Power BI and Power Platform solutions. • Design and maintain Power BI dashboards, semantic models and paginated reports using Power Query, DAX, dimensional modeling, performance optimization and security best practices. • Build canvas and/or model-driven Power Apps and Power Automate cloud flows for data collection, approvals and workflows across SharePoint, Dataverse, Microsoft 365 and other systems. • Develop analytics for P&L, procurement, accounts receivable, working capital, productivity and service delivery; use SQL to integrate, reconcile and validate multi-system data. • Perform root-cause, trend and variance analysis and convert findings into recommendations for Finance, Operations and senior leadership. • Own the solution lifecycle: requirements, design, development, testing, deployment, documentation, training, adoption and enhancement. Establish controls and lead UAT to confirm accuracy, workflows and security. • Lead demonstrations and office hours, monitor adoption, build stakeholder relationships, and quantify value through savings, faster cycles, reduced risk or improved accuracy. Required Qualifications • 3+ years in business intelligence, business analytics, financial analytics or a related field, including Finance and/or Operations support. • Advanced Power BI expertise in Power Query, DAX, semantic/dimensional modeling, visualization, performance optimization, security and Power BI Service. • Production experience personally deploying Power Apps—not solely training or coursework—and Power Automate flows for approvals, notifications, data collection, reporting or process automation. • Proven ability to improve financial or operational outcomes through analytics or automation and explain the problem, solution, stakeholders and measurable result. • Experience analyzing revenue, margin, productivity, procurement, vendor performance, accounts receivable or working capital, plus strong SQL skills for data discovery, transformation and validation. • Ability to turn ambiguous requirements into scalable solutions and present findings to senior and non-technical audiences. • Strong client-service, organizational and project-management skills, including testing, documentation, training and adoption across multiple priorities. • Experience with embedded analytics, paginated reports, row-level security, deployment pipelines or source-controlled Power BI development. . Continue Preferred Qualifications • Experience with Microsoft Fabric, Dataverse, SharePoint, Azure, Snowflake or enterprise data platforms. • Experience using MCP-embedded AI tools (e.g., Kiro) to automate report delivery or analysis. • Experience in facilities management, hospitality, outsourced services or multi-site operations; familiarity with ServiceNow, Nuvolo, SAP, Oracle, Dynamics 365 or similar CMMS/ERP systems. • Familiarity with continuous integration and Azure DevOps. Evidence of Success • Strong candidates can discuss a deployed Power App and Power Automate workflow; a Power BI solution for Finance or Operations; an actionable analysis; measurable business improvements; and an initiative that increased platform adoption. Apply to ESFM Services today! ESFM is a member of Compass Group USA Click here to Learn More about the Compass Story Associates at ESFM are offered many fantastic benefits. • Medical • Dental • Vision • Life Insurance/ AD • Disability Insurance • Retirement Plan • Paid Time Off • Holiday Time Off (varies by site/state) • Associate Shopping Program • Health and Wellness Programs • Discount Marketplace • Identity Theft Protection • Pet Insurance • Commuter Benefits • Employee Assistance Program • Flexible Spending Accounts (FSAs) • Paid Parental Leave • Personal Leave 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 or copy/paste the link below for paid time off benefits information. compass-usa.com 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. We will consider for employment all qualified applicants, including those with a criminal history (including relevant driving history), in a manner consistent with all applicable federal, state, and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, the San Francisco Fair Chance Ordinance, and the New York Fair Chance Act. Certain positions may require Florida Level 2 background screening. Details: info.flclearinghouse.com Applications are accepted on an ongoing basis. Eurest Services maintains a drug-free workplace. Req ID: 1559185 ESFM Julia Lari

Requirements

Must-haves

Position Title: SENIOR BI ANALYST, FINANCE
Salary: $90,000 - $120,000
Pay Grade: 15
Partner with Finance, Operations, account teams and leaders to identify reporting needs and pain points, then translate them into specifications, data models, application designs and implementation plans.
Automate manual reporting, data-entry and workflows using Power BI and Power Platform solutions.
Design and maintain Power BI dashboards, semantic models and paginated reports using Power Query, DAX, dimensional modeling, performance optimization and security best practices.
Build canvas and/or model-driven Power Apps and Power Automate cloud flows for data collection, approvals and workflows across SharePoint, Dataverse, Microsoft 365 and other systems.
Develop analytics for P&L, procurement, accounts receivable, working capital, productivity and service delivery; use SQL to integrate, reconcile and validate multi-system data.
Perform root-cause, trend and variance analysis and convert findings into recommendations for Finance, Operations and senior leadership.
Own the solution lifecycle: requirements, design, development, testing, deployment, documentation, training, adoption and enhancement. Establish controls and lead UAT to confirm accuracy, workflows and security.
Lead demonstrations and office hours, monitor adoption, build stakeholder relationships, and quantify value through savings, faster cycles, reduced risk or improved accuracy.
3+ years in business intelligence, business analytics, financial analytics or a related field, including Finance and/or Operations support.

Nice-to-haves

Other Forms of Compensation: BONUS
Experience with Microsoft Fabric, Dataverse, SharePoint, Azure, Snowflake or enterprise data platforms.
Experience using MCP-embedded AI tools (e.g., Kiro) to automate report delivery or analysis.
Experience in facilities management, hospitality, outsourced services or multi-site operations; familiarity with ServiceNow, Nuvolo, SAP, Oracle, Dynamics 365 or similar CMMS/ERP systems.
Familiarity with continuous integration and Azure DevOps.
Evidence of Success
Apply to ESFM Services today!
ESFM is a member of Compass Group USA
Click here to Learn More about the Compass Story
Associates at ESFM are offered many fantastic benefits.
Disability Insurance
Retirement Plan

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlazureai

Platform: successfactors-unify
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

Paid Time Off

Parental Leave

Wellness