Data Warehouse Architect

Restaurant Supply Chain Solutions

Data Warehouse Architect

Louisville, KY
Full Time
Paid
  • Responsibilities

    Restaurant Supply Chain Solutions, LLC, a Yum! Brands Co-op, is currently seeking a Data Warehouse Architect, to join the Business Technology Team.

    Position Overview
    We are seeking a skilled Data Warehouse Architect to design and implement robust data warehousing solutions that meet our business needs. The ideal candidate will have extensive experience in data architecture, database design, and data integration strategies.

    Essential Functions
    • 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.
    • Other duties as assigned by management.

    Hybrid Schedule: 3 days in the office, 2 days remote

    Excellent benefits; medical, dental, vision, vacation, holidays, floating holidays, retirement, baby bonding leave and much more.

    Required Education, Experience and Skills
    • 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.

    Core Competencies
    • Attention to detail.
    • Problem identification and resolution
    • Process orientation.
    • Technical aptitude
    • Data analysis
    • Knowledge of data governance and data quality frameworks.
    • Familiarity with agile methodologies and DevOps practices.
    • Teamwork (cooperation and collaboration)
    • Excellent written and oral communication skills
    • Knowledge of Microsoft Office – Word, Excel, PowerPoint, Access, and Outlook
    • World Class Values

    Key Contacts/Interfaces
    • IT PMO
    • Cross-functional groups (Operations, Procurement, Product Supply, Accounting, and Finance)
    • Application Developers (Full-time and Contract)
    • Database Administrator
    • Reporting and Analytics Team

    Required Skills

    Required Experience