Data Warehouse Architect
TBD, Illinois
Open to Remote
Full Time
$155k - $160k
Data Warehouse Architect
This exceptional food manufacturing company, where passion meets precision, is in search of a skilled full-time Data Warehouse Architect to design and implement robust data warehouse solutions that drive food manufacturing innovations. In this role, you will be tasked with creating scalable data systems, optimizing data flow, and ensuring seamless integration across diverse product lines, from pasta to sauces to plant-based proteins. Shape the future of food and join a dynamic work environment backed by industry expertise. Apply now!
Required Skills & Experience
Tech Breakdowns
The Offer
Applicants must be currently authorized to work in the US on a full-time basis now and in the future.
#LI-AS14
This exceptional food manufacturing company, where passion meets precision, is in search of a skilled full-time Data Warehouse Architect to design and implement robust data warehouse solutions that drive food manufacturing innovations. In this role, you will be tasked with creating scalable data systems, optimizing data flow, and ensuring seamless integration across diverse product lines, from pasta to sauces to plant-based proteins. Shape the future of food and join a dynamic work environment backed by industry expertise. Apply now!
Required Skills & Experience
- Bachelor’s Degree – Information Technology, Computer Science, or related discipline
- Experience in Manufacturing
- 9+ years of full Software Development Life Cycle experience
- 7+ years practical experience with any ETL tool with complex transformation business rules implementation. 3+ years experience with SSIS or ADF, Talend
- 1+ year experience in implementing and supporting DW in a cloud platform
- 3+ years practical experience with writing SQL queries including complex queries
- 5+ years practical experience working on data warehouse projects using dimensional modeling
- Ability to analyze the existing SSIS Code for improvements, enhancements, conversion, and problem solving
- Project Management and SDLC understanding
- Strong troubleshooting skills
- Communication
- Willingness to learn
- Travel expectations = 10-25%
- Experience with Data Warehouse Design/Development in Manufacturing company
- Experience with SAP ERP as source system
- Experience in Cloud DW- Snowflake and Azure Cloud Platform using Azure Data Factory, Talend, Fivetran/dbt or Matillion
Tech Breakdowns
- 70% Design and Architecture (ETL tools, SQL, Cloud tech)
- 30% Development and Support (SSIS, ADF, Talend, PowerBI)
- 70% Hands On
- 30% Team Collaboration
The Offer
- Bonus eligible
- Medical, Dental, and Vision Insurance
- 401(k) match
Applicants must be currently authorized to work in the US on a full-time basis now and in the future.
#LI-AS14