Data Warehousing Architect

Meet your recruiter Smita Aage

smita.aage@intellias.com

https://www.linkedin.com...

Vacancy details

Data Engineering

Data Architect

Architect

India

Remote

Apply now

Refer a friend now

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.

What project we have for you

Our client is global health and wellness collective operates as a unified platform formed by the merger of several industry-leading brands. Focused on a holistic approach to well-being, the company provides high-end nutritional supplements, weight management solutions, and clean beauty products backed by rigorous scientific standards.

What you will do

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. S*nowflake, 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.

What you need for this

Experience of leading data platform migrations or greenfield implementations
Experience with Snowflake, data build tool, and Tableau Cloud
Designing scalable data architectures for real-time analytics
Supporting operational and industry-specific processes through data
Excellent communication skills in English
Willingness to flex hours to provide overlap with the Business Intelligence Engineering team (GMT-7 time zone, 2-3 hours overlap per day)

What it’s like to work at Intellias

At Intellias, where technology takes center stage, people always come before processes. By creating a comfortable atmosphere in our team, we empower individuals to unlock their true potential and achieve extraordinary results. That’s why we offer a range of benefits that support your well-being and charge your professional growth.
We are committed to fostering equity, diversity, and inclusion as an equal opportunity employer. All applicants will be considered for employment without discrimination based on race, color, religion, age, gender, nationality, disability, sexual orientation, gender identity or expression, veteran status, or any other characteristic protected by applicable law.
We welcome and celebrate the uniqueness of every individual. Join Intellias for a career where your perspectives and contributions are vital to our shared success.