Data Warehouse Architect
Summary
Hands-on data warehouse architect who designs and implements an enterprise data warehouse on Microsoft SQL Server — defining data models and star/snowflake schemas, building SSAS tabular models, and producing architecture documentation — while driving data governance and mentoring the data and analytics team.
Job Description:
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.