Enterprise Data Warehouse Architect

Robert Half
San Diego, United States of America
14 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

San Diego, United States of America

Tech stack

Airflow
Google BigQuery
Data Architecture
Data Governance
Data Infrastructure
ETL
Data Systems
Data Warehousing
Dimensional Modeling
Metadata
Power BI
Tableau
Talend
Azure
Snowflake
Data Layers
Kubernetes
Azure
Looker Analytics
Data Pipelines
Redshift
Databricks

Job description

We are seeking an experienced Enterprise Data Warehouse (EDW) Architect to lead the design, evaluation, and implementation of a modern analytics and reporting platform. This role will be responsible for defining the end-to-end data architecture, selecting appropriate technologies, and ensuring scalable, governed, and business-aligned data solutions across multiple subject areas.

The EDW Architect will partner closely with business stakeholders and technical teams to translate business requirements into a sustainable enterprise data warehouse and BI ecosystem., * Evaluate and recommend data warehousing platforms (e.g., Snowflake, Databricks, BigQuery, Redshift, Azure Synapse)

  • Select and design ETL/ELT solutions and orchestration frameworks (e.g., dbt, Fivetran, ADF, Informatica, Talend)
  • Design dimensional data models, including star and snowflake schemas, aligned to business use cases
  • Lead subject area modeling and architecture across Supply Chain, Sales, Finance, HR, and Procurement
  • Define BI-layer architecture and reporting standards using tools such as Power BI, Tableau, or Looker
  • Establish data governance, lineage, metadata, and data quality frameworks
  • Produce architecture documentation, implementation roadmaps, and conduct knowledge transfer and handover to delivery teams

Requirements

  • 10+ years of experience in enterprise data warehousing and analytics architecture
  • Proven experience implementing modern data platforms such as Snowflake, Databricks, or Azure Synapse
  • Deep expertise in dimensional modeling methodologies (Kimball and/or Inmon)
  • Strong background designing and orchestrating ETL/ELT pipelines using tools such as dbt, Airflow, or Azure Data Factory
  • Hands-on experience with BI semantic layers and enterprise reporting frameworks (Power BI, Tableau, Looker)
  • Experience designing data governance, data quality, and lineage solutions
  • Excellent communication skills with the ability to translate business requirements into technical architecture

Nice to Have

  • Experience with cloud-native analytics architectures
  • Prior involvement in enterprise data modernization initiatives
  • Consulting or advisory experience delivering architecture strategies and roadmaps Technology Doesn't Change the World, People Do.®

About the company

Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.

Apply for this position