> Markdown version of [/jobs/ext/3065733-data-architect](https://www.wearedevelopers.com/jobs/ext/3065733-data-architect). 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 Architect - **Company:** The Joule - **Location:** Salt Lake City, UT, United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Business Analytics Applications, Data Analysis, Computing Platforms, Microsoft Azure, Information Systems, Data Architecture, Data Governance, Data Infrastructure, Extract Transform Load (ETL), Data Structures, Data Warehousing, Database Design, Dimensional Modeling, Meta-Data Management, Microsoft SQL Server, Power BI, Systems Integration, Transact-SQL, Enterprise Data Management, Enterprise Software Applications, Azure Data Factory, Data Strategy, Microsoft Fabric, Information Technology, Data Lineage, Star Schema, Data Management, Physical Data Models, Azure Synapse Analytics - **Published:** September 25, 2026 - **Apply:** https://www.dice.com/job-detail/cf333b5a-f980-4a06-8573-d97817e9ba4e ## About the Role * Bachelor's degree in Computer Science, Information Systems, Data Science, or a related discipline, with a minimum of 7+ years of enterprise data architecture and data modeling experience. * Expert level experience developing conceptual, logical, and physical data models, including enterprise data domains, canonical models, data modeling standards, and architecture documentation. * Extensive experience with dimensional modeling, enterprise data warehouse architecture, star/snowflake schemas, and scalable data structures supporting BI and analytics. * Strong hands-on experience with SQL Server and T SQL, including complex data analysis, database design, performance considerations, and enterprise data integration. * Experience designing enterprise reporting, analytics, and semantic models, including Power BI semantic models or equivalent business intelligence technologies. * Strong understanding of ETL/ELT architecture, data integration patterns, metadata management, data lineage, data quality, and enterprise data governance practices. * Experience with modern cloud-based analytics/data platforms, preferably Azure Synapse Analytics, Microsoft Fabric, and broader Azure Data Platform technologies; experience modernizing enterprise analytics platforms is highly desirable. * Strong architecture, analytical, documentation, communication, and mentoring skills; experience with higher education, Ellucian Banner ERP, DAMA practices, or relevant Microsoft/Azure certifications is an advantage. ## Description * Design and maintain enterprise conceptual, logical, and physical data models, establishing canonical business entities, enterprise data domains, naming conventions, and reusable modeling standards. * Architect scalable enterprise data solutions supporting business intelligence, reporting, analytics, data warehousing, and institutional decision-making requirements. * Design and optimize dimensional data models, including star and snowflake schemas, semantic structures, and reusable analytical models for enterprise reporting. * Evaluate existing data structures, warehouse models, and analytics architectures; identify gaps and recommend improvements for scalability, maintainability, performance, consistency, and reuse. * Partner with Business Intelligence, Data Platform, Enterprise Architecture, application, and DBA teams to resolve complex data design challenges and ensure alignment with enterprise architecture standards. * Define and recommend scalable ETL/ELT and enterprise data integration patterns, including integrations across ERP systems, enterprise applications, data platforms, and analytics solutions. * Establish and promote data governance, metadata management, architecture documentation, reference architectures, and data modeling standards while contributing to the organization's long-term data strategy. * Mentor BI and Data Platform engineers, conduct architecture/design reviews, and provide knowledge transfer while supporting analytics modernization initiatives involving Azure Synapse, Microsoft Fabric, and other Azure Data Platform technologies. ## Related Videos - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [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) - [Data: The Deciding Factor in AI Success](https://www.wearedevelopers.com/videos/100310-data-the-deciding-factor-in-ai-success) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## 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) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)