Senior SQL Server Data Architect / Data Analytics Consultant

Position Overview

We are seeking a Senior SQL Server Data Architect / Data Analytics Consultant to design, develop, and implement a centralized data platform that supports data management, integration, reporting, dashboards, operational analytics, predictive analytics, forecasting, performance scorecards, and decision support capabilities.

The ideal candidate will have strong expertise in Microsoft SQL Server, data architecture, data integration, business intelligence, reporting, forecasting, and data governance. This role will work closely with business and technical stakeholders to assess existing data sources, define requirements, design scalable database solutions, integrate data sources, and deliver analytical and reporting solutions.

Key Responsibilities

Data Architecture & Database Design

• Design and develop scalable Microsoft SQL Server database solutions.
• Create logical and physical data models, tables, relationships, keys, indexes, and constraints.
• Establish metadata standards, naming conventions, and data governance practices.
• Design raw, staging, curated, reference, and reporting data layers.

Data Integration & Management

• Load and maintain historical and reference data.
• Design and implement ETL/ELT processes and repeatable data maintenance procedures.
• Cleanse, standardize, transform, and validate data.
• Integrate approved external data sources using secure access methods while minimizing data duplication.

Reporting, Analytics & Forecasting

• Develop dashboards, executive scorecards, KPI reporting, and data visualizations.
• Deliver operational analytics, predictive analytics, and forecasting models.
• Support workforce planning, resource utilization, budgeting, productivity tracking, and performance management.
• Perform query optimization and database performance tuning.

Business User Enablement & Security

• Develop secure low-code/no-code solutions for business-managed data maintenance.
• Implement role-based security, audit trails, validation rules, and data quality controls.
• Enable self-service data management while maintaining governance standards.

Documentation, Testing & Knowledge Transfer

• Conduct requirements gathering, stakeholder workshops, and data assessments.
• Support testing, UAT, implementation, and post-production stabilization.
• Create technical documentation, data dictionaries, runbooks, and training materials.
• Provide knowledge transfer and end-user training.

Required Qualifications

• Minimum 10 years of experience in database architecture, data management, analytics, or business intelligence solutions.
• Strong expertise with Microsoft SQL Server, T-SQL, database design, and performance tuning.
• Experience with data modeling, data warehousing, ETL/ELT development, and data integration.
• Hands-on experience developing dashboards, reports, scorecards, and analytical solutions.
• Experience with forecasting, predictive analytics, KPI reporting, and business intelligence.
• Knowledge of data governance, data quality, security controls, auditing, and role-based access management.
• Experience working with large datasets and complex enterprise data environments.
• Strong communication, documentation, stakeholder management, and training skills.

Preferred Qualifications

• Experience supporting utility, vegetation management, asset management, field operations, or infrastructure environments.
• Experience integrating GIS and operational data sources.
• Experience with Python for analytics, automation, forecasting, and predictive modeling.
• Experience with Power BI, SSRS, Tableau, or similar reporting and visualization platforms.
• Familiarity with low-code/no-code data maintenance solutions.

Technical Skills

SQL Server | T-SQL | Data Modeling | Data Warehousing | ETL/ELT | Data Integration | Power BI | SSRS | Tableau | Python | Predictive Analytics | Forecasting | Dashboard Development | KPI Reporting | Query Optimization | Data Governance | Data Quality | Security & Auditing | Business Intelligence