Description : Position Summary :
The Data Warehousing Architect leads the development of the data warehouse and the execution of data flows to integrate data from multiple sources. This role is responsible for architecting and optimizing the Snowflake data warehouse and ensuring data structures support strategic initiatives across inventory, pricing, purchasing, finance, and network marketing.
Core Competencies & Responsibilities :
1. Data Architecture & Engineering :
- Lead the evaluation, planning, and implementation of new data platforms and frameworks including Snowflake and dbt, ensuring alignment with business needs and scalability goals.
- Own the design and evolution of the cloud data warehouse (e.g. Snowflake, Oracle Database Migration Services). Maintain the current operational Oracle data warehouse through the evolution process.
- Implement and manage tools for scalable ELT transformations (e.g. dbt). Maintain the current operational Oracle PL / SQL ETL process through the transition.
2. Operational Process Support :
Collaborate with teams in product management, operations, inventory, pricing, purchasing, compensation, sales, and finance3. Industry-Specific Enablement :
Support the Director of Business Analytics and Director of Business Intelligence Engineering in evaluating field-facing and product promotions. Support the business analytics teams in executing internal data analysis projects by providing timely and accurate data.4. Governance, Quality & Compliance :
Establish and enforce data governance policies.Monitor data quality and implement cleansing strategies using predictive and prescriptive analytics.Ensure compliance with internal standards and external regulations.Lead development of the DW naming and governance standards.(ref : hirist.tech)