SENIOR BI ANALYST, FINANCE - REMOTE

Esfm USA; Northern (KY); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical

Dental

Vision

life Insurance/AD

Disability Insurance

Retirement Plan

Paid Time Off

Holiday Time Off

Health and Wellness Programs

Commuter Benefits

Flexible Spending Accounts (FSAs)

Paid Parental Leave

Personal Leave

Job summary

ESFM is seeking a Senior BI Analyst, Finance to partner with Finance, Operations and client teams. The role focuses on Power BI development, Power Apps and Power Automate to replace manual processes and improve decision-making.

The analyst will challenge processes, translate needs into technical solutions, and drive adoption through documentation and training while ensuring data quality and security across systems.

Qualifications

• 3+ years in business intelligence, analytics or related field, including Finance/Operations support.
• Advanced Power BI expertise incl. Power Query, DAX, semantic modeling and security.
• Production experience deploying Power Apps and Power Automate flows for approvals, data collection and reporting.
• Proven ability to improve financial/operational outcomes through analytics or automation.
• Strong SQL skills for data discovery, transformation and validation.

Responsibilities

• Partner with Finance, Operations and client teams to identify reporting needs and translate to specifications.
• Automate manual reporting, data-entry and workflows using Power BI and Power Platform.
• Design and maintain Power BI dashboards, semantic models and paginated reports.
• Build Power Apps and Power Automate flows for data collection and approvals.
• Develop analytics for P&L, procurement, accounts receivable and working capital.

Skills

Power BI development

Power Apps

Power Automate

SQL

Data modeling

Stakeholder communication

Project management

Automation

Tools

SharePoint

Dataverse

Microsoft 365

SQL Server

Azure

Snowflake

Job description

ESFM

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.

Job Summary

We are seeking a SENIOR BI ANALYST, FINANCE tto 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.

ESFM is a member of Compass Group USA

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, or copy/paste the link below for paid time off benefits information.

https://www.compass-usa.com/wp-content/uploads/2023/08/2023_WageTransparency_ESFM.pdf

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: https://info.flclearinghouse.com/

Applications are accepted on an ongoing basis.

Eurest Services maintains a drug-free workplace.