Impact Workers

26/06/2023

Business Intelligence & Data Warehouse Development Lead

About the role

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 Business Intelligence & Data Warehouse Development Lead designs, develops, and manages enterprise reporting, the Operational Data Store (ODS), Data Warehouse (DW), and business processes to support it leveraging the Microsoft SQL Server BI platform. This team member facilitates BICC (Business Intelligence Competency Center) meetings and power user group meetings to collaborate with our fellow bakers to leverage data to support decision-making.

Reports to: Director of Integration and Data Engineering

Location: White River Junction, VT or Remote; anywhere in the United States

 

The Benefits:

Yes, we have the regular “stuff” – medical, dental, vision, company paid short- and long-term disability, life insurance, 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.

 

Essential Responsibilities:

  • Design, develop, test, implement and manage complex ETL processes sourcing data from a variety of internal and external systems supporting Manufacturing, Distribution, Retail, Café, E-commerce, Sales, Marketing, Finance and Human Resources.
  • Participate and contribute to projects requiring BI support.
  • Develop Power BI reports and support analysts developing their own reports.
  • Build and support processes using SSIS for high quality extraction/transformation/load (ETL) programs, SSAS for Tabular and Multidimensional OLAP databases, SSRS for reporting.
  • Develop, roll-out and implement a Business Intelligence Strategy to ensure alignment between IT and the business.
  • 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).
  • Build and maintain solid relationships with internal and external customers, vendors, and peers.
  • Work collaboratively with key business users to understand their information needs and provide high quality, high performing, and intuitive data solutions.
  • 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 business intelligence technologies such as data modeling, ETL, appliances, reporting tools and portal solutions.
  • Participate in rotating off-hours, on-call duties.

This should not be construed as an exhaustive list of all job duties and responsibilities. There may be some variation and/or development of the above duties and responsibilities without changing the general nature of the job.

 

Team Management/Leadership:

  • Manage contract and/or fulltime developers supporting BI work.
  • Openly communicates team and individual expectations and concerns
  • Is readily accessible, willing to listen and seeking to understand
  • Engages their team: motivating, directing, inspiring, and involving them in decisions
  • Nurtures growth in others by supporting their passions, strengths, and work styles
  • Maintains employee engagement by recognizing outstanding performance and managing performance issues

 

Minimum Job Requirements:

  • 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 Database, SSIS, SSRS, SSAS and Power BI is required.
  • Strong communication and collaboration skills required.
  • Experience sourcing data directly from disparate systems (ERP, WMS, CRM, POS, E-Com and HRMS) is required.
  • Strong understanding of T-SQL, MDX, DAX, and SQL data warehousing best practices.
  • Expert understanding of data warehouse concepts such as star schemas, snowflake schemas, operational data stores, data warehouses, data marts and OLAP technology.
  • Expert knowledge 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.
  • Understanding of Master Data Management and the business processes needed to support it.
  • Self-motivated, able to work independently and collaboratively with IS peers and managed service providers to identify, understand and analyze complex data in a variety of source systems such as: ERP, WMS, CRM, E-Com, HRMS, etc.
  • Experience working with ERP systems such as SAP S/4HANA is highly desirable.
  • Ability to participate in rotating off-hours, on-call duties required.

 

Success factors/competencies for this role:

  • Open to change, recommends actions for continuous improvement
  • Thinks and acts strategically, understands how their role contributes to larger outcome
  • Provides exemplary customer service to both internal and external customers
  • Sets high standards for oneself, meet deadlines
  • Learns from mistakes, is receptive to feedback
  • Effective communicator, listens and respects others’ points of view
  • Participates in team problem-solving and decision making
  • Is community minded – gets involved, volunteers

 

Physical Requirements:

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.

  • Ability to work at a computer for extended periods of time
  • Ability to work in an open office environment which can be noisy at times
  • Ability to collaborate with team members in online meetings
  • Ability to periodically attend meetings frequently held in buildings located across our White River Junction and Norwich, Vt campus.

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 Flour 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 achievement of financial targets. Participation based on hire date and program entry date.

King Arthur Baking Company

Owner and operator of a bakery company intended to produce and sell various wheat made products. The company’s products include whole grain banana bread, pancake mix, gluten free flours and organic flours, enabling consumer to enjoy various tasty and healthy wheat products.

Certified B-Corporation
Size: 201-500
Year Founded: 1790

Share this job