Business Intelligence Architect

Business Unit Overview

Headquartered in Lakeville, Minn., Post Consumer Brands, a business unit of Post Holdings, Inc., is dedicated to providing people and their pets with delicious food choices for every taste and budget. The company's portfolio includes beloved brands such as Honey Bunches of Oats, PEBBLES, Grape-Nuts and Malt-O-Meal cereal, and Peter Pan peanut butter, as well as Rachael Ray Nutrish, Kibbles 'n Bits and 9Lives dog and cat food. As a company committed to high standards of quality and to our values, we are driven by one idea: To make lives better by making delicious food accessible for all. For more information about our brands, visit www.postconsumerbrands.com and follow us on LinkedIn for the latest news.

Brand

Post Consumer Brands recently acquired several iconic pet food brands, venturing into a new market while remaining true to our purpose to provide delicious and accessible food that our consumers love. We're always searching the center store for the next exciting product to add to our portfolio, and right now, we're growing and need passionate, driven individuals with diverse perspectives to help us reach greater heights. That's where you come in. Join a team where your voice is not only heard but valued. Make a real impact on brands enjoyed by millions of people and their pets.

At Post Consumer Brands, we take pride in our longstanding legacy of making one of every five breakfast cereals families eat daily. Today, we're just as focused on our future as we expand our grocery business with different shelf-stable foods, including snacks and peanut butter. We are committed to providing accessible and delicious food for families, and we're always searching the center store for the next exciting product to add to our portfolio. As we soar to new heights, we need creative, determined individuals from all walks of life to join our team, where your unique perspective and ideas are acknowledged and valued. Be a part of a company that empowers you to make a difference that's evident on grocery store shelves and families' tables across North America.

Location Description

Post Consumer Brands corporate headquarters in Lakeville, Minn. is about 20 miles south of Minneapolis and St. Paul, Lakeville has all the benefits of smaller town living with access to everything a large metropolitan area has to offer. Join more than 400 team members collaborating on the two-building campus to help put breakfast on the tables of millions of consumers in North America.

Responsibilities

MOM Brands Company, LLC seeks a BI Architect in Lakeville, Minnesota, to hold a highly technical, analytics-focused role that requires interaction and partnership with leaders across the business. The BI Architect is responsible for establishing and maintaining enterprise BI standards, and is also responsible for leading the design and development of complex business reporting systems using, Cognos, TM1, and Oracle SQL DB. The specific duties and responsibilities include:

• Design, develop, test, deploy, and support Cognos and TM1 reports, reporting packages, and cubes;

• Design, develop, test, deploy, and support related Oracle SQL queries and views;

• Understand and leverage Cognos and TM1 best-practices and advanced features to deliver intuitive, accurate, high-impact reports;

• Collaborate with business leaders and users to conceptualize and design reporting solutions that drive business decision making;

• Combine data from multiple sources to develop integrated data sources and reports;

• Lead the development of new data sources to improve analysis and reporting;

• Create, enhance, and maintain Cognos Framework Manager Models and support the creation of aggregate tables;

• Work on data modelling and data validation;

• Stay up-to-date with best practices and maintain enterprise BI standards for the Cognos and TM1 environments;

• Work on code migration, code change documentation, and defect management;

• Perform proactive and reactive Cognos and TM1 maintenance and support tasks;

• Maintain security and permissions in Cognos and TM1

• Identify process improvement opportunities and take the initiative to implement those improvements;

• Create documentation and provide training on Cognos and TM1 and the use of data/information;

• Provide guidance and mentorship to less experienced analysts on topics such as analysis, documentation, industry best practices, efficient modeling of data etc.;

• Demonstrate strong written and verbal communication skills; and

• Perform ad-hoc duties as needed based on changing business needs.

Qualifications

The position requires a Bachelor's Degree in Data Analytics, Computer Science, Software Engineering, Electronic Engineering, Information Management, or a closely related field, or a foreign equivalent degree. We require seven (7) years of progressively responsible Business Intelligence Development experience, including seven (7) years of: dimensional modeling, OLAP tools, building and maintaining complex reports using IBM Cognos, and writing simple to complex SQL queries in Oracle. We also require seven (7) years of experience with the following tools: Framework Manager, Report Studio, Query Studio, Transformer, Power Play, and Analysis Studio. Finally, four (4) years of experience developing data analytics solutions in TM1 is required. Experience can be gained concurrently. May partially telecommute from home within normal commuting distance from our Lakeville (Minnesota) office. Please apply online https://jobs.postholdings.com/postconsumerbrands-home or send resume to Michelle Krebs, MOM Brands Company, LLC, 20802 Kensington Boulevard, Lakeville, MN 55044 or mfkrebs@postholdings.com