Senior SQL Server Data Architect & Analytics Consultant - local to CA

Senior SQL Server Data Architect & Analytics Consultant – Vegetation Management Database (VMD)

Location:

Onsite, Sacramento, CA – local only

Duration: 6+ months (Full-time)

Experienced Data & Analytics Consultant to lead design, development, and implementation of a VMD using Microsoft SQL Server. The VMD serves as the central repository for vegetation management data, supporting reporting, operational analytics, forecasting, predictive modeling, and decision-making.

• Design and develop SQL Server database architecture and data models.
• Integrate historical, reference, and operational data sources.
• Build secure data access and maintenance processes.
• Develop dashboards, KPI scorecards, reports, and visualizations.
• Implement predictive analytics and forecasting solutions.
• Create low-code/no-code solutions for business users.
• Establish role-based security, auditing, and governance controls.
• Conduct data quality assessments, migration, and validation activities.
• Provide technical documentation, training, and knowledge transfer.

• Minimum 10 years of experience delivering similar data management and analytics solutions.
• Strong expertise in Microsoft SQL Server database design and development.
• Experience with data integration, reporting, analytics, and forecasting.
• Experience developing dashboards and business intelligence solutions.
• Knowledge of Python-based analytics workflows is highly desirable.
• Utility, vegetation management, asset management, or related industry experience preferred.
• Discovery & Requirements Assessment Report.
• Logical and Physical Data Models.
• Database Design Documentation.
• Data Migration Plan and Load Scripts.
• Data Validation Reports.
• Data Maintenance Solution.
• Security Design Documentation.
• Dashboards, Reports, and Forecast Models.
• Test Plans, Data Dictionary, and Runbooks.
• Training Materials and Knowledge Transfer.