Data Warehouse Architect
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.