Data Warehousing Architect

Data Warehousing Architect  Reports To: Director of Business Intelligence Engineering  Department: Business Intelligence Engineering  Location: Mexico - Remote About Us  Partner.Co is a global health and wellness company that partners with independent Brand Partners to help people achieve a body, business, and lifestyle they love.   Through our Partnership Marketing process, we provide Brand Partners with everything they need to build their business, and we provide our customers with high-demand products in the wellness, fitness, skincare, and personal care spaces.   Check out the links below to learn more about us!   https://partner.co/en-us/our-story   https://partner.co/en-us/community   https://partner.co/en-us/leadership   https://blog.partner.co/category/wellness/clinical-studies/   Our Culture  Partner.Co is a dynamic company with offices around the globe. Our international presence enables our corporate staff to engage with diverse cultures as we collaborate and thrive as one high-performing, energetic team.   We foster a collaborative culture where hard work is balanced with fun, and every team member's contributions are valued. Your impact matters, and we encourage all ideas!  We are passionate about health and wellness! As a member of our team, you can receive guidance, support, and amazing products to help you achieve your personal wellness goals. Plus, you'll have a community of friends cheering you on every step of the way! The Opportunity  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  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.  Evaluate and implement real-time data ingestion and advanced processing tools (e.g. Snowpipe, Snowpark, Amazon Sagemaker Canvas) as part of the modernization roadmap.  Ensure data models are optimized for performance, scalability, and business relevance.  Operational Process Support  Collaborate with teams in product management, operations, inventory, pricing, purchasing, compensation, sales, and finance to:  Understand evolving business processes.  Ensure data structures support accurate, near real-time insights.  Provide analytical support for process refinement and automation.  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.  Build data structures to analyze:  Sales trends  Enrollment and retention trends  Compensation trends, costs, and patterns  Payout accuracy   Purchase and compensation fraud detection and management  Effectiveness of promotional strategies  Field-leader structures and performance  Operationalize business analysis into repeatable, scalable reporting frameworks.  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.  Collaboration  Collaborate with product, analytics, and IT teams to align data initiatives with business goals.  Communicate effectively with executive stakeholders and translate technical concepts into business value.    Preferred Experience:  Leading data platform migrations or greenfield implementations  Experience with Snowflake, dbt, and Tableau Cloud  Designing scalable data architectures for real-time analytics  Supporting operational and industry-specific processes through data  Excellent communication skills in English Locations: Mexico - Remote