Data Warehouse Architect

SPECTRA TECH INC • North Las Vegas, NV

3d

About The Position

We are looking for a hands-on Data Warehouse Architect to lead the design and implementation of enterprise data warehouse solutions. The role is responsible for defining an enterprise data model, developing logical and physical schemas, creating architecture and design documentation, and implementing tabular data models using Microsoft SQL Server and SQL Server Analysis Services (SSAS). The architect collaborates with stakeholders and data and analytics teams, ensures data consistency and integrity, and provides technical leadership and mentorship.

Responsibilities

• Define and maintain the enterprise data model in alignment with business objectives and data strategy.
• Design and implement star and snowflake data warehouse schemas in Microsoft SQL Server, ensuring performance, scalability, and maintainability.
• Create and maintain architectural documentation, including data flow diagrams, data dictionaries, schema designs, and design patterns.
• Develop tabular models in SQL Server Analysis Services (SSAS) to support advanced analytics and reporting.
• Collaborate with stakeholders, BI developers, data engineers, and business analysts to gather requirements and translate them into data architecture designs.
• Ensure 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.
• Drive data architecture best practices, governance, and standards across the organization.
• Provide technical leadership and mentorship to the data and analytics team.

What This Job Offers

• Job Type: Full-time
• Education Level: No Education Listed