Data Warehouse Architect (Hands-On, SQL Server, SSAS, Data Modeling)

We are looking for a hands-on Data Warehouse Architect to lead the design and implementation of our enterprise data warehouse solutions. The ideal candidate will be responsible for defining an enterprise data model, developing logical and physical schemas, creating comprehensive architecture and design documentation, and implementing tabular data models using Microsoft SQL Server and SQL Server Analysis Services (SSAS).

Key Responsibilities

• Define and maintain the enterprise data model, aligning it with business objectives and data strategy.
• Design and implement data warehouse schemas (star, snowflake) in Microsoft SQL Server, ensuring performance, scalability, and maintainability.
• Create and maintain architectural documentation, including data flow diagrams, data dictionary, 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.

Qualifications:

• 8+ years of experience in data warehousing, BI architecture, or enterprise data modeling.
• Proven hands-on experience with Microsoft SQL Server for data warehouse design and schema development.
• Experience with cloud data warehousing (e.g., Azure Synapse, Fabric, Snowflake).
• Strong proficiency with SSAS Tabular Models, DAX, and MDX.
• Expertise in creating enterprise data models, dimensional modeling (Kimball/Inmon), and schema design.
• Skilled in developing and maintaining architecture and design documentation.
• Strong SQL and performance tuning skills.
• Familiarity with ETL processes and tools (e.g., SSIS, Azure Data Factory).

Preferred:

• Knowledge of data governance, master data management, and data security practices.
• Experience with Power BI or other reporting tools integrated with SSAS tabular models.
• Experience with entity relationship diagramming tools (e.g., ER/Studio, Erwin)

Job Types: Full-time, Contract

Pay: $90.00 per hour

Application Question(s):

• The selected candidate must be willing to have a final face to face interview in Las Vegas. Travel cost will be reimbursed.
• Candidates MUST BE US citizens (no exceptions)

Experience:

• Related data warehouse: 8 years (Preferred)

Work Location: Remote