Back to jobs

Data Warehouse Architect

Pay
Pay not listedSimilar roles state $155K–$227K
Work setting
Remote — work setting source
Role: Data Warehouse Architect Location: Las Vegas, Nevada (preferred) Work Arrangement: Remote Employment Type: Full-time; current project duration is expected to be 3–9 months Industry: IT Services and IT Consulting The role is with an IT and management consulting provider whose work includes cybersecurity and helping organizations protect information assets, reduce operational risk, and improve performance. The organization delivers services through technical professionals with expertise across their fields. This hands-on architecture opportunity focuses on shaping enterprise data warehouse solutions, from data models and schemas through implementation and documentation. The position will work across business and technical teams to translate requirements into scalable, well-governed data architecture. Las Vegas-area candidates are preferred, though the role is remote. All applicants must be U.S. citizens; no exceptions. Position Overview
Listed location: Remote, United States
Read the full posting
Employment
Full-time — employment source
Fusion HCR is Hiring! Role: Data Warehouse Architect Location: Las Vegas, Nevada (preferred) Work Arrangement: Remote Employment Type: Full-time; current project duration is expected to be 3–9 months Industry: IT Services and IT Consulting The role is with an IT and management consulting provider whose work includes cybersecurity and helping organizations protect information assets, reduce operational risk, and improve performance. The organization delivers services through technical professionals with expertise across their fields. This hands-on architecture opportunity focuses on shaping enterprise data warehouse solutions, from data models and schemas through implementation and documentation. The position will work across business and technical teams to translate requirements into scalable, well-governed data architecture. Las Vegas-area candidates are preferred, though the role is remote. All applicants must be U.S. citizens; no exceptions.
Read the full posting

What you’ll work on

Full posting
  • Define and maintain the enterprise data model

  • Design and implement star and snowflake schemas in SQL Server

  • Develop SSAS tabular models for analytics and reporting

  • Create and maintain architecture documentation and data dictionaries

  • Turn business and technical requirements into data architecture designs

From the employer’s posting
Define and maintain the enterprise data model in alignment with business objectives and data strategy.
Design and implement star and snowflake schemas in Microsoft SQL Server, with attention to performance, scalability, and maintainability.
Develop tabular models in SSAS to support analytics and reporting.
Create and maintain architecture documentation, including data flow diagrams, data dictionaries, schema designs, and design patterns.
Gather requirements with business and technical stakeholders and translate them into data architecture designs.

Before you apply

Work authorization
US citizens onlyAll applicants must be US citizens

What you’ll bring

All qualifications

Core experience

  • 8+ years of experience in data warehousing, BI architecture, or enterprise data modeling.
  • Hands-on experience designing data warehouses and developing schemas in Microsoft SQL Server.
  • Strong proficiency with SSAS Tabular Models, DAX, and MDX.
  • Expertise in enterprise data modeling, dimensional modeling approaches such as Kimball or Inmon, and schema design.
  • Strong SQL skills, including performance tuning.
  • Experience creating and maintaining architecture and design documentation.
Qualification wording
8+ years of experience in data warehousing, BI architecture, or enterprise data modeling.
Hands-on experience designing data warehouses and developing schemas in Microsoft SQL Server.
Strong proficiency with SSAS Tabular Models, DAX, and MDX.
Expertise in enterprise data modeling, dimensional modeling approaches such as Kimball or Inmon, and schema design.
Strong SQL skills, including performance tuning.
Experience creating and maintaining architecture and design documentation.
Apply at Secured IT Solutions

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
4
Last seen by us
Nov 21, 2026
Employer says posted
Nov 5, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$155K–$227K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 3,272 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 8 and day 57.

From 9,995 similar postings that came down. Coming down is not always a hire.

Secured IT Solutions is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Azure
  • Snowflake
  • SQL Server
  • SSAS
  • SSIS
Where the posting names them
Position Overview Fusion HCR is seeking a hands-on Data Warehouse Architect to lead the design and implementation of enterprise data warehouse solutions. This role will define and maintain enterprise data models, develop logical and physical schemas, and implement tabular models using Microsoft SQL Server and SQL Server Analysis Services (SSAS). The architect will create and maintain design documentation, support data integrity across warehouse layers, and guide data modeling, metadata management, and data quality initiatives. Working closely with stakeholders, BI developers, data engineers, and business analysts, the architect will turn business needs into practical architecture designs. The role also provides technical leadership and mentorship while promoting consistent data architecture practices, governance, and standards. Key Responsibilities
- Define and maintain the enterprise data model in alignment with business objectives and data strategy. - Design and implement star and snowflake schemas in Microsoft SQL Server, with attention to performance, scalability, and maintainability. - Develop tabular models in SSAS to support analytics and reporting.
- 8+ years of experience in data warehousing, BI architecture, or enterprise data modeling. - Hands-on experience designing data warehouses and developing schemas in Microsoft SQL Server. - Strong proficiency with SSAS Tabular Models, DAX, and MDX.
- Expertise in enterprise data modeling, dimensional modeling approaches such as Kimball or Inmon, and schema design. - Strong SQL skills, including performance tuning. - Experience creating and maintaining architecture and design documentation.
- Experience creating and maintaining architecture and design documentation. - Familiarity with ETL processes and tools such as SSIS or Azure Data Factory. - Experience with cloud data warehousing, such as Azure Synapse, Fabric, or Snowflake.
- Familiarity with ETL processes and tools such as SSIS or Azure Data Factory. - Experience with cloud data warehousing, such as Azure Synapse, Fabric, or Snowflake. - U.S. citizenship is required; no exceptions.
- Design and implement star and snowflake schemas in Microsoft SQL Server, with attention to performance, scalability, and maintainability. - Develop tabular models in SSAS to support analytics and reporting. - Create and maintain architecture documentation, including data flow diagrams, data dictionaries, schema designs, and design patterns.
- Hands-on experience designing data warehouses and developing schemas in Microsoft SQL Server. - Strong proficiency with SSAS Tabular Models, DAX, and MDX. - Expertise in enterprise data modeling, dimensional modeling approaches such as Kimball or Inmon, and schema design.

Your next step

Complete your application on fusionhcr.catsone.com. The employer’s form will show what is required.

Already applied? Track this application

Job description

View original posting ↗

Fusion HCR is Hiring!

Role: Data Warehouse Architect
Location: Las Vegas, Nevada (preferred)
Work Arrangement: Remote
Employment Type: Full-time; current project duration is expected to be 3–9 months
Industry: IT Services and IT Consulting

The role is with an IT and management consulting provider whose work includes cybersecurity and helping organizations protect information assets, reduce operational risk, and improve performance. The organization delivers services through technical professionals with expertise across their fields. This hands-on architecture opportunity focuses on shaping enterprise data warehouse solutions, from data models and schemas through implementation and documentation. The position will work across business and technical teams to translate requirements into scalable, well-governed data architecture. Las Vegas-area candidates are preferred, though the role is remote. All applicants must be U.S. citizens; no exceptions.

Position Overview

Fusion HCR is seeking a hands-on Data Warehouse Architect to lead the design and implementation of enterprise data warehouse solutions. This role will define and maintain enterprise data models, develop logical and physical schemas, and implement tabular models using Microsoft SQL Server and SQL Server Analysis Services (SSAS). The architect will create and maintain design documentation, support data integrity across warehouse layers, and guide data modeling, metadata management, and data quality initiatives. Working closely with stakeholders, BI developers, data engineers, and business analysts, the architect will turn business needs into practical architecture designs. The role also provides technical leadership and mentorship while promoting consistent data architecture practices, governance, and standards.

Key Responsibilities

  • Define and maintain the enterprise data model in alignment with business objectives and data strategy.

  • Design and implement star and snowflake schemas in Microsoft SQL Server, with attention to performance, scalability, and maintainability.

  • Develop tabular models in SSAS to support analytics and reporting.

  • Create and maintain architecture documentation, including data flow diagrams, data dictionaries, schema designs, and design patterns.

  • Gather requirements with business and technical stakeholders and translate them into data architecture designs.

  • Support consistency and data integrity across source systems, staging layers, data marts, and reporting layers.

  • Lead and participate in data modeling, metadata management, and data quality initiatives.

  • Advance data architecture best practices, governance, and standards; provide technical leadership and mentorship to the data and analytics team.

Required Qualifications

  • 8+ years of experience in data warehousing, BI architecture, or enterprise data modeling.

  • Hands-on experience designing data warehouses and developing schemas in Microsoft SQL Server.

  • Strong proficiency with SSAS Tabular Models, DAX, and MDX.

  • Expertise in enterprise data modeling, dimensional modeling approaches such as Kimball or Inmon, and schema design.

  • Strong SQL skills, including performance tuning.

  • Experience creating and maintaining architecture and design documentation.

  • Familiarity with ETL processes and tools such as SSIS or Azure Data Factory.

  • Experience with cloud data warehousing, such as Azure Synapse, Fabric, or Snowflake.

  • U.S. citizenship is required; no exceptions.

Why Join Us

  • Work on the design and implementation of enterprise data warehouse solutions.

  • Collaborate with stakeholders and cross-functional business intelligence, data engineering, and analytics teams.

  • Contribute to data architecture, governance, modeling, and data quality practices.

  • Provide technical leadership and mentorship within a data and analytics team.

Demand for Data Leadership roles

New Data Leadership postings at the employers we follow are up 8% over the last 6 weeks compared with the 6 before.

Weekly new Data Leadership postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 751, the most 1,165, and the latest week had 775.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Leadership, by the work the posting describes.

Data leaders run data teams or design how a company's data fits together. Managers hire, set priorities and answer for whether the data work pays off; architects choose the systems and the shape of the data.

Expect years of hands-on data work, experience leading people or projects, and the ability to explain tradeoffs to executives.

Unlike a senior engineer or analyst, most of a data leader's week goes to people, planning and decisions rather than building.

US government figures for computer and information systems managers

Median yearly pay, May 2025
$175,140
Expected change, 2025 to 2035
15.8% more jobsagainst 3.5% for all jobs

The government has no code for data leaders, so these figures are for the closest group, computer and information systems managers, which includes data processing and data operations managers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 11-3021.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Remote, United States

Fusion HCR is Hiring! Role: Data Warehouse Architect Location: Las Vegas, Nevada (preferred) Work Arrangement: Remote Employment Type: Full-time; current project duration is expected to be 3–9 months Industry: IT Services and IT Consulting The role is with an IT and management consulting provider whose work includes cybersecurity and helping organizations protect information assets, reduce operational risk, and improve performance. The organization delivers services through technical professionals with expertise across their fields. This hands-on architecture opportunity focuses on shaping enterprise data warehouse solutions, from data models and schemas through implementation and documentation. The position will work across business and technical teams to translate requirements into scalable, well-governed data architecture. Las Vegas-area candidates are preferred, though the role is remote. All applicants must be U.S. citizens; no exceptions. Position Overview
Work authorization
Role: Data Warehouse Architect Location: Las Vegas, Nevada (preferred) Work Arrangement: Remote Employment Type: Full-time; current project duration is expected to be 3–9 months Industry: IT Services and IT Consulting The role is with an IT and management consulting provider whose work includes cybersecurity and helping organizations protect information assets, reduce operational risk, and improve performance. The organization delivers services through technical professionals with expertise across their fields. This hands-on architecture opportunity focuses on shaping enterprise data warehouse solutions, from data models and schemas through implementation and documentation. The position will work across business and technical teams to translate requirements into scalable, well-governed data architecture. Las Vegas-area candidates are preferred, though the role is remote. All applicants must be U.S. citizens; no exceptions. Position Overview
More source context
- Experience with cloud data warehousing, such as Azure Synapse, Fabric, or Snowflake. - U.S. citizenship is required; no exceptions. Why Join Us

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.