Utility Systems Analyst

  • San Marcos, TX
  • San Marcos, Texas
  • Mar 17, 2020
Full Time Information Technology and Communication Services Utilities
  • Salary: $28.28 - $38.89 Hourly USD

Job Description

JOB SUMMARY


This position is open until filled with first review of applications on February 21, 2020


The City of San Marcos is looking for the ideal candidate who enjoys analytics and is ready to play a meaningful role as a Utilities Systems Analyst.

JOB SUMMARY
Develops, deploys and administers Utility Systems analytical reports and rules to support water and electric operations utilizing automated metering infrastructure (AMI), GIS,SCADA, utility billing, and other utility information systems (Yukon, MeterSense, ESRI ArcGIS, Maximo, mCare, NorthStar, and upcoming technologies). The role includes AMI system design, data analysis, quality assurance, and application support. The position will also support Meter Operations with all software setups, implementations, integrations and upgrades but with the main focus on the AMI. Collaborates with Utility staff, other departments, and vendors to coordinate upgrades and recommends new technology solutions that affect Utility Systems operations. Leads specific work activities of other staff, interns or temporary personnel during special projects and performs other related duties. The analyst will be the functional expert on the Utility Systems applications.


ESSENTIAL FUNCTIONS AND DECISION MAKING

ESSENTIAL FUNCTIONS
  1. Solution Development - Collaborates with Utility staff, IT, other departments, and vendors to coordinate upgrades to the Utilities AMI system and other existing systems and recommend new technology solutions that affect Utility operations while reviewing infrastructure in the field.
  2. Reviews Utility Systems processes and develops rules to increase operational efficiency.
  3. Reviews existing Utility Systems technology solutions and makes recommendations to management for upgrades, enhancements, or new technology solutions.
  4. Collaborates with IT staff and vendors to ensure proper report access.
  5. Collaborates with stakeholders to define project deliverables and define new reports; supports solution development with ad hoc reports; trains report users.
  6. Collaborates with GIS Technology Management to develop GIS products.
  7. Provides assistance to vendors and IT staff to identify and resolve technology issues with Utility Systems applications.
  8. Data Analysis / Enterprise Reporting - Develops, deploys, and administers reports containing Utility Systems data to support operations and management decisions.
  9. Analyzes data and develops suggestions/recommendations to improve utility operations.
  10. Develops reports; trains and supports users.
  11. Provides analysis of the impact new solutions will have on Utility Systems data and current policies/procedures.
  12. Establishes and performs quality assurance/control procedures across utility platforms.
  13. Application Support -
    • Performs software setups for applications and users.
    • Works with IT to implement new enterprise applications and/or changes to existing applications.
    • Works with IT to integrate enterprise applications.
  14. Monitors Utility Systems applications for failures and inconsistencies.
  15. Develops, implements, and maintains the departmental computer applications procedures and documentation for utility metering operations.
  16. Establishes procedures, standards, and training tools used to facilitate the accuracy and completeness of data in the Utility Systems databases.
  17. Develops and deploys data audit reports for management and supervisory personnel to use in the assessment of department metrics and staff productivity.Trains staff to use reports.
  18. Develops test scenarios of upgrades for Utility Systems solutions; coordinates testing with IT, vendors, Utility staff and other departments in the field.
  19. Backs up Meter Data Specialist with review of AMI Data Validation failure reports and AMI Network Health issues.
  20. Leads specific work activities of other staff, interns or temporary personnel during special projects.
  21. Assist IT staff with maintenance of essential Utility Systems software; monitors vendor contracts.
  22. Provides utility data for consultants.
  23. Performs other routine and/or specialized duties relative to area of assignment as required.

DECISION MAKING
  • Must have the ability to apply analytical thinking to a variety of inputs and quickly discern cause and effect. Must be able to develop solutions to challenging technical issues. Must have the ability to resolve computer hardware/software issues.
  • Leads specific work activities of other staff, interns or temporary personnel during special projects; leads Utility Systems projects during software upgrade testing.


MINIMUM QUALIFICATIONS (Salary is dependent upon qualifications)

MINIMUM REQUIREMENTS
  • Bachelor's Degree in computer technology or a related field is required.
  • Two (2) years SQL query and business reporting experience is required.
  • Must possess a valid Texas Driver's License with an acceptable driving record.
PREFERRED QUALIFICATIONS
  • Four (4) years relational database. Oracle and SQL.
  • Three (3) years utility experience.
  • Strong understanding of radio signals as is used in an AMI system.
  • Knowledge of Meter Data Management System (MDMS).
  • ESRI ArcGIS desktop, SDE, and Server software (version 10 or higher) experience.
  • IBM Maximo Asset Management software (version 6.x or higher) experience.
  • Knowledge of GIS scripting language (Python and SQL).
  • Report-writing experience (Crystal Reports/BIRT/Cognos).
  • Knowledge of SCADA systems.




CORE COMPETENCIES AND PHYSICAL DEMANDS

CORE COMPETENCIES
  • Must be able to read and comprehend computer manuals; must have the ability to prepare Utility Systems reports, quality assurance/control plans, and computerized templates.
  • Effective verbal and written communication skills are required; must be able to maintain positive working relationships with City departments and personnel, outside agencies, and vendors.
PHYSICAL DEMANDS AND WORKING CONDITIONS
Physical requirements include lifting up to 25 pounds rarely. Subject to vision constantly; sitting, handling, fine dexterity, hearing and talking frequently; standing, walking, lifting, carrying, pushing/pulling, reaching and foot controls occasionally; kneeling, crouching, bending, twisting, climbing and balancing rarely.

Working conditions involves exposure to variable and/or extreme weather conditions, uneven terrain, vehicle traffic, heavy equipment, high voltage electrical currents, working at heights, hazardous chemicals and materials, stray/vicious animals and wildlife. Protective equipment to include safety glasses, gloves, hard hat, fire retardant clothing, and shoes.

Safety Sensitive Position

Closing Date/Time:

Job Address

San Marcos, Texas United States View Map