This job listing has expired and the position may no longer be open for hire.

Data Warehouse Architect at Henny Penny

Posted in Other 30+ days ago.

Location: Eaton, Ohio





Job Description:

Do you want to work for a global company that creates remarkable experiences through people, products, and food? If you want to be part of a rewarding People First culture that values relationships, trust, and taking the long view, then this is the place for you. Henny Penny was named the 2021 Dayton Business of the Year for many good reasons. Read on to learn more!


Data warehouse architects will design and maintain data management solutions. As a data warehouse architect, his/her job includes analyzing company's data needs, developing database management solutions, and deploying data management software for storing and retrieving data from cloud or machine storage.


This responsibility includes, but is not limited to, identifying business data elements, aligning data taxonomy, designing corporate data management program, translating business and analytical requirements into an architectural blueprint to achieve our business objectives. He/she will also assist in creating and maintaining our analytic capabilities by identifying areas to unlock value from our data to drive our operations.



What We Offer



  • An opportunity to work for a company that is 100% employee-owned. As an employee-owner, you will be enrolled in our employee stock ownership plan (ESOP) program following one year of service. This is a qualified retirement plan that is separate from your 401k and consists only of Henny Penny shares that will be paid out when you retire (or when you leave the company, but we hope you'll stay!)


  • Annual company performance bonus in addition to base salary


  • Flexibility to work from home 2 days per week


  • Defined career paths so you'll always know what's next and what steps can get where you want to go


  • Professional development opportunities including tuition reimbursement and unlimited free access to LinkedIn Learning courses


  • A competitive benefits package including medical, dental, vision, 401(k) with company match, PTO, and paid holidays


  • Onsite wellness clinic offering preventive care services such as wellness screenings, annual physicals, and related lab work at no cost to employee-owners


  • Activities including department outings, holiday parties, and our annual company-wide Thanksgiving Dinner



What You'll Be Doing



  • Design and build Data Warehouse structures (databases and SSAS cubes)

  • Develop unique, simple solutions to meet the immediate and long-term needs of information customers and stakeholders

  • Develop data architecture, data modeling, and ETL mapping solutions

  • Support the development and validation required throughout the entire lifecycle of the data warehousing and business intelligence systems

  • Support the data warehouse technical ecosystem, including reporting and analytic applications

  • Ability to present complex topics to key stakeholders, business analysts and senior executives

  • Ability to document business, functional, and technical requirements

  • Lead cross-functional teams in developing innovative client solutions

  • Understanding of cloud data warehouse platforms and modern data warehousing techniques

  • Troubleshooting the reporting database environment and reports

  • Provide quality assurance of imported data, working with quality assurance analyst if necessary

  • Commissioning and decommissioning of data sets

  • Managing and designing the reporting environment, including data sources, security, and metadata

  • Generating reports from single or multiple systems




What We're Looking For



  • Bachelor's Degree in Computer Science, Engineering or equivalent experience or hard science and/or Banking Certification in a related field

  • Five or more years of experience as a Data Warehouse architect and ETL developer

  • At least three years of data modeling experience, and knowledge of 3NF, Star-Schema and other data warehousing modeling techniques

  • Experience with BI reporting tools (Power BI, Tableu etc.)

  • Ability to communicate information clearly, concisely, and effectively both orally and in writing

  • Five or more years of experience with data analysis and data profiling using SQL and other tools

  • Extensive experience in T-SQL development, MS SQL Server preferred, with strong knowledge in query optimization

  • Very strong written and verbal communication skills

  • Big Data and Advanced Analytics Experience; Bachelor's Degree in related field

  • Highly motivated, hard-working, excited to learn, and able to motivate others

  • High-level experience in methodologies and processes for managing large-scale databases

  • Ability to analyze existing tools and databases and provide software solution recommendations

  • SQL Server analysis services. Tabular modeling




About Us



We're known in our industry for making the best commercial food equipment in the world. Every day, millions of people eat in restaurants operating Henny Penny equipment. We're a behind-the-scenes engine in the world's most demanding kitchens, including long-term partners like McDonald's, Chick-fil-A, KFC, and Wendy's. We're 1,000+ employee-owners who thrive by living a People First mission: to support employees in becoming the best version of themselves both personally and professionally.


We recently completed the largest expansion in our history with the addition of 150,000 square feet on our Eaton campus. This expansion drives development of the world's most reliable, easy-to-use equipment with an innovative new space for global research and development. We have several collaborative spaces for our project teams, a dedicated electrical engineering lab for our hardware and software engineers, a full model shop for rapid prototyping, and a brand-new test lab that has 300 feet of hood space to test new equipment on our product roadmap. On top of that, we have a new state-of-the-art kitchen for our food science group to meet with our customers, understand what they need, and then dial in our equipment to help them make legendary menu items.


Henny Penny is an Equal Opportunity Employer. Qualified applicants are considered without regard to race, creed, color, religion, alienage or national origin, ancestry, citizenship status, age, physical or mental disability or handicap, sex or gender (including pregnancy, childbirth and pregnancy-related conditions), marital status, veteran or military status, sexual orientation, genetic information, gender identity or expression (including transgender status), or any other characteristic protected by applicable federal, state or local laws.
More jobs in Eaton, Ohio


Henny Penny

Jackson Hewitt

Jackson Hewitt
More jobs in Other


Smart & Final

Smart & Final

Smart & Final