> Markdown version of [/jobs/ext/203728-data-warehouse-architect-hands-on-sql-server-ssas-data-modeling](https://www.wearedevelopers.com/jobs/ext/203728-data-warehouse-architect-hands-on-sql-server-ssas-data-modeling). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Warehouse Architect (Hands-On, SQL Server, SSAS, Data Modeling) - **Company:** SECURED IT SOLUTIONS, LLC - **Location:** United States (Remote available) - **Experience:** Expert - **Salary:** $176,800.0 - **Contract:** Permanent contract - **Skills:** Business Intelligence Development, Cloud Database, Data Architecture, Data Dictionary, Data Governance, Data Integrity, Extract Transform Load (ETL), Data Mart, Data Security, Data Warehousing, Software Design Patterns, Dimensional Modeling, Entity Relationship Models, Meta-Data Management, Microsoft SQL Server, Performance Tuning, Power BI, Standard Sql, SQL Server Integration Services, SQL Server Analysis Services, Enterprise Data Management, Azure Data Factory, Snowflake, Data Strategy, Data Analytics, Data Management, Tools for Reporting, Azure Synapse Analytics, Ssas Tabular - **Published:** May 19, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=9890133869e3ee38 ## About the Role * 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), * Related data warehouse: 8 years (Preferred) ## 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)., * 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. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Beyond SQL Generation: How to Teach Agents What Your Database Actually Means](https://www.wearedevelopers.com/videos/100127-beyond-sql-generation-how-to-teach-agents-what-your-database-actually-means) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Best Coding Boot Camps in Germany](https://www.wearedevelopers.com/magazine/237-best-coding-boot-camps-in-germany)