SENIOR BI ANALYST, FINANCE - REMOTE (Chesterbrook, PA, US, 19087-5564)

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 .

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 analyti