Data and Analytics Manager

Job Description

Job Description

Meet Us: King Arthur Baking Company is an award-winning, audience-leading baking company with a strategic vision to be the resource for baking education and inspiration. Through traditional and new media, in-person and virtual education, we strive to be a leader in helping novice and expert bakers alike. We're not going anywhere - we've been part of the family since 1790. We work to build stronger communities and increase access and the connection to real foods. We take pride in our responsible sourcing and our "never bleached" guarantee. And we work closely with farmers, millers, and suppliers in a continued commitment toward sustainability. Our wheat flour is grown and milled right here in the United States. Flour this good uses only the purest ingredients, free from GMOs. As a founding B Corporation, we are committed to using the power of business as a force for social and environmental good. We believe every employee's contributions make our company what it is: vibrant, successful, and committed to spreading the joy of baking. We are a welcoming and inclusive 100% employee-owned company.

The Position: The Data and Analytics Manager drives Business Intelligence development, overseeing the ETL (extract, transform and load) processes, managing enterprise reporting, and business processes to support it leveraging the Microsoft SQL Server BI platform. Serving as both a technical expert and guide, they partner with stakeholders across the organization to deliver actionable insights, foster data literacy, and drive continuous improvement in analytics capabilities, while aligning the organization’s Business Intelligence strategy with operational and strategic goals.

The Benefits: Yes, we have the regular "stuff" - medical, dental, vision, company paid short- and long-term disability, life insurance, paid parental leave, paid time off to rest, paid holidays to have fun, a 401(K) with a company match. But here's what makes us different: 40 paid volunteer hours a year, profit sharing*, participation in the Employee Stock Ownership Plan (ESOP)* and knowing that those working with you are dedicated and engaged co-employee owners that believe in you and your extraordinary abilities to move us all forward.

The Location: Hybrid combining working from home, and onsite in White River Junction VT roughly 4 times per year. Qualified candidates must reside in the United States and be fully authorized to work.

The Pay: $117,800 to $159,000 annual salary; commensurate with experience

Essential Duties and Responsibilities

• Collaborate with and influence cross-functional teams to synthesize BI solutions to enable decision making and performance monitoring at KAB.
• Design, develop, test, implement and manage complex ETL (extract transform load) processes sourcing data from a variety of internal and external systems supporting Manufacturing, Distribution, Retail, Café, E-commerce, Sales, Marketing, Finance and Human Resources.
• Manage contract and/or fulltime developers supporting BI work.
• Develop Power BI reports and provide guidance and support to analysts building and enhancing their own reports
• Build and support processes using SQL Server Integration Services (SSIS) for high-quality extraction, transformation, and load (ETL) programs; SQL Server Analysis Services (SSAS) for tabular and multidimensional online analytical processing (OLAP) databases.
• Design, develop, maintain, and publish logical and physical data models, entity relationship diagrams and a common data dictionary.
• Design, document, maintain and publish data flow diagrams depicting source to target mappings supporting a tiered data architecture comprised of source systems, an operational data store (ODS), data warehouse (DW) and data marts (DM).
• Create documentation and other materials to support training and a company BI knowledgebase.
• Assist and train end-users in the design and development of reports, charts/graphs, and data visualizations.
• Operate as a subject matter expert, leader, and mentor to improve the knowledge, skills, and capabilities of DW/BI throughout the company.
• Participate in the evaluation of new technologies to improve business intelligence capabilities.
• Participate in rotating off-hours, on-call duties.

Experience and Education

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or related field is required. Equivalent work experience will also be considered.
• 5+ years of experience using Microsoft SQL Server and Power BI

• Experience sourcing data directly from disparate systems (ERP, WMS, CRM, POS, E-Com and HRMS) is required.

• Strong understanding of T-SQL (Transact SQL), DAX (Data Analysis Expressions), MDX (Multidimensional Expressions), and SQL data warehousing best practices.

• 3+ years experience using data warehouse concepts such as star schemas, snowflake schemas, operational data stores, data warehouses, data marts and OLAP technology.
• Familiarity with SAP Data Sphere desired.
• 3+ Years experience in database and report performance engineering, diagnosing, and tuning of ETL programs and reports.

• Experience with other relational databases, BI reporting and data discovery tools is highly desirable.

• Experience working with ERP systems such as SAP S/4HANA is highly desirable.
  • We value those who can demonstrate capability and articulate how prior experiences will help them transition into this role

Competencies

• Technical Expertise in Data Architecture and BI Tools – Mastery of Microsoft SQL Server BI stack (SSIS, SSAS, SSRS, Power BI), data modeling, and data warehousing concepts to deliver robust and scalable solutions.
• Analytical and Problem-Solving Skills – Ability to diagnose complex issues, optimize ETL and reporting performance, and translate data into actionable insights that drive business results.
• Leadership and Team Development – Proven ability to lead and mentor technical teams, set standards and best practices, and manage both internal and contract resources effectively.
• Business Partnership and Communication – Skilled at building relationships across diverse business functions, understanding stakeholder needs, and presenting complex information clearly to both technical and non-technical audiences.
• Strategic and Continuous Improvement Mindset – Focused on aligning Business Intelligence initiatives with organizational goals while proactively evaluating new technologies and improving existing processes.

Success Factors

• Genuine enthusiasm for the King Arthur’s mission and products and a commitment to living our values
• Is community minded gets involved, volunteers

Physical Requirements/Work Environment/Safety

The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Physical requirements

• Ability to work for prolonged periods at a desk, both in a home office and onsite, using a computer and other standard office equipment.
• Regular use of computer keyboard, mouse, and video conferencing tools.
• Ability to communicate effectively in person, over the phone, and through digital platforms.
• Occasional standing, walking, bending, or reaching within the office environment.
• May occasionally be required to lift or move items up to 15 pounds (e.g., office materials, documents).
• Visual acuity needed for reviewing documents, spreadsheets, and data on screens.
• Ability to commute to the office for in-person meetings, trainings, or other business needs as required.

Work environment

• Indoors, a normal office environment with little exposure to excessive noise, dust, or temperature changes.
• This role operates in a professional office environment where most work is performed at a desk.
• Remote work environment that meets KAB standards for work.

Safety

• Understands that safety is the responsibility of everyone at the organization and is responsible for adhering to/providing work in a safe and ergonomic manner, identifying unsafe conditions and correcting conditions immediately or reporting them promptly.
• Participates in safety and compliance training and safety and health programs.

Supervision

• N/A

Travel

• <5% Required to travel onsite to the King Arthur Baking offices in White River Junction, VT 4-6 times per year

Other Duties

• Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice

It is the responsibility of every employee to contribute to a positive and safe work environment through cooperative and professional interactions with co-workers, customers, and vendors. As a proud Benefit Corporation, King Arthur Baking expects our employees to adhere to company-wide green norms and remain educated on company impact campaigns.

There's room at our table for you! Apply today.

Equal Employment Opportunity Employer

All qualified applicants will receive consideration for employment without discrimination on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, or any other factors protected by law. King Arthur Baking provides reasonable accommodation to qualified individuals with disabilities to allow them to participate in both the application process and during employment. Such individuals are encouraged to seek accommodations to allow them to apply for a position, participate in the application process, and meet the essential functions and requirements of the position.

*Amounts vary based on achievement of financial targets. Participation based on hire date and program entry date.