> Markdown version of [/jobs/ext/612066-sql-server-data-architect-analytics-consultant](https://www.wearedevelopers.com/jobs/ext/612066-sql-server-data-architect-analytics-consultant). 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 Server Data Architect / Analytics Consultant

- **Company:** Staff Tech
- **Location:** Sacramento, CA, United States
- **Experience:** Expert
- **Contract:** Temporary contract
- **Skills:** Business Analytics Applications, Data Analysis, Databases, Data Architecture, Data Dictionary, Data Integration, Extract Transform Load (ETL), Data Warehousing, Database Design, Database Development, Database Security, Database Storage Structures, Python (Programming Language), Microsoft SQL Server, Operational Data Store, Performance Tuning, Query Optimization, Performance Monitor
- **Published:** June 18, 2026
- **Apply:** https://www.dice.com/job-detail/73f16afd-2b36-4147-90e9-745b492736a6

## About the Role

* 10+ years of SQL Server database architecture and development experience.
 * Strong data modeling and database design experience.
 * Experience with data warehousing and data integration.
 * Experience developing reporting, dashboard, and analytics solutions.
 * Experience with forecasting and performance reporting.
 * Strong SQL query optimization and performance tuning skills.
 * Experience gathering and documenting business requirements.
 * Excellent written and verbal communication skills.

Preferred Skills

 * Utility industry experience.
 * GIS integration experience.
 * Asset management or operational analytics experience.
 * Predictive analytics experience.
 * Python development experience.
 * Executive dashboard and KPI reporting experience.

Technical Environment

 * Microsoft SQL Server
 * SQL Development
 * Data Modeling
 * Data Warehousing
 * ETL / Data Integration
 * Business Intelligence
 * Reporting & Dashboards
 * Forecasting & Analytics
 * Python
 * KPI Reporting
 * Database Security & Governance

## Description

Staff Tech is seeking a Senior SQL Server Data Architect for a hybrid consulting opportunity in the Sacramento area. This position will focus on database architecture, data integration, reporting, analytics, forecasting, and business intelligence solutions supporting a large-scale operational data environment., * Design and develop SQL Server database solutions.

 * Create logical and physical data models.
 * Design database structures, relationships, indexes, and constraints.
 * Develop and support data integration and ETL processes.
 * Load, transform, validate, and maintain historical and operational data.
 * Develop dashboards, reports, scorecards, and visualizations.
 * Build forecasting and predictive analytics solutions.
 * Gather and document business requirements.
 * Conduct stakeholder meetings and requirements workshops.
 * Develop technical documentation and data dictionaries.
 * Support testing, implementation, training, and knowledge transfer.
 * Implement role-based security and auditing controls.


## Related Videos

- [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail)
- [Parquet, Delta, Iceberg & Ducklake - An introduction for developers](https://www.wearedevelopers.com/videos/100075-parquet-delta-iceberg-ducklake-an-introduction-for-developers)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data)
- [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)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [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)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)