Back

BI Reporting Analyst

Michael Angelo's Gourmet Foods

Money Icon
$36.06 /h
PAY RATE
Location Pin Icon
Denver, CO
LOCATION

Job Description

As posted by the hiring company

Job Overview:

The BI Reporting Anayst is responsible for supporting reporting and analytics solutions for Sovos Brands. The role requires full life cycle report development from requirement gathering, development, testing and implementation. The primary focus will be on our operational reports utilizing SQL Server Reporting Services (SSRS) to support various departments with business-critical data in a timely manner. The individual will also maintain the ongoing reporting inventory, resolve issues, recommend improvements, manage the service requests, and monitor jobs and report subscriptions. The ideal candidate will be capable of quickly understanding business processes, work collaboratively across all business processes and departments, and communicate effectively to all stakeholders.

Job responsibilities:

  • Analyze new report requests and existing report enhancement requests to obtain requirements and identify level of effort.
  • Work with the team to discuss request prioritization and identifying the appropriate Reporting and Analytics solutions to meet the requirements
  • Develop, test, and implement operational reports utilizing T-SQL and SQL Server Reporting Services (SSRS) and source control adhering to best practices
  • Validate report functionality with internal staff and/or business users
  • Write ad-hoc queries as needed
  • Manage existing reports and report subscriptions
  • Resolve reporting errors and escalate the issues when appropriate
  • Monitors the Sovos IT ticketing system for any reporting and analytics support related issues
  • Monitor daily SQL jobs and escalate when appropriate
  • Serve as a subject matter expert on Sovos Reporting solutions. Provides ongoing training for existing and new Reporting and Analytics users.

Minimum Qualifications:

  • Bachelor’s degree (B. S. or B. A.) in Information Technology, Software Engineering, Business or equivalent
  • 2-3 years proficiency with report development in MS SQL Server Reporting Services 2012 (SSRS) and newer
  • 2-3 years of MS SQL Server database design and development (i.e., stored procedures, views, T-SQL)
  • Understanding of relational and dimensional data modeling and data warehouse design concept
  • Intermediate to advanced Microsoft Excel skills, specifically power pivot functionality
  • Strong analytical skills, attention to details and focus on continuous improvement
  • Ability to work on multiple tasks and to self-manage deliverables, meetings, and information gathering
  • Team player
  • Excellent communication skills – able to present options and solutions in a way that can easily be understood by business users

Preferred Qualifications:

  • Development experience with SSIS, SSAS or Power BI is a plus

The targeted budget for this position is $60-$75K per year. This compensation budget range may be adjusted at any time at the discretion of the company. 

About Us:

Sovos Brands is a food company with a mission to acquire and build one-of-a-kind brands. We’re dedicated to bringing today's consumers delicious food for joyful living. We invest in brands that have exciting growth potential, combining industry expertise with fresh thinking to bring our products into more homes across America.

The brands in our portfolio include Rao's Homemade, a producer of premium pasta sauces, soups, frozen entrées and pasta; noosa, a producer of premium yoghurt made with whole milk and wildflower North American honey; Birch Benders, a fast-growing producer of delicious, better-for-you pancake and waffle mixes, toaster waffles, and pancake and baking cups; and Michael Angelo's, a leading producer of authentic frozen Italian entrées. 

Find out more about Sovos Brands at www.sovosbrands.com, Rao's Homemade at www.raos.com, noosa at www.noosayoghurt.com, Birch Benders at www.birchbenders.com; and Michael Angelo's at www.michaelangelos.com. 

We offer attractive compensation packages based upon background and experience. Package includes base salary, incentive bonus, medical benefits, 401K, and PTO. We maintain a drug and alcohol-free workplace. All candidates offered a position are required to pass a pre-employment drug test. We participate in E-Verify.  Sovos Brands is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. Sovos Brands is also committed to compliance with all fair employment practices regarding citizenship and immigration status.