> Markdown version of [/jobs/ext/593409-sql-data-architect](https://www.wearedevelopers.com/jobs/ext/593409-sql-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). --- # SQL Data Architect - **Company:** ACE Limited - **Location:** United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Data Analysis, Databases, Data Architecture, Data Dictionary, Data Governance, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Migration, Data Security, Data Stores, Data Systems, Data Visualization, Relational Databases, Database Design, Python (Programming Language), Meta-Data Management, Microsoft SQL Server, Performance Tuning, Query Optimization, SQL Databases, Enterprise Data Management, Database Optimization, Low-code, Data Management, Tools for Reporting - **Published:** June 22, 2026 - **Apply:** https://www.dice.com/job-detail/5cadf2d7-e291-4049-b36a-b5f30dda63b7 ## About the Role * 10+ years of experience designing, developing, and implementing enterprise database and data architecture solutions. * Advanced expertise with Microsoft SQL Server, including database design, performance tuning, data modeling, and query optimization. * Strong experience building data integration, ETL, data migration, and data quality management solutions across multiple source systems. * Demonstrated success developing reporting, dashboarding, business intelligence, analytics, forecasting, and performance management solutions. * Experience translating business requirements into scalable technical architectures and actionable data solutions. * Strong understanding of relational database design principles, metadata management, data governance, and security best practices. * Experience implementing role-based security models, auditing controls, and business-user data maintenance frameworks. * Proficiency creating technical documentation, data dictionaries, design specifications, and operational runbooks. * Experience supporting complex operational environments involving asset management, infrastructure, utility operations, field services, or similar industries is highly preferred. * Familiarity with predictive analytics, statistical modeling, and Python-based analytical workflows is preferred. * Strong communication, facilitation, and stakeholder management skills with the ability to work effectively across technical and non-technical teams. * Proven ability to manage multiple priorities, drive projects from concept through implementation, and deliver high-quality solutions in a collaborative environment. ## Description Our client is seeking a SQL Data Architect to lead the design, development, and implementation of a centralized enterprise data platform that supports operational reporting, advanced analytics, forecasting, and strategic decision-making. This individual will partner with business and technical stakeholders to transform complex data from multiple sources into a scalable, secure, and user-friendly environment. The ideal candidate combines deep SQL Server expertise with strong data architecture, analytics, and stakeholder engagement skills to deliver solutions that improve operational visibility and long-term planning capabilities., * Design and implement scalable Microsoft SQL Server database architectures, including logical and physical data models, data relationships, indexing strategies, and performance optimization. * Lead discovery sessions with business stakeholders to gather requirements, assess existing data sources, define business rules, and identify reporting and analytics needs. * Develop and maintain centralized data repositories that support historical data management, operational reporting, forecasting, predictive analytics, and decision-support initiatives. * Design and implement secure data integration solutions that connect internal and external data sources while minimizing duplication and maintaining data integrity. * Create dashboards, scorecards, KPI reporting, data visualizations, and analytical models that support operational performance, financial oversight, resource planning, and executive decision-making. * Establish repeatable data loading, transformation, validation, and maintenance processes to ensure data quality, consistency, and reliability. * Develop low-code or no-code solutions that enable authorized business users to maintain approved datasets while enforcing governance and security standards. * Implement role-based access controls, auditing mechanisms, validation rules, and data governance practices to support compliance and accountability. * Support forecasting, trend analysis, predictive modeling, and advanced analytical initiatives using SQL, reporting tools, and Python-based workflows where appropriate. * Lead testing efforts, user acceptance activities, technical documentation, training, and knowledge transfer to ensure long-term sustainability of the solution. * Collaborate with cross-functional technology, GIS, operations, and business teams to align data solutions with organizational standards and strategic objectives. * Provide project coordination, implementation support, status reporting, and post-deployment stabilization assistance throughout the project lifecycle. ## Related Videos - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Reimagining app development with Low-code and AI](https://www.wearedevelopers.com/videos/1651-reimagining-app-development-with-low-code-and-ai) - [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) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Dynamic Entities in .NET: Building Low-Code Systems on Top of Entity Framework Core](https://www.wearedevelopers.com/videos/100218-dynamic-entities-in-net-building-low-code-systems-on-top-of-entity-framework-core) ## 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) - [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) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [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)