Utility Data & AI Analyst

City of Alameda; Alameda (CA); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Four‑day work week

CalPERS retirement

Comprehensive medical coverage

Dental coverage

Vacation time

Job summary

City of Alameda seeks a dedicated Utility Database Analyst to manage and secure AMP's data infrastructure. You will design and optimize relational databases, implement data integrations, and build BI reports to improve operational efficiency across the utility.

You will contribute to AI-enabled data modernization initiatives, ensure cybersecurity, and collaborate with vendors and City departments. Occasional after-hours work may be required, including emergencies.

Qualifications

• Two years of responsible experience in database administration, data processing, programming, systems analysis, or systems design.
• Graduation from an accredited four‑year college or university with major coursework in computer information systems, business administration, database administration, business intelligence, systems analysis, or related field.

Responsibilities

• Plans, designs, configures, programs, tests, installs, and upgrades relational databases for new and existing systems; analyzes data and monitors for performance.
• Manages files for database structures; designs, backup/recovery plans; conducts backup activities per schedule.
• Develops data queries and reports using BI tools; supports data integration and automation across systems.
• Ensures security and privacy levels are maintained in all database systems; monitors logs for problems.

Skills

Relational databases

Security

Data governance

AI data initiatives

Education

Four-year degree in IT or related field

Tools

SQL Server

Oracle

Power BI

Job description

City of Alameda seeks a dedicated Utility Database Analyst to manage and secure AMP's data infrastructure. You will design and optimize relational databases, implement data integrations, and build BI reports to improve operational efficiency across the utility.

You will contribute to AI-enabled data modernization initiatives, ensure cybersecurity, and collaborate with vendors and City departments. Occasional after-hours work may be required, including emergencies.