Cloud Data Warehouse Architect

Wakefern Food Corp. is the largest retailer-owned cooperative in the United States and supports its co-operative members' retail operations, trading under the ShopRite®, Price Rite®, The Fresh Grocer®, Dearborn Markets®, and Gourmet Garage® banners.

Employing an innovative approach to wholesale business services, Wakefern focuses on helping the independent retailer compete in a big business world. Providing the tools entrepreneurs need to stay a step ahead of the competition, Wakefern’s co-operative members benefit from the company’s extensive portfolio of services, including innovative technology, private label development, and best-in-class procurement practices.

Summary

The ideal candidate will have a strong background in designing, developing, and implementing complex projects, with a focus on cloud-based data warehousing and reporting solutions and driving efficiency within the organization. The role plays a pivotal role in defining data cloud architecture that requires close collaboration with application developers, data engineers, data analysts, data scientists, and BI developers to ensure seamless data integration and automation across various platforms. The Cloud Data Warehouse Architect is responsible for evaluating and selecting the most effective cloud technologies, data governance and compliance, and data warehouse process alignment with security best practices and industry regulations. The role demands passion for cutting-edge cloud solutions, performance optimization, and a proactive approach to troubleshooting complex data challenges in a fast-paced, highly collaborative environment. This role will enable organization to build scalable, cost-efficient systems that support advanced analytics, business intelligence, and machine learning use cases.

Essential Functions

• Participate in the development life cycle (requirements definition, project approval, design, development, and implementation) and maintenance of the systems.
• Define architecture standards and best practices for data warehousing and cloud infrastructure.
• Develop and manage backup strategies, disaster recovery plans, and failover mechanisms to ensure business continuity.
• Provide input for project plans and timelines to align with business objectives.
• Monitor project progress, identify risks, and implement mitigation strategies.
• Work with cross-functional teams and ensure effective communication and collaboration.
• Provide regular updates to the management team.
• Follow the standards and procedures according to Architecture Review Board best practices, revising standards and procedures as requirements change and technological advancements are incorporated into the >tech_ structure.
• Communicates and promotes the code of ethics and business conduct.
• Ensures completion of required company compliance training programs.
• Is trained – either through formal education or through experience – in software / hardware technologies and development methodologies.
• Stays current through personal development and professional and industry organizations.

Additional Functions

• Design scalable, secure, and efficient data warehouse solutions on cloud platforms such as Azure, Google Cloud, AWS.
• Implement robust security measures to ensure data privacy and comply with regulatory standards.
• Leverage cloud-native automation tools to streamline data management and reduce manual processes.
• Design, build, and maintain automated data pipelines and ETL/ELT processes, ensuring scalability and reliability in data operations.
• Design and implement data integration solutions to automate data flow between systems and databases.
• Designs and develops cloud automation solutions using various technologies, such as scripting languages, databases, APIs, and cloud services.
• Monitors and troubleshoots the cloud data warehouse solutions, resolving any issues or errors.
• Provides training and support to the end users of the cloud solutions.
• Maintain detailed architecture documentation and best practices for the organization’s data cloud infrastructure.
• Stay up-to-date with cloud technologies and data architecture trends to recommend and implement new tools and solutions.
• Understands cloud FinOps including chargeback and alert monitoring

Qualifications

• 5 years of experience in cloud data warehouse design, cloud computing, and data architecture.
• A bachelor's degree or higher in computer science, information systems, or a related field.
• Deep understanding of cloud-based data warehousing solutions (e.g., Azure Fabric, Google BigQuery, AWS etc.)
• Knowledge of data security, encryption, and compliance in cloud environments.
• Understanding of DevOps practices and cloud infrastructure automation (CI/CD, Teraforms)
• Strong knowledge and skills in data automation technologies, such as Python, SQL, ETL/ELT tools, Kafka, APIs, cloud data pipelines, etc.
• Experience with data modeling tools.
• Familiarity with BI visualization tools such as Looker, Tableau, Microstrategy, PowerBI, or similar.
• Strong knowledge and skills in data management, data quality, and data governance.
• Strong communication, collaboration, and problem-solving skills.
• Ability to work on multiple projects and prioritize tasks effectively.
• Ability to work independently and in a team environment.
• Ability to learn new technologies and tools quickly.
• The ability to handle stressful situations.
• Highly developed business acuity and acumen.
• Strong critical thinking and decision-making skills.

Working Conditions & Physical Demands

• This position requires in-person office presence at least 4x a week.