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 OverviewFusion 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.
Fusion HCR Staffing LLC is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected characteristic under applicable law.
The information contained in this job posting is for general informational purposes only. Fusion HCR Staffing reserves the right to modify, suspend, or discontinue any job posting at any time without notice. Employment is subject to satisfactory completion of background screening and other pre-employment requirements.