Jobs · Analyst · Wisconsin

Advanced Analytics Manager

Molson Coors Beverage Company · Milwaukee, WI · 1 mo ago
Analyst$109k–$143k/yrFull-time
We need to output HTML fragment with sections: About the role? The posting includes intro paragraphs about company, but we need to extract sections: maybe "About the role" (the description of role), "Responsibilities" (What You'll Be Brewing), "Requirements" (Key Ingredients), "Benefits" (Beverage Bonuses + Benefits include...), "Pay" (Pay And Benefits section includes salary range). Also maybe "Qualifications" but we can combine with Requirements. We must not repeat job title as heading. No Job ID. Remove boilerplate like EEO, accommodation, etc. Also remove duplicated lines. Must preserve all substantive info. We need to decide sections: About the role (intro paragraph about role). Responsibilities (What You'll Be Brewing). Requirements (Key Ingredients). Benefits (Beverage Bonuses + Benefits include...). Pay (Pay And Benefits). Possibly also "Schedule" not present, so omit. We must not create sections with filler like "commensurate with experience". Not present. We need to use

for section headings. Use
  • for any list of duties/requirements/benefits. Use

    for prose. We need to preserve all substantive info: The intro about Molson Coors mission etc maybe part of About the role? The posting includes "Cheers to creating an incredible tomorrow! At Molson Coors, we tackle big challenges..." That's company overview. Could be part of About the role or maybe not needed? It's substantive but not role-specific. The instruction: preserve ALL substantive information; do not invent or summarize away detail. So we should include that company overview somewhere. Could be in About the role section as a paragraph before role specifics. We need to avoid duplication: The "Benefits include 15 days vacation..." appears also in Pay And Benefits section. We'll combine. We need to remove EEO, accommodation, etc. Let's extract content: Company overview paragraph: "Cheers to creating an incredible tomorrow! At Molson Coors, we tackle big challenges and defy the status quo. With a proud legacy of excellence, an incredible portfolio of beer, seltzers, spirits, and non-alcohol brands, and a bold vision for our future... we’re on the path to transforming the beverage industry. That requires remarkable individuals who are curious, tenacious, and never afraid to fail forward. We seek, value and respect everyone’s unique perspectives and experiences knowing that we are stronger together. We collaborate as a team and celebrate each other’s successes. Here’s to crafting careers and creating new legacies." Then role intro: "Crafted Highlights: In the role of Advanced Analytics Manager – Acquired Brands based in Chicago, IL or Milwaukee WI, you will be a part of the Molson Coors Commercial Reporting & Analytics team. This role is responsible for developing analytics and insights that support the current and future acquired brands. Success will be measured by delivering integrated analytics that are centralized, insightful, and most importantly, actionable. This position reports to the Director, Commercial Reporting & Analytics within the Strategies & Capabilities organization. This newly created position will work across our commercial, leadership and technology teams to support the reporting and analytics transformation for the newly acquired Monaco brands and any future purchases or integrations." Responsibilities (What You’ll Be Brewing): List items: - Lead the reporting & analytics activities for all acquired brands. - Partner cross-functionally with commercial, technology and strategy & capabilities teams to define reporting & analytics tools and processes that optimally augment the overall MCBC reporting & analytics strategy. - Lead the development and optimization of centralized, integrated reporting and analytics tools for acquired brands, ensuring alignment with KPIs such as retail execution, competitive benchmarking, etc. - Communicate acquisition performance across all levels of the organization and act as the key analytics liaison with senior leadership and integration teams. - Drive exception-based reporting and development of dashboards using advanced data visualization tools (preferably Power BI / Tableau), enabling actionable insights and ROI-focused decision-making across commercial and sales teams. - Lead the integration and interpretation of syndicated data sources (IRI, Nielsen) and internal datasets to inform strategic decisions and category growth opportunities. - Serve as a coach and technical advocate for the Reporting & Analytics team by fostering closer partnership with MCBC IT teams and identifying opportunities for technical standardization & optimization across the team. Requirements (Key Ingredients): List: - Bachelor’s degree in business, analytics, mathematics, or related field; Master’s degree a plus. - 5+ years of experience in corporate analytics, reporting, or business intelligence, ideally within CPG or beverage industries. - Proven expertise in developing enterprise-scale reporting and KPI frameworks using tools such as Power BI, Tableau, Excel, and SAP/Business Objects. - Strong experience working with large datasets and relational databases; advanced proficiency in Power Query, DAX, and SQL. - Demonstrated ability to lead cross-functional analytics initiatives and translate complex data into clear, actionable insights. - Experience with syndicated data (IRI, Nielsen) and its application in sales and category strategy. - Excellent communication, stakeholder management, and project leadership skills. - Strong business acumen, curiosity, and a proactive mindset toward continuous improvement. Benefits (Beverage Bonuses + Benefits include): We need to capture all benefit statements: From "Beverage Bonuses:" paragraph: "We care about our People and Planet and have challenged ourselves with stretch goals around our key priorities We care about our communities, and play our part to make a difference – from charitable donations to hitting the streets together to build parks, giving back to the community is part of our culture and who we are Engagement with a variety of Business Resource Groups, which can provide volunteer opportunities, leadership experience, and networking through the organization Ability to grow and develop your career centered around our First Choice Learning opportunities Participation in our Total Rewards program with a competitive base salary, incentive plans, parental leave, health, dental, vision, retirement plan options with incredible employer match, generous paid time off plans, an engaging Wellness Program, and an Employee Assistance Program (EAP) with amazing resources Access to cool brand clothing and swag, top events and, of course... free beer and beverages! Work within a fast paced and innovative company, meeting passionate colleagues and partners with diverse backgrounds and experiences" Then later: "Benefits include 15 days vacation, 10 paid holidays, 4 personal floating holidays and 64 hours of sick time." Also Pay And Benefits section includes salary range and benefits description: "Participation in our Total Rewards program with a competitive base salary, incentive plans, parental leave, health, dental, vision, retirement plan options with incredible employer match, generous paid time off plans, an engaging Wellness Program, and an Employee Assistance Program (EAP) with amazing resources + paid time off (including holidays, vacation days and sick days)." Also "$23,000 on average spent on benefits per employee, including but not limited to health, dental, vision, retirement with above market employer match, wellness incentives and EAP + paid time off (including holidays, vacation days and sick days)." Also "Pay And Benefits At Molson Coors, we’re committed to paying people fairly and equitably for the work they do. Job Posting Total Rewards Offerings: $109,100.00 - $143,200.00 (posting salary range) + 15% target short term incentive + $23,000 on average spent on benefits per employee, including but not limited to health, dental, vision, retirement with above market employer match, wellness incentives and EAP + paid time off (including holidays, vacation days and sick days). The posting range provided above for salary is what we, in good faith, believe we would pay for this role at the time of this posting. We ultimately pay based on a number of non-discriminatory factors that inform pay decisions including but not limited to the required work location, previous work experience, skill set and internal equity." We need to preserve all substantive info, but we should avoid duplication. We'll combine benefits into a Benefits section, listing items as bullet points. We need to ensure we don't repeat the same sentence multiple times. We'll synthesize but must preserve all info; we can combine similar points but not lose detail. For example, "competitive base salary, incentive plans, parental leave, health, dental, vision, retirement plan options with incredible employer match, generous paid time off plans, an engaging Wellness Program, and an Employee Assistance Program (EAP) with amazing resources" appears twice; we can include once. Also "$23,000 on average spent on benefits per employee" is a detail; include. Also "15 days vacation, 10 paid holidays, 4 personal floating holidays and 64 hours of sick time." include. Also "Access to cool brand clothing and swag, top events and free beer and beverages!" include. Also "Engagement with a variety of Business Resource Groups, which can provide volunteer opportunities, leadership experience, and networking through the organization" include. Also "Ability to grow and develop your career centered around our First Choice Learning opportunities" include. Also "We care about our People and Planet and have challenged ourselves with stretch goals around our key priorities" maybe vague but it's substantive; include. Also "We care about our communities, and play our part to make a difference – from charitable donations to hitting the streets together to build parks, giving back to the community is part of our culture and who we are" include. Also "Work within a fast paced and innovative company, meeting passionate colleagues and partners with diverse backgrounds and experiences" include. Now Pay section: salary range $109,100.00 - $143,200.00 + 15% target short term incentive. Also mention that pay based on factors. We should not create Schedule section. Now produce HTML:

    About the role

    Cheers to creating an incredible tomorrow! At Molson Coors, we tackle big challenges and defy the status quo. With a proud legacy of excellence, an incredible portfolio of beer, seltzers, spirits, and non-alcohol brands, and a bold vision for our future... we’re on the path to transforming the beverage industry. That requires remarkable individuals who are curious, tenacious, and never afraid to fail forward. We seek, value and respect everyone’s unique perspectives and experiences knowing that we are stronger together. We collaborate as a team and celebrate each other’s successes. Here’s to crafting careers and creating new legacies.

    Crafted Highlights: In the role of Advanced Analytics Manager – Acquired Brands based in Chicago, IL or Milwaukee WI, you will be a part of the Molson Coors Commercial Reporting & Analytics team. This role is responsible for developing analytics and insights that support the current and future acquired brands. Success will be measured by delivering integrated analytics that are centralized, insightful, and most importantly, actionable. This position reports to the Director, Commercial Reporting & Analytics within the Strategies & Capabilities organization. This newly created position will work across our commercial, leadership and technology teams to support the reporting and analytics transformation for the newly acquired Monaco brands and any future purchases or integrations.

    Responsibilities

    • Lead the reporting & analytics activities for all acquired brands.
    • Partner cross-functionally with commercial, technology and strategy & capabilities teams to define reporting & analytics tools and processes that optimally augment the overall MCBC reporting & analytics strategy.
    • Lead the development and optimization of centralized, integrated reporting and analytics tools for acquired brands, ensuring alignment with KPIs such as retail execution, competitive benchmarking, etc.
    • Communicate acquisition performance across all levels of the organization and act as the key analytics liaison with senior leadership and integration teams.
    • Drive exception-based reporting and development of dashboards using advanced data visualization tools (preferably Power BI / Tableau), enabling actionable insights and ROI-focused decision-making across commercial and sales teams.
    • Lead the integration and interpretation of syndicated data sources (IRI, Nielsen) and internal datasets to inform strategic decisions and category growth opportunities.
    • Serve as a coach

Similar jobs