Data Warehouse Architect Jobs
Data Warehouse Architect jobs are open across financial services, healthcare, retail, and technology, from mid-level to principal and staff engineer, with specializations in cloud data platforms, ETL pipeline design, and dimensional modeling. See the openings below and apply to the ones that match your experience.
Find Data Warehouse Architect JobsOverview
Showing 5 of 9+ Data Warehouse Architect jobs
Job Description:
Position Summary:
The Data Warehouse Architect and Technology Innovation Engineer is responsible for identifying customer and organizational data needs, managing and implementing data procedures and standards, designing and developing databases and data models, distributing management practices for data, and managing information. The position will also work with the IT department and operational leaders to innovate, assess and test new technologies to the pursuit of our mission to Lead the Field of Aging. The Data Warehouse Architect designs, develops and optimizes data warehouses, with flexible and scalable data and architecture, to support business users and business intelligence (BI) applications. Daily tasks include ensuring that all data going through the system is accurate and appropriately protected and encrypted, analyzing data and presenting reports to executives, and working as a liaison between IT and other departments. Will work closely with members of the Applications, Technology Operations and IT Security group to assess and implement innovative technologies.
Core Competencies:
- Ability to identify and understand customer requirements and then design / develop solutions that successfully address those requirements
- Keep current on new industry trends and developing technologies
- Ability to liaise with Operational Leaders to analyze challenges and propose technological solutions
- Strong business and leadership acumen
- In-depth knowledge of data warehousing concepts
- Strong understanding of database design, structure and operational use
- Mastery of database query and reporting tools. Able to structure queries to pull data and accurately combine the results in a logical, meaningful and efficient manner. Able to interpret the results.
- Strong understanding of data ingestion and transformation (ETL/ELT) techniques.
- Proficiency with analytics/dashboarding/presentation tools
- Ability to strictly abide by patient and employee confidentiality policies, procedures and regulations.
- Familiarity and adherence to IT and HIPAA Security regulations
- Ability to balance workload and adjust to shifting priorities
- Able to work well in a team atmosphere.
- Excellent organization skills Excellent interpersonal and communication skills
Responsibilities/Accountability:
- Identifies data requirements by interviewing customers; analyzing department applications, programming, and operations; evaluating existing systems and designing proposed systems.
- Identifies sources of data that can be used to populate the data warehouse
- Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
- Installs revised or new systems by proposing specifications and flowcharts; recommending optimum access techniques; coordinating installation requirements.
- Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
- Prepares users by conducting training; providing information; resolving problems.
- Provides information by answering questions and requests.
- Maintains quality service by establishing and enforcing organization standards.
- Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.
- Documents and maintains detailed knowledge of the data within the HSL environment, including sources, schemas, transformations, refresh cadence and data lineage, so that internal staff can support and troubleshoot independently of third party vendors.
- Contributes to team effort by accomplishing related results as needed.
- Performs a variety of tasks and a wide degree of creativity and latitude is expected
- Provides exceptional customer service. Completes projects accurately and on a timely basis.
Qualifications:
Required:
- Bachelor’s degree in Information Technology, Healthcare Informatics, Public Health or a related field. Equivalent of 10 years of relevant work experience may be considered in lieu of a degree.
- Five or more years of related work experience, including experience designing and developing in a data warehouse environment.
- Experience with electronic health record, health information systems and healthcare applications.
- Requires exceptional customer service skills, attention to detail and timeliness
- Experience with scripting languages such as PowerShell and Python for automation and data pipeline work.
- Hands-on experience with Databricks (Spark, Delta Lake, notebooks, Workflows, and Unity Catalog or similar governance tooling).
- Advanced proficiency in SQL and in database query, reporting, and BI tools.
- Working knowledge of Linux environments, with experience migrating Linux-based systems and workloads to standard, supported platforms.
- Expertise in: database performance tuning, database security, promoting process improvement, problem solving, presenting technical information, quality focus, database management, data maintenance, operating systems, attention to detail, information security policies
- Preferred:
- Workday Pro certification (Reporting, Integrations, or similar) or equivalent demonstrated experience.
- Experience with Workday Prism Analytics.
- Experience with retrieval-augmented generation (RAG), vector databases, and open-source LLM frameworks (e.g., Lang Chain, Llama Index) in a secure, on-premises environment.
- Databricks certification (Data Engineer Associate/Professional or similar).
- Experience with cloud platforms (e.g., Azure, AWS) and modern data orchestration tools (e.g., Airflow, Azure Data Factory).
- Familiarity with creating and structuring data cubes and web-based reporting and deployment.
- Experience with Microsoft SQL Server Reporting Services (SSRS), Power BI, or Crystal Reports.
- Familiarity with medical center/hospital and senior care activities and operations.
- Familiarity with Process Improvement and Lean methodologies, strong project management skills.
- Requirements
- Ability to travel to HSL local facilities.
- Ability to lift light computer equipment.
- Familiarity with Process Improvement and Lean methodologies
Remote Type:
HybridSalary Range:
$113,141.00 - $169,711.00Job Description:
Position Summary:
The Data Warehouse Architect and Technology Innovation Engineer is responsible for identifying customer and organizational data needs, managing and implementing data procedures and standards, designing and developing databases and data models, distributing management practices for data, and managing information. The position will also work with the IT department and operational leaders to innovate, assess and test new technologies to the pursuit of our mission to Lead the Field of Aging. The Data Warehouse Architect designs, develops and optimizes data warehouses, with flexible and scalable data and architecture, to support business users and business intelligence (BI) applications. Daily tasks include ensuring that all data going through the system is accurate and appropriately protected and encrypted, analyzing data and presenting reports to executives, and working as a liaison between IT and other departments. Will work closely with members of the Applications, Technology Operations and IT Security group to assess and implement innovative technologies.
Core Competencies:
- Ability to identify and understand customer requirements and then design / develop solutions that successfully address those requirements
- Keep current on new industry trends and developing technologies
- Ability to liaise with Operational Leaders to analyze challenges and propose technological solutions
- Strong business and leadership acumen
- In-depth knowledge of data warehousing concepts
- Strong understanding of database design, structure and operational use
- Mastery of database query and reporting tools. Able to structure queries to pull data and accurately combine the results in a logical, meaningful and efficient manner. Able to interpret the results.
- Strong understanding of data ingestion and transformation (ETL/ELT) techniques.
- Proficiency with analytics/dashboarding/presentation tools
- Ability to strictly abide by patient and employee confidentiality policies, procedures and regulations.
- Familiarity and adherence to IT and HIPAA Security regulations
- Ability to balance workload and adjust to shifting priorities
- Able to work well in a team atmosphere.
- Excellent organization skills Excellent interpersonal and communication skills
Responsibilities/Accountability:
- Identifies data requirements by interviewing customers; analyzing department applications, programming, and operations; evaluating existing systems and designing proposed systems.
- Identifies sources of data that can be used to populate the data warehouse
- Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
- Installs revised or new systems by proposing specifications and flowcharts; recommending optimum access techniques; coordinating installation requirements.
- Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
- Prepares users by conducting training; providing information; resolving problems.
- Provides information by answering questions and requests.
- Maintains quality service by establishing and enforcing organization standards.
- Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.
- Documents and maintains detailed knowledge of the data within the HSL environment, including sources, schemas, transformations, refresh cadence and data lineage, so that internal staff can support and troubleshoot independently of third party vendors.
- Contributes to team effort by accomplishing related results as needed.
- Performs a variety of tasks and a wide degree of creativity and latitude is expected
- Provides exceptional customer service. Completes projects accurately and on a timely basis.
Qualifications:
Required:
- Bachelor’s degree in Information Technology, Healthcare Informatics, Public Health or a related field. Equivalent of 10 years of relevant work experience may be considered in lieu of a degree.
- Five or more years of related work experience, including experience designing and developing in a data warehouse environment.
- Experience with electronic health record, health information systems and healthcare applications.
- Requires exceptional customer service skills, attention to detail and timeliness
- Experience with scripting languages such as PowerShell and Python for automation and data pipeline work.
- Hands-on experience with Databricks (Spark, Delta Lake, notebooks, Workflows, and Unity Catalog or similar governance tooling).
- Advanced proficiency in SQL and in database query, reporting, and BI tools.
- Working knowledge of Linux environments, with experience migrating Linux-based systems and workloads to standard, supported platforms.
- Expertise in: database performance tuning, database security, promoting process improvement, problem solving, presenting technical information, quality focus, database management, data maintenance, operating systems, attention to detail, information security policies
- Preferred:
- Workday Pro certification (Reporting, Integrations, or similar) or equivalent demonstrated experience.
- Experience with Workday Prism Analytics.
- Experience with retrieval-augmented generation (RAG), vector databases, and open-source LLM frameworks (e.g., Lang Chain, Llama Index) in a secure, on-premises environment.
- Databricks certification (Data Engineer Associate/Professional or similar).
- Experience with cloud platforms (e.g., Azure, AWS) and modern data orchestration tools (e.g., Airflow, Azure Data Factory).
- Familiarity with creating and structuring data cubes and web-based reporting and deployment.
- Experience with Microsoft SQL Server Reporting Services (SSRS), Power BI, or Crystal Reports.
- Familiarity with medical center/hospital and senior care activities and operations.
- Familiarity with Process Improvement and Lean methodologies, strong project management skills.
- Requirements
- Ability to travel to HSL local facilities.
- Ability to lift light computer equipment.
- Familiarity with Process Improvement and Lean methodologies
Remote Type:
HybridSalary Range:
$113,141.00 - $169,711.00Data Warehouse Architect Jobs by Experience Level
See All 9 Data Warehouse Architect Jobs
Find roles that match your experience and apply in just a few clicks.
Find Data Warehouse Architect JobsData Warehouse Architect Job Market
Who's Hiring
Top Industries Hiring
- Insurance
What Employers Look For
The qualifications that appear most often in data warehouse architect jobs.
- Five or more years of experience designing and implementing enterprise data warehouses
- Hands-on proficiency with at least one cloud data platform such as Snowflake, BigQuery, or Redshift
- Strong knowledge of dimensional modeling techniques including star and snowflake schemas
- Experience with ETL or ELT pipeline development using tools like dbt, Informatica, or similar
- Proficiency in SQL and the ability to optimize complex analytical queries at scale
- Bachelor's degree in computer science, information systems, or a related technical field
Tips for Your Data Warehouse Architect Job Search
Tailor your resume to the stack
Hiring managers scan for specific platform names before they read anything else. Align your resume to whichever cloud warehouse the job posting names, whether that's Snowflake, BigQuery, or Redshift, and move those terms to your summary and first bullet under each relevant role.
Quantify schema design outcomes
Generic phrases like 'designed data models' won't differentiate you. Describe the scale instead: row counts, number of source systems integrated, or query performance improvements after a redesign. Hiring managers for architect roles want to see that your decisions had measurable downstream impact.
Apply early to roles that fit
Migrate Mate lists data warehouse architect openings from across the United States in one place, so you can find roles that match and apply directly to each listing.
Filter postings by your modeling methodology
Job descriptions that mention Kimball, Inmon, or Data Vault signal very different team cultures and design philosophies. Targeting postings that name an approach you've used means your portfolio examples will map directly to what interviewers want to see, making every conversation more concrete.
Prepare a whiteboard modeling walkthrough
Most data warehouse architect interviews include a live schema design exercise. Practice walking through a star schema or vault structure out loud, narrating your normalization tradeoffs and grain decisions as you go. Interviewers care as much about your reasoning process as the final design.
Negotiate scope alongside compensation
Data warehouse architect roles vary enormously in whether you own end-to-end architecture or just model a single domain. Before accepting an offer, clarify which source systems you'll own, whether you'll have influence over ingestion tooling, and how many engineers will implement your designs.
Data Warehouse Architect Jobs: Frequently Asked Questions
Which companies are hiring the most data warehouse architects?
The companies hiring the most data warehouse architects right now include American business solutions, Optum, and Virtru, with the largest share of openings in Michigan, Oregon, and Texas, based on current listings on Migrate Mate as of November 2026. Demand is especially concentrated in financial services, healthcare systems, and large-scale retail and technology organizations.
How many data warehouse architect jobs are remote?
About 100% of data warehouse architect openings are fully remote or hybrid as of November 2026, reflecting the platform-agnostic nature of modern cloud data work. Roles focused on Snowflake, BigQuery, and dbt-based architectures tend to have the highest remote availability, while positions that require hands-on coordination with on-premises legacy systems more often require some on-site presence.
How do you become a data warehouse architect?
Most data warehouse architects start as data engineers, analytics engineers, or BI developers and gradually take on schema ownership and architecture decisions. Building depth in dimensional modeling, earning a cloud platform certification, and leading a full warehouse migration or rebuild on a team are the transitions that typically move candidates into architect-level roles. Reviewing the O*NET profile for this occupation gives a clear picture of the core competencies employers expect.
Can you get hired as a data warehouse architect without direct architect experience?
Yes, candidates who have owned end-to-end data model design in a senior engineering or analytics role often get hired as data warehouse architects without the explicit title. The clearest path is demonstrating that you made architectural decisions, not just implemented someone else's designs. Document specific modeling choices you owned, the tradeoffs you evaluated, and the business questions your warehouse structures enabled. That evidence matters more to hiring managers than the job title on your resume.
What does the data warehouse architect interview process look like?
The process typically runs three to five rounds. An initial screen with a recruiter or hiring manager focuses on background and tool familiarity. A technical round covers SQL, query optimization, or a take-home data modeling exercise. A system design or whiteboard round asks you to design a schema or warehouse architecture from a business requirement. Final rounds usually involve conversations with cross-functional stakeholders such as data engineers, analytics leads, or engineering managers who will work directly with your designs.
Where can I find and apply to data warehouse architect jobs?
You can find and apply to data warehouse architect jobs on Migrate Mate, which lists current openings from across the United States. Search the listings to find roles that match your stack, seniority level, and preferred work arrangement, then apply directly to each one that fits.
See All 9 Data Warehouse Architect Jobs
Find roles that match your experience and apply in just a few clicks.
Find Data Warehouse Architect Jobs