Senior AI & BI Solutions Analyst

Compass Group USA; New York (NY); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical

Vision

Life Insurance/ AD

Disability Insurance

Retirement Plan

Paid Time Off

Holiday Time Off

Associate Shopping Program

Health and Wellness Programs

Discount Marketplace

Identity Theft Protection

Pet Insurance

Employee Assistance Program

Flexible Spending Accounts (FSAs)

Personal Leave

Job summary

Compass Group USA's Eurest division seeks a Senior AI Solutions Analyst to deliver rapid, high-quality ad-hoc and exploratory reporting while maintaining dashboards and translating business questions into actionable insights. You will identify repeatable work and collaborate with the BI team to standardize solutions.

The role develops Power BI datasets, semantic models, and optimized SQL; SAP/AI tools and cloud data environments are used to accelerate decision-making.

Qualifications

• 3 to 6 years in BI and data development.
• Advanced Power BI with DAX, semantic modeling, and SQL optimization.
• Experience in a consultative role translating business needs into data solutions.
• Experience designing enterprise reporting and financial analytics; food service experience a plus.
• Proficiency with DBT, data warehousing concepts, ETL/ELT best practices.
• Familiarity with CI/CD tools (GitHub) and orchestration tools (Airflow).
• Experience with modern analytics platforms and cloud data environments (Microsoft Fabric; Azure SQL; Snowflake).
• Strong communication and ability to present insights to both technical and non-technical audiences.
• Experience using AI tools (ChatGPT, Copilot, Claude) to enhance analytics and automation.
• Collaborate with Automations team on AI-powered solutions.

Responsibilities

• Deliver ad-hoc and exploratory reports.
• Maintain and enhance dashboards.
• Support urgent account requests.
• Identify repeatable work for standardization.
• Escalate high-value repeatable tasks.
• Develop Power BI datasets and semantic models.
• Build standardized dashboards and reports.
• Optimize SQL queries and data pipelines.
• Ensure performance, security, and scalability.
• Collaborate with stakeholders to define reporting requirements.
• Design and maintain KPIs dashboards and data visualizations.
• Data extraction, transformation, and validation for accuracy.
• Integrate data from multiple sources for decision-making.
• Identify data quality gaps and implement improvements.
• Present findings clearly to non-technical audiences.
• Maintain and enhance BI products and automate reporting workflows.

Skills

Power BI

DAX

Semantic modeling

SQL development

DBT

GitHub

CI/CD

Airflow

Azure SQL

Snowflake

Microsoft Fabric

AI platforms

Collaboration

Tools

Airflow

GitHub

DBT

Snowflake

Azure SQL Managed Instance

Job description

Compass Group USA's Eurest division seeks a Senior AI Solutions Analyst to deliver rapid, high-quality ad-hoc and exploratory reporting while maintaining dashboards and translating business questions into actionable insights. You will identify repeatable work and collaborate with the BI team to standardize solutions.

The role develops Power BI datasets, semantic models, and optimized SQL; SAP/AI tools and cloud data environments are used to accelerate decision-making.