Compass Group, North America BUSINESS INTELLIGENCE MANAGER in DENVER, Colorado

A family of companies and experiences

As the leading foodservice and support services company, Compass Group USA is known for our great people, great service and our great results. If you’ve been hungry and away from home, chances are you’ve tasted Compass Group’s delicious food and experienced our outstanding service. Our 200,000 associates work in award-winning restaurants, corporate cafes, hospitals, schools, arenas, museums, and more in all 50 states.

Our reach is constantly expanding to shape the industry and create new opportunities for innovation. Join the Compass family today!

great people. great services. great results.

Each and every individual plays a key role in the growth and legacy of our company. We know the next big idea can come from anyone. We encourage developing and attracting expertise that differentiates us as a company as we continue to raise the bar.

The Manager of Business Intelligence plays a key leadership role in the end-to-end analytical reporting and systems development processes. This will include process improvement through automation, application development, reports, vendor imports/exports, data warehousing architecture and other data related initiatives. This role is responsible for ensuring the quality and efficiency of business processes through technology. Responsibilities include working with senior leadership to identify opportunities and develop, redesign, and maintain systems and processes to improve the overall effectiveness of SpenDifference.

One of the main responsibilities of this position will be to manage a variety of business applications including contract management, project management, and our BI system. This work will include completing data analysis, developing imports and exports, writing reports, ensuring data quality, troubleshooting issues, creating documentation, and fielding user questions/feedback.

This role will be located in Denver, CO.

Job Summary

Job Duties:

  • Managing the entire development process from requirements gathering and developing to implementation and maintenance

  • Assists in analytics, as well as writes SQL (Structured Query Language) queries and stored procedures

  • Creates new and managed existing SQL Server Reporting Services reports (SSRS) data analysis, building ad hoc queries, and manages existing reports

  • Develops new SSIS packages to meet business needs

  • Develops new and manages existing OLAP solutions with SSAS

  • Gathers business requirements for Business Intelligence reporting

  • Understands business mathematics common in Economics and Finance

  • Manages the definition, development, and documentation of application’s business requirements, objectives, deliverables, and specifications on a project-by-project basis in collaboration with internal users and departments

  • Responsible for ensuring data quality and integrity

  • Troubleshoots and provides solutions as 1st point of contact whether through direct intervention, or as a liaison to service providers and 3rd party support vendors for all end user issues with business application issues

  • Must be fully engrained in the customer focused culture of the organization, nurturing relationships with all internal and external stakeholders

Job Requirements:

  • Minimum 7+ years working with and supporting business and/or technology users in the area of business intelligence, data warehousing, reporting, and analytics

  • Minimum 5+ years in development of BI systems and architectures using operational database management systems, notably MS SQL Server (SSIS, SSRS, SSAS)

  • Experience supporting application end users

  • The following are desired but not required

o Azure Experience

o .NET experience

o Microsoft Dynamics SL

o Restaurant supply chain knowledge

  • Proficiency writing MS T-SQL including expert familiarity with select statements, joins, updates, and deletes

  • Aptitude in writing/publishing reports with SSRS

  • Developing and managing OLAP solutions with SSAS

  • Comfort with importing and exporting data from Management Studio

  • Ability to configure server/database

  • Ability to write multi-step ETL packages with SSIS, familiarity with included components and proficiency in troubleshooting logic issues

  • Intermediate to Advanced skills with the MS Office suite (specifically Excel, Word, PowerPoint, Outlook)

  • Strong math skills with regard to accounting, economics, and statistics

  • Ability to write end-user documentation in a manner that translates complex business logic to language that average users can understand

  • Strong analytical and product management skills required, including a thorough understanding of how to interpret customer business needs and translate them into application and operational requirements

  • Bachelor’s Degree in Information Technology or professional experience equivalent

Apply to Foodbuy today!

/Foodbuy is a member of Compass Group USA/

Click here to Learn More about the Compass Story

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.

*Req ID: *203184