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.