Data Warehouse Architect

Restaurant Supply Chain Solutions (A Yum! Brands Co-Op) - Louisville, KY

Full-time - Senior

Louisville, KY

Food Services and Drinking Places

About the position

The Data Warehouse Architect at Restaurant Supply Chain Solutions, LLC, a Yum! Brands Co-op, is responsible for designing and implementing robust data warehousing solutions that align with business needs. This role requires extensive experience in data architecture, database design, and data integration strategies, ensuring efficient data flow and compliance with industry regulations.

Responsibilities

• Design and develop scalable data warehouse solutions that support analytics and reporting.
• Collaborate with stakeholders to gather requirements and translate them into technical specifications.
• Design data models, ETL processes, and data integration strategies to ensure efficient data flow.
• Evaluate and implement data warehousing technologies, tools, and best practices.
• Optimize data storage and retrieval processes to enhance performance and efficiency.
• Ensure data integrity, security, and compliance with industry regulations.
• Provide technical leadership and mentorship to junior data engineers and analysts.
• Monitor and troubleshoot data warehouse issues.
• Stay updated with industry trends and emerging technologies in data warehousing.

Requirements

• Bachelor's degree in computer science, Information Technology, Business Administration, or related field required.
• Minimum of 5 years' experience as a Data Warehouse Architect or similar role.
• 7+ years leveraging Microsoft technologies (SQL, SSIS, SSRS, SSAS, Power BI).
• Experience in Azure DevOps or similar technology.
• Strong knowledge of data modeling, ETL processes, and data warehousing concepts.
• Familiarity with data warehousing solutions (e.g., AWS Redshift, Google BigQuery).
• Experience with data visualization tools (e.g., Tableau, Power BI) is a plus.
• Experience in Visio, Lucidchart or other diagramming software.
• Strong organizational skills.
• Strong analytical and problem-solving skills, with the ability to analyze complex data, systems, and processes.
• Excellent verbal and written communication skills, with the ability to effectively communicate technical concepts to non-technical stakeholders.
• Strong interpersonal skills and the ability to build positive relationships with cross-functional teams.
• Ability to thrive in a fast-paced and dynamic environment, with the flexibility to adapt to changing priorities and requirements.
• Demonstrated ability to work independently and collaboratively as part of a team.
• Meticulous attention to detail and a commitment to delivering high-quality work products.
• Ability to prioritize tasks, manage multiple projects simultaneously, and meet tight deadlines.

Nice-to-haves

• Experience with data visualization tools (e.g., Tableau, Power BI) is a plus.
• Familiarity with agile methodologies and DevOps practices.

Benefits

• Health insurance
• Dental insurance
• Vision insurance
• Vacation
• Holidays
• Floating holidays
• Retirement
• Baby bonding leave