CrawlJobs Logo

Enterprise Data Warehouse Architect

https://www.roberthalf.com Logo

Robert Half

Location Icon

Location:
United States , San Diego

Category Icon
Category:
IT - Software Development

Job Type Icon

Contract Type:
Not provided

Salary Icon

Salary:

Not provided
Save Job
Save Icon
Apply Position

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

Additional Information:

Job Posted:
May 03, 2026

Employment Type:
Fulltime
Work Type:
On-site work
Icon
Robert Half - All Job Offers
Job Link Share:
Copy Link Icon
Facebook Icon Twitter Icon LinkedIn Icon

Looking for more opportunities? Search for other job offers that match your skills and interests.

Briefcase Icon

Similar Jobs for Enterprise Data Warehouse Architect

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

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

We are seeking a highly experienced Data Architect with 12+ years of experience ...
Location
Location
United Arab Emirates , Dubai
Salary
Salary:
Not provided
northbaysolutions.com Logo
NorthBay
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 12+ years of experience in Data Engineering and Data Architecture
  • Proven experience working as a Data Architect on large-scale AWS platforms
  • Strong experience designing enterprise data lakes and data warehouses
  • Hands-on experience with batch data processing and orchestration frameworks
  • Excellent communication and stakeholder management skills
  • Ability to work onsite in Dubai, UAE
  • AWS Glue (ETL, Data Catalog)
  • Amazon EMR (Batch Processing)
  • AWS Lambda (Serverless Data Processing)
  • Amazon MWAA (Apache Airflow)
Job Responsibility
Job Responsibility
  • Design and own end-to-end AWS data architecture for enterprise platforms
  • Define data architecture standards, best practices, and reference models
  • Architect batch and event-driven data pipelines using AWS native services
  • Lead data ingestion, transformation, and orchestration workflows
  • Design and implement solutions using AWS Glue, EMR, Lambda, and MWAA (Airflow)
  • Architect data lakes and data warehouses using Amazon S3 and Amazon Redshift
  • Design NoSQL data solutions using Amazon DynamoDB
  • Implement data governance, metadata management, and access control using AWS DataZone
  • Ensure monitoring, logging, and observability using Amazon CloudWatch
  • Partner with engineering, analytics, and business teams to translate requirements into scalable data solutions
  • Fulltime
Read More
Arrow Right

Senior Data Architect

We are seeking a highly experienced Senior Data Architect with 12+ years of expe...
Location
Location
United Arab Emirates , Dubai
Salary
Salary:
Not provided
northbaysolutions.com Logo
NorthBay
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 12+ years of experience in Data Engineering and Data Architecture
  • Proven experience working as a Data Architect on large-scale AWS platforms
  • Strong experience designing enterprise data lakes and data warehouses
  • Hands-on experience with batch data processing and orchestration frameworks
  • Excellent communication and stakeholder management skills
  • Ability to work onsite in Dubai, UAE
  • AWS Glue (ETL, Data Catalog)
  • Amazon EMR (Batch Processing)
  • AWS Lambda (Serverless Data Processing)
  • Amazon MWAA (Apache Airflow)
Job Responsibility
Job Responsibility
  • Design and own end-to-end AWS data architecture for enterprise platforms
  • Define data architecture standards, best practices, and reference models
  • Architect batch and event-driven data pipelines using AWS native services
  • Lead data ingestion, transformation, and orchestration workflows
  • Design and implement solutions using AWS Glue, EMR, Lambda, and MWAA (Airflow)
  • Architect data lakes and data warehouses using Amazon S3 and Amazon Redshift
  • Design NoSQL data solutions using Amazon DynamoDB
  • Implement data governance, metadata management, and access control using AWS DataZone
  • Ensure monitoring, logging, and observability using Amazon CloudWatch
  • Partner with engineering, analytics, and business teams to translate requirements into scalable data solutions
  • Fulltime
Read More
Arrow Right

Data Architect

We are seeking a highly skilled Data Architect to join our Enterprise Transforma...
Location
Location
Bulgaria , Sofia
Salary
Salary:
Not provided
hotschedules.com Logo
HotSchedules Corporate
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field
  • 5+ years in data architecture, database administration, or data engineering, with a focus on enterprise and business systems
  • Strong knowledge of SQL and NoSQL databases (e.g., PostgreSQL, MongoDB, Cassandra)
  • Experience with cloud platforms (e.g., AWS, Azure, GCP – BigQuery, Redshift, Snowflake)
  • Hands-on experience with ETL/ELT tools (e.g., Apache Airflow, dbt, Informatica, Talend, Azure Data Factory, Synapse)
  • Strong knowledge of API’s and Automation Tools (e.g. Make, Zapier, MS Power Automate)
  • Familiarity with ERP, CRM, and HRIS integrations
  • Programming skills in Python, Java, or Scala
  • Deep understanding of data governance, master data management, and security/compliance (especially GDPR)
  • Excellent analytical, problem-solving, and communication skills
Job Responsibility
Job Responsibility
  • Design, develop, and maintain the organization’s overall data architecture to support enterprise‑wide business applications, internal reporting, and analytics
  • Create and manage conceptual, logical, and physical data models for organizational data domains (HR, Finance, Sales, Operations, etc.)
  • Define and implement data governance policies, standards, and best practices across the enterprise
  • Oversee ETL/ELT processes and pipelines for integrating data from diverse business systems (ERP, CRM, HRIS, etc.)
  • Collaborate with internal stakeholders (business teams, IT, data engineers) to align data initiatives with organizational objectives
  • Optimize performance, cost, and scalability of data warehouses and internal reporting systems
  • Evaluate and recommend tools and platforms to enhance internal data and business application efficiency
  • Ensure compliance with GDPR and other relevant data security/privacy regulations
  • Responsible for the successful design and execution of Data related programs and projects
What we offer
What we offer
  • 25+ days off, as well as birthday day off and 4 charity days off per year
  • Flexible start and end of the working day and hybrid working mode, including a combination remote and in the office
  • Team-centric atmosphere
  • Encouraging healthy lifestyle and work-life balance including supplemental health insurance
  • New parents bonus scheme
  • Fulltime
Read More
Arrow Right

Data Architect

The Data Architect will help build our enterprise data warehouse with SQL Server...
Location
Location
United States , Brentwood
Salary
Salary:
Not provided
ardenthealth.com Logo
Ardent Health
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s Degree in Computer/Data Science, Information Systems, or a related field, or equivalent work experience
  • 5+ years of experience in data architecture, with a strong focus on building enterprise data warehouses and data integration
  • Expert experience in SQL Server on-prem
  • Experience designing PowerBI semantic models for multi-report support
  • Excellent communication and interpersonal skills, with the ability to interact effectively with stakeholders at all levels
  • Demonstrated ability to translate business requirements into technical specifications
  • Strong understanding of data modeling, data governance, and data quality best practices
  • Strong organizational skills and attention to detail
  • Ability to work independently and as part of a team in a fast-paced environment
  • Proven ability to manage multiple projects and priorities simultaneously
Job Responsibility
Job Responsibility
  • Develop and implement an enterprise data architecture strategy, ensuring alignment with business objectives
  • Design, build, and maintain PowerBI semantic models, datamarts, and data integration processes using Cloud & SQL Server on-prem solutions
  • Collaborate with stakeholders to gather and document data requirements, ensuring the architecture meets current and future business needs
  • Work with our new Data Governance team to design and implement data governance and data quality best practices for the EDW to ensure the integrity and reliability of data
  • Design and help develop the more complex ETL processes to support ETL/ELT from various data sources
  • Create and maintain technical documentation including data models, data flow diagrams, and data integration specifications
  • Provide guidance and support to development teams on data-related projects and initiatives
  • Monitor and optimize the performance of the data architecture, identifying and resolving issues as needed
  • Stay informed of industry best practices and emerging technologies in data architecture, quality, and analytics
  • Provide guidance to leadership and stakeholders on data-related tools and processes
  • Fulltime
Read More
Arrow Right

Data Architect

We are seeking a highly skilled and experienced Data Architect to join our team....
Location
Location
Poland , Warsaw
Salary
Salary:
Not provided
https://www.inetum.com Logo
Inetum
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6+ years of professional experience in data-centric roles
  • Proven experience in a technical leadership position such as Solution Architect, Technical Lead, or Principal Engineer
  • Expert-level knowledge of Snowflake and Azure Data Factory (ADF)
  • Deep experience with SQL Server
  • Familiarity with Informatica and IBM DB2
  • Hands-on experience with Control-M
  • Experience with SAP Business Objects and Power BI
  • Expert-level SQL
  • Proficiency in Python
  • Experience with XML and JSON data formats
Job Responsibility
Job Responsibility
  • Design and document end-to-end solutions for new data integrations, major enhancements, and complex data products
  • Contribute to the technical roadmap for the Enterprise Data Warehouse (EDW)
  • Define and enforce data engineering and development standards across the program
  • Serve as the final technical approver for all significant code changes, pull requests, and architectural modifications
  • Act as the highest point of technical escalation for critical P1/P2 incidents and complex problems
  • Lead technical investigation during major outages
  • Drive technical resolution for systemic issues
  • Mentor Data Engineers and Data Visualization Engineers
  • Champion creation and maintenance of technical documentation
  • Work closely with client architects and source system owners
What we offer
What we offer
  • Flexible working hours
  • Hybrid work model
  • Cafeteria system
  • Referral bonuses up to PLN6,000
  • Additional revenue sharing opportunities
  • Ongoing guidance from dedicated Team Manager
  • Tailored technical mentoring
  • Dedicated team-building budget
  • Opportunities to participate in charitable initiatives and local sports programs
  • Supportive and inclusive work culture
  • Fulltime
Read More
Arrow Right

Data Architect

We are seeking a highly skilled and experienced Data Architect to join our team....
Location
Location
Poland , Warsaw
Salary
Salary:
Not provided
https://www.inetum.com Logo
Inetum
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6+ years of professional experience in data-centric roles
  • Proven experience in a technical leadership position such as Solution Architect, Technical Lead, or Principal Engineer
  • Expert-level knowledge of Snowflake and Azure Data Factory (ADF)
  • Deep experience with SQL Server
  • Familiarity with Informatica and IBM DB2
  • Hands-on experience with Control-M
  • Experience with SAP Business Objects and Power BI
  • Expert-level SQL
  • Proficiency in Python
  • Experience with XML and JSON data formats
Job Responsibility
Job Responsibility
  • Design and document end-to-end solutions for new data integrations, major enhancements, and complex data products
  • Contribute to the technical roadmap for the Enterprise Data Warehouse (EDW)
  • Define and enforce data engineering and development standards across the program
  • Serve as the final technical approver for all significant code changes, pull requests, and architectural modifications
  • Act as the highest point of technical escalation for critical P1/P2 incidents and complex problems
  • Lead technical investigation during major outages
  • Drive technical resolution for systemic issues
  • Mentor Data Engineers and Data Visualization Engineers
  • Champion creation and maintenance of technical documentation
  • Work closely with client architects, source system owners, and other vendor teams
What we offer
What we offer
  • Flexible working hours
  • Hybrid work model
  • Cafeteria system
  • Referral bonuses up to PLN6,000
  • Additional revenue sharing opportunities
  • Ongoing guidance from dedicated Team Manager
  • Tailored technical mentoring
  • Dedicated team-building budget
  • Opportunities to participate in charitable initiatives and local sports programs
  • Supportive and inclusive work culture
  • Fulltime
Read More
Arrow Right