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.
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
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
CAMERON C BLACK