CrawlJobs Logo
Robert Half Logo Robert Half · IT - Software Development

Enterprise Data Warehouse Architect

United States, San Diego · Job Posted May 03, 2026
Apply Position
Job Link Share

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.

Job Responsibility

  • 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

What we offer

  • Medical, vision, dental, and life and disability insurance
  • 401(k) plan
Robert Half - All Job Offers

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Suggested Tags: Frontend Developer Secretary Talent Manager Salesforce Administrator Data Analyst
Similar Jobs for

Enterprise Data Warehouse Architect

8 matching positions

Data Architect - Enterprise Data & AI Solutions

We are looking for a visionary Data Architect who can translate enterprise data ...
Location
Location
India , Chennai; Madurai; Coimbatore
Salary
Salary:
Not provided
optisolbusiness.com Logo
OptiSol Business Solutions
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong background in RDBMS design, data modeling, and schema optimization
  • Advanced SQL skills, including performance tuning and analytics functions
  • Proven expertise in data warehouses, data lakes, and lakehouse architectures
  • Proficiency in ETL/ELT tools (Informatica, Talend, dbt, Glue)
  • Hands-on with cloud platforms (AWS Redshift, Azure Synapse, GCP BigQuery, Snowflake)
  • Familiarity with GenAI frameworks (OpenAI, Vertex AI, Bedrock, Azure OpenAI)
  • Experience with real-time streaming (Kafka, Kinesis, Flink) and big data ecosystems (Hadoop, Spark)
  • Strong communication skills with the ability to present data insights to executives
  • 8+ years in data architecture, enterprise data strategy, or modernization programs
  • Hands-on with AI-driven analytics and GenAI adoption
Job Responsibility
Job Responsibility
  • Design scalable data models, warehouses, lakes, and lakehouse solutions
  • Build data pipelines to support advanced analytics, reporting, and predictive insights
  • Integrate GenAI frameworks to enhance data generation, automation, and summarization
  • Define and enforce enterprise-wide data governance, standards, and security practices
  • Drive data modernization initiatives, including cloud migrations
  • Collaborate with stakeholders, engineers, and AI/ML teams to align solutions with business goals
  • Enable real-time and batch insights through dashboards, AI-driven recommendations, and predictive reporting
  • Mentor teams on best practices in data and AI adoption
What we offer
What we offer
  • Opportunity to design next-generation enterprise data & AI architectures
  • Exposure to cutting-edge GenAI platforms to accelerate innovation
  • Collaborate with experts across cloud, data engineering, and AI practices
  • Access to learning, certifications, and leadership mentoring
  • Competitive pay with opportunities for career growth and leadership visibility
  • Fulltime
Read More
Arrow Right

Enterprise Data Architect

Robert Half's client in Surprise, Arizona is seeking an Enterprise/Lead Data Arc...
Location
Location
United States , Surprise
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 7+ years of experience in data architecture, data engineering, or enterprise architecture
  • Proven experience leading end-to-end data discovery and architecture design initiatives
  • Strong background in data modeling, system mapping, and enterprise data strategy
  • Hands-on experience with modern data platforms (e.g., Azure, AWS, GCP, Snowflake, Databricks, SQL Server)
  • Deep understanding of data governance frameworks and best practices
  • Experience working in regulated environments with HIPAA and PCI compliance requirements
  • Strong knowledge of data integration methodologies (ETL/ELT, APIs, middleware tools)
  • Ability to translate business needs into scalable technical architectures
Job Responsibility
Job Responsibility
  • Lead comprehensive discovery of the current data environment, including systems, data flows, and storage platforms
  • Assess existing architecture (data warehouses, lakes, operational systems, cloud/on-prem)
  • Identify gaps, inefficiencies, redundancies, and data silos
  • Evaluate current data quality, accessibility, and scalability
  • Define and design a long-term (5–10 year) data architecture roadmap aligned to business growth
  • Provide recommendations on where data should reside (data lake, warehouse, cloud platforms, etc.)
  • Design scalable, high-performance data solutions to support enterprise reporting, analytics, and future AI/ML initiatives
  • Advise on total data volume growth and infrastructure planning (full-scale/data capacity planning)
  • Map data flows across critical systems (ERP, CRM, HRIS, and other business applications)
  • Develop enterprise data models and architecture diagrams
What we offer
What we offer
  • Medical, vision, dental, and life and disability insurance
  • Company 401(k) plan
  • Free online training
  • Fulltime
Read More
Arrow Right

Enterprise Data Architect

Hermeus is a venture-backed defense aviation company reclaiming the lost art of ...
Location
Location
United States , Los Angeles; Atlanta
Salary
Salary:
142500.00 - 235750.00 USD / Year
hermeus.com Logo
Hermeus
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelors degree in Computer Science, Information Systems, Software engineering, or similar
  • 6+ years building and scaling enterprise data platforms
  • Deep SQL expertise (query optimization, indexing, execution plans, modeling discipline)
  • Experience designing ODS-style integration layers and dimensional warehouse architectures
  • Experience integrating multiple enterprise systems (ERP, HRIS, manufacturing, Engineering systems, SaaS platforms)
  • Strong understanding of canonical modeling and fact/dimension design
  • Experience implementing incremental load and change-detection strategies
  • Experience supporting enterprise BI platforms (Power BI or equivalent)
  • Ability to translate business complexity into scalable data structures
Job Responsibility
Job Responsibility
  • Define and evolve the enterprise data architecture across PLM, ERP, MES, HR, IT
  • Establish dimensional modeling standards (fact/dimension conventions) and canonical entity definitions
  • Design scalable integration patterns that support onboarding new systems without structural rework
  • Align operational and analytical models
  • Define and maintain canonical enterprise entities
  • Establish enterprise-wide naming conventions, data ownership standards, data definitions across systems and modeling governance
  • Partner with application owners to align upstream system design with downstream analytics needs
  • Strengthen ingestion reliability, monitoring, and change-detection patterns
  • Improve performance through indexing, partitioning, and workload optimization
  • Implement scalable incremental load strategies and reconciliation processes
What we offer
What we offer
  • 100% employer-paid health care
  • 401k & retirement plans
  • Unlimited PTO
  • Weekly paid office lunches
  • Fully stocked breakrooms
  • Stock options
  • Paid Parental Leave
  • Fulltime
Read More
Arrow Right

Enterprise Data Architect

Location
Location
United States , Los Angeles, CA / Atlanta, GA
Salary
Salary:
Not provided
hermeus.com Logo
Hermeus
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelors degree in Computer Science, Information Systems, Software engineering, or similar
  • 6+ years building and scaling enterprise data platforms
  • deep SQL expertise (query optimization, indexing, execution plans, modeling discipline)
  • experience designing ODS-style integration layers and dimensional warehouse architectures
  • experience integrating multiple enterprise systems (ERP, HRIS, manufacturing, Engineering systems, SaaS platforms)
  • strong understanding of canonical modeling and fact/dimension design
  • experience implementing incremental load and change-detection strategies
Read More
Arrow Right

Microsoft Fabric Data Warehouse Architect

We are seeking a highly experienced and pragmatic Microsoft Fabric Data Warehous...
Location
Location
United States
Salary
Salary:
Not provided
tier4group.com Logo
Tier4 Group
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in Computer Science, Engineering, or related field
  • 5+ years of experience in data architecture or cloud analytics with 2+ years hands-on with Microsoft Fabric
  • Experience designing and operating enterprise-scale Fabric environments
  • Strong expertise in Lakehouse, Data Warehouse, Data Integration, and Semantic Layer design
  • Experience with governance, security, DevOps, and cost optimization in Fabric
  • Strong understanding of medallion architecture and dimensional modeling
  • Proficiency in SQL, Python, and/or PySpark
  • Experience with Direct Lake semantic model optimization
  • Experience with data migration and modernization into Fabric
  • Strong understanding of data observability and reliability patterns
Job Responsibility
Job Responsibility
  • Own and evolve the enterprise data architecture strategy on Microsoft Fabric, including standards, patterns, and platform roadmap
  • Design and develop end-to-end analytics solutions including ingestion, transformation, storage, modeling, and reporting
  • Architect Lakehouse and Data Warehouse solutions leveraging OneLake, Delta Lake, and Fabric compute
  • Design robust ingestion patterns for Oracle Fusion Cloud BI Publisher extracts (CSV-based pipelines, automation, validation, and error handling)
  • Design solutions that scale across large, multi-domain environments with high data volumes and enterprise SLAs
  • Evaluate and make architectural tradeoffs across performance, cost, usability, and maintainability
  • Define and enforce governance standards including workspace design, naming conventions, data ownership, access patterns, and lifecycle management
  • Design and implement observability frameworks including monitoring, alerting, data quality validation, and SLA enforcement
  • Establish delivery frameworks including CI/CD pipelines, deployment pipelines, guardrails, and reusable accelerators
  • Lead implementation of medallion architecture patterns (Bronze/Silver/Gold)
Read More
Arrow Right

Enterprise Data Architect

A Data Architect designs and implements enterprise data management systems that ...
Location
Location
India , Pune
Salary
Salary:
Not provided
aptiv.com Logo
Aptiv plc
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Data Modeling: Expertise in conceptual, logical, and physical data modeling techniques
  • Database Technologies: Proficiency with relational databases, NoSQL solutions, data warehouses, and data lakes
  • Big Data Frameworks: Knowledge of Hadoop, Spark, Kafka, and other distributed processing systems
  • ETL/ELT Processes: Design and optimization of data integration pipelines
  • Data Governance: Implementing data quality, master data management, and metadata management
  • SQL & Query Optimization: Advanced SQL skills and performance tuning expertise
  • Cloud Data Platforms: Experience with AWS, Azure, or GCP data services
  • Data Security: Understanding of data protection, encryption, access controls, and compliance requirements
  • Data Strategy Development: Aligning data architecture with business objectives
  • Enterprise Architecture: Understanding how data architecture fits within broader enterprise systems
Job Responsibility
Job Responsibility
  • Design and implement comprehensive data architecture frameworks and data models
  • Develop data management strategies, governance policies, and quality standards
  • Create and maintain data dictionaries, taxonomies, and metadata repositories
  • Collaborate with stakeholders to understand business requirements and translate them into technical specifications
  • Establish data integration processes between disparate systems
  • Implement security measures to protect sensitive data
  • Evaluate and recommend appropriate data storage solutions (relational databases, data warehouses, data lakes)
  • Guide ETL processes and data pipeline development
  • Mentor data engineers and analysts on best practices
  • Fulltime
Read More
Arrow Right

Enterprise Data Architect

We are seeking a highly skilled and collaborative Data Architect to join our Ent...
Location
Location
United States , Columbus
Salary
Salary:
167000.00 - 184000.00 USD / Year
abercrombie.com Logo
Abercrombie & Fitch Co.
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in Computer Science or related field
  • advanced degree preferred, or combination of relevant skills and experience
  • 10+ years of experience in technical leadership within large-scale organizations (retail experience preferred)
  • Proven expertise in enterprise data architecture, ideally in cross-functional or federated environments
  • Strong understanding of data modeling, metadata management, and data integration
  • Experience with modern data platforms (Snowflake, Databricks), cloud providers (AWS, Azure, GCP), and streaming technologies (Kafka, Spark)
  • Practical experience designing production-ready cloud platforms and implementing AI/ML models at scale
  • Demonstrable experience with data governance tools, semantic models and frameworks
  • Excellent communication, stakeholder management, and change leadership skills
  • Ability to translate complex technical concepts into actionable business value
Job Responsibility
Job Responsibility
  • In partnership with Data Strategy teams, determine the business and technical capabilities needed to align strategies with execution
  • Own and author data capability maps aligned with business functions
  • Translate business needs into domain-aligned data models
  • Act as a Strategic Though Partner and Enabler of AI/ML initiatives
  • Advise business and technology leaders on AI-readiness of systems and platforms
  • Identify opportunities for data reuse, integration, and optimization
  • Champion the development of data products
  • Define data architecture and analytics capabilities to enable real-time visibility, predictive modeling, and data-driven decision-making
  • Leverage data to identify trends, risks, and opportunities
  • Serve as subject matter expert and a leader inside our AICoE and CCoE
What we offer
What we offer
  • Incentive bonus program
  • 401(K) savings plan with company match
  • Annual companywide review process
  • Flexible spending accounts
  • Medical, dental and vision insurance
  • Life and disability insurance
  • Associate assistance program
  • Paid parental and adoption leave
  • Access to fertility and adoption benefits through Carrot
  • Access to mental health and wellness app, Headspace
  • Fulltime
Read More
Arrow Right

Data Architect with Data Modelling

Role: Data Architect with Data Modelling. Location: Remote. FULL TIME ONLY.
Location
Location
United States
Salary
Salary:
Not provided
realign-llc.com Logo
Realign
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Excellent data modelling skills (Dimensional and 3NF)
  • Data modelling must have conceptual model showing core entities from CRM, e commerce, and finance systems, include relationships and grain for each table
  • Catalog federation or query federation
  • Must have implemented streaming (autoloader, CloudFiles, Spark Streaming, Event Hubs/Kafka)
  • Strong in Delta tables in Databricks
  • Extensive experience translating business requirements to data design requirements
  • Extensive data flow documentation experience
  • Azure experience - ADLS, Azure SQL
  • Snowflake or Databricks design experience
  • Excellent Communication skills for both technical and business communications
Job Responsibility
Job Responsibility
  • Excellent data modelling skills (Dimensional and 3NF)
  • Data modelling - must have created conceptual model showing core entities from CRM, e commerce, and finance systems, include relationships and grain for each table
  • Catalog federation or query federation
  • Must have implemented implement streaming (autoloader, CloudFiles, Spark Streaming, Event Hubs/Kafka)
  • Strong in Delta tables in Databricks
  • Extensive experience translating business requirements to data design requirements
  • Extensive data flow documentation experience
  • Azure experience - ADLS, Azure SQL
  • Snowflake or Databricks design experience
  • Excellent Communication skills for both technical and business communications
  • Fulltime
Read More
Arrow Right