Vegetation Management Database Developer/Analyst

Triune Infomatics

Sacramento, CA

JOB DETAILS
SKILLS
Asset Management, Centralized Operations/Management, Communication Skills, Data Analysis, Data Management, Data Modeling, Data Processing, Data Warehousing, Database Analysis, Database Architecture, Database Design, Database Extract Transform and Load (ETL), Database Programming, Documentation, ESRI, Energy & Utilities, Enterprise Applications, Enterprise Data Integration, Forecasting, Geographic Information Systems (GIS), Information/Data Security (InfoSec), Knowledge Transfer, Microsoft SQL Server, Performance Metrics, Performance Tuning/Optimization, Project Lifecycle, Project/Program Management, Python Programming/Scripting Language, Reporting Dashboards, Requirements Management, SAP, Scorecarding, Security Auditing, Spatial Data, Spreadsheets, Technical Writing
LOCATION
Sacramento, CA
POSTED
2 days ago
Role: Vegetation Management Database Developer/Analyst
Location: Sacramento, CA
Duration: 4 Months (July 15 November 15, 2026)


Summary: The client is seeking a Vegetation Management Database Developer/Analyst to design, build, and implement a centralized Vegetation Management Database (VMD) on Microsoft SQL Server. The solution will integrate data from multiple enterprise systems, support reporting, analytics, forecasting, and provide a secure, scalable data platform for vegetation management operations.

Key Responsibilities:
  • Lead discovery sessions, data assessments, and requirement gathering.
  • Design logical and physical SQL Server data models and architecture.
  • Build ETL processes and integrate data from GIS/ESRI, SAP, OMS, spreadsheets, and other enterprise systems.
  • Develop dashboards, KPI scorecards, reporting, and Python-based forecasting models.
  • Implement data governance, role-based security, audit trails, and validation controls.
  • Support testing, deployment, documentation, training, and knowledge transfer.
  • Coordinate with business stakeholders, GIS teams, and SMUD IT throughout the project lifecycle.

Required Qualifications:
  • 10+ years of experience in Data Architecture, Data Engineering, or Enterprise Data Management.
  • Strong expertise in Microsoft SQL Server, data modeling, database design, and performance tuning.
  • Experience designing enterprise data platforms and ETL/data integration solutions.
  • Experience integrating data with GIS/ESRI, SAP, OMS, and other enterprise applications.
  • Experience developing dashboards, analytics, and forecasting solutions using Python.
  • Strong understanding of data governance, security, and documentation.
  • Excellent communication and stakeholder management skills.

Required Skills
  • SQL Server Database Design & Architecture
  • Data Modeling & Data Warehousing
  • ETL/Data Integration
  • GIS/ESRI, SAP & OMS Integration
  • Python Analytics & Forecasting
  • Dashboard & KPI Reporting
  • Data Governance & Security
  • Performance Tuning
  • Technical Documentation
  • Stakeholder & Project Management

Preferred Qualifications
  • Utility, energy, infrastructure, or asset management industry experience.
  • Experience delivering enterprise data modernization initiatives.
  • Familiarity with low-code/no-code data maintenance solutions.

About the Company

T

Triune Infomatics