Data Warehousing Architect

Data WarehousingArchitect

Reports To: Director of Business Intelligence Engineering

Department: Business Intelligence Engineering

Location: Mexico - Remote

About Us

Partner.Cois a global health and wellness company that partners with independent Brand Partners to help people achieve a body, business, and lifestyle they love.

ThroughourPartnership Marketingprocess, we provide Brand Partners with everything they need to build their business,and we provide our customerswithhigh-demand products in the wellness, fitness, skincare, and personal care spaces.

Check out the links below to learn more aboutus! 

• Our Story 

• Our Values & Community 

• Leadership 

• Clinical Studies 

Our Culture

Partner.Cois 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 wherehard workis balanced with fun, andeveryteam member'scontributions arevalued. 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, andamazingproducts to help you achieve your personal wellness goals. Plus,you'llhave 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 platformsand frameworksincluding Snowflake anddbt, ensuring alignment with business needs and scalability goals.

• Own the design and evolution of the cloud data warehouse(e.g.Snowflake, Oracle DatabaseMigrationServices).Maintain the currentoperationalOracledata warehouse through the evolution process.

• Implement and manage toolsfor scalable ELT transformations(e.g.dbt).Maintain the currentoperationalOracle PL/SQLETL process through the transition.

• Evaluate and implement real-time data ingestion and advanced processing tools (e.g.Snowpipe, Snowpark, AmazonSagemakerCanvas) as part of the modernization roadmap.

• Ensure data models areoptimizedfor performance, scalability, and business relevance.

Operational Process Support

• Collaborate with teams in productmanagement,operations,inventory, pricing, purchasing,compensation,sales,and finance to:

• Understand evolving business processes.

• Ensure data structures supportaccurate, near real-time insights.

• Provide analytical support for process refinement and automation.

Industry-Specific Enablement

• Support the Director of Business AnalyticsandDirector of Business Intelligence Engineering in evaluating field-facing and product promotions.Supportthe business analytics teams in executing internaldataanalysis projects by providingtimelyandaccuratedata.

• Build data structures to analyze:

• Salestrends

• Enrollment and retention trends

• Compensationtrends, costs, and patterns

• Payout accuracy

• Purchase and compensation fraud detectionand management

• Effectiveness of promotional strategies

• Field-leaderstructures 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 oftheDW 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 dataarchitecturesfor real-time analytics

• Supporting operational and industry-specific processes through data

• Excellent communication skills in English