ESFM® USA · 1 month ago
BUSINESS INTELLIGENCE AND ANALYTICS MANAGER
Chesterbrook, PA
Full-time
Onsite
Senior Level
$110K/yr - $145K/yr
5+ years expESFM is the corporate facilities management division of Compass Group USA, focusing on delivering comprehensive facility services. The Business Intelligence and Analytics Manager will lead the design and implementation of business intelligence solutions to support data-informed decision-making across the organization.
Facility ManagementProfessional ServicesService Industry
Responsibilities
Design and enhance dashboards, executive scorecards, KPI reports, and client-facing reporting packages withing Power BI and/or Google Looker platforms
Automate data flow from various sources including Snowflake, Smartsheet, SharePoint, Excel
Translate business needs into actionable BI solutions through stakeholder and client collaboration
Oversee data modeling, DAX, Power Query, and BI governance for accuracy and performance
Develop standardized KPIs, reporting frameworks, labor analytics tools, and client reporting templates
Leverage BI, automation, and AI tools to streamline workflows and improve decision-making
Stay current on BI trends and ensure compliance with data integrity, governance, and security standards
Qualification
Required
Bachelor's degree in Business Analytics, Information Systems, Computer Science, or related field
5+ years of experience in BI or data analytics within large, multi-site organizations
Advanced Power BI expertise, including DAX, Power Query, and data modeling
Proficient in SQL and cloud data warehouses such as Snowflake
Experience with automation tools (Alteryx, Power Automate)
Proven experience developing client-facing reporting and dashboards
Familiarity with Microsoft Power Platform, Smartsheet, and Microsoft 365
Deep understanding of BI concepts, data visualization, and best practices
Advanced data modeling and architecture skills, including star schema design
Strong SQL and database management capabilities
Advanced DAX, Power Query, and Excel proficiency
Ability to build/manage paginated reports
Ability to translate complex data into actionable insights and compelling visual narratives for internal and external clients
Preferred
Experience in Google Looker strongly preferred
Experience with SAP, Anaplan, or Essbase/Hyperion is a plus
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
Company
ESFM® USA
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).
10001+ employees
Funding
Current Stage
Late StageCompany data provided by crunchbase