Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
7236 - Senior SQL Server Data Architect / Analytics Consultant (Hybrid) Must Reside in Sacramento to be
Considered Location:
Sacramento, CA (Hybrid)
Duration:
4
Months Interview Process:
On Site Overview 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. Responsibilities 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. Required Skills 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