Data Warehouse Architect

Fusion HCR; Las Vegas (NV); Remote; USD 95,000 - 130,000; Full time

Job summary

An innovative firm is seeking a skilled Data Warehouse Architect to lead the design and implementation of enterprise data solutions. This remote contract position involves defining data models, developing schemas, and building tabular models using advanced technologies. The role requires collaboration with stakeholders to ensure data integrity and consistency, while also promoting best practices in data architecture. If you have a passion for data and a proven track record in data warehousing and BI architecture, this opportunity offers a chance to make a significant impact in a dynamic environment.

Qualifications

• 8+ years in data warehousing, BI architecture, or data modeling.
• Proven SQL Server experience with schema and warehouse design.
• Strong SSAS Tabular, DAX, and MDX skills.

Responsibilities

• Define and maintain enterprise data models aligned with business goals.
• Design and implement star/snowflake schemas in Microsoft SQL Server.
• Build SSAS Tabular Models for analytics and reporting.

Skills

Data Warehousing

SQL Server

SSAS Tabular

DAX

MDX

Cloud Data Platforms

Dimensional Modeling

SQL Tuning

ETL Tools

Tools

Microsoft SQL Server

SSAS

Azure Synapse

Snowflake

SSIS

Azure Data Factory

Power BI

Job description

Fusion HCR is hiring! Remote Contract – Data Warehouse Architect for our Federal Government client. This position requires US Citizenship. No third parties accepted.

We’re seeking a hands-on Data Warehouse Architect to lead the design and implementation of enterprise data warehouse solutions. This role involves defining enterprise data models, developing schemas, documenting architecture, and building tabular models using Microsoft SQL Server and SSAS.
Key Responsibilities

• Define and maintain enterprise data models aligned with business goals.
• Design and implement star/snowflake schemas in Microsoft SQL Server.
• Create and maintain architecture documentation (diagrams, data dictionary, design patterns).
• Build SSAS Tabular Models for analytics and reporting.
• Collaborate with stakeholders to translate requirements into data architecture.
• Ensure consistency and integrity across all data layers.
• Lead data modeling, metadata, and data quality efforts.
• Promote data architecture standards and best practices.
• Provide technical leadership and mentorship.

Qualifications

• 8+ years in data warehousing, BI architecture, or data modeling.
• Proven SQL Server experience with schema and warehouse design.
• Strong SSAS Tabular, DAX, and MDX skills.
• Experience with cloud data platforms (Azure Synapse, Snowflake).
• Expertise in dimensional modeling (Kimball/Inmon).
• Skilled in SQL tuning, documentation, and schema design.
• Familiar with ETL tools like SSIS or Azure Data Factory.

Preferred

• Knowledge of data governance and security.
• Experience with Power BI or similar tools integrated with SSAS.