GIS Enterprise Technology Analyst Intermediate_

Sacramento

Title: GIS Enterprise Technology Analyst Intermediate

Department: GIS

Location:

Sacramento, CA, US, 95819-4628

Category: Information Technology/Telecommunications

**Minimum Pay Rate:** $98,217.60

**Maximum Pay Rate:** $130,062.40

**Civil Service Status:** Civil Service

**Apply by Date:**

**Posting Type:** Open

You will be joining a team of Enterprise Technology analysts working in a fast-paced and dynamic work environment dedicated to delivering leading edge solutions. As part of the team you would be responsible for the design, configuration, operation, maintenance and enhancement of Gtech, ESRI, Synergi, LoadSEER, AutoCAD and other enterprise applications ensuring that they are reliable, accessible, and meet the needs of the business units.

**Purpose**

To provide a level of specialized business process and technical support utilizing SMUD’s various enterprise and other integrated technology solutions in the areas of design, configuration, operation, maintenance, and enhancement; and perform as a functional resource to the user community to ensure reliability, accessibility and effectiveness to meet the needs of the business unit overall.

**Nature and Scope**

This is the intermediate level (I) within the Enterprise Technology Analyst classification series, consisting of entry (E), intermediate (I) and journey (J) levels. Supervision is generally close. The incumbent will demonstrate familiarity with the following five specialty areas:

+ Enterprise Systems Design

+ Enterprise Applications: Modifications & Enhancements

+ Enterprise Applications: Optimization

+ Enterprise System Reporting

+ Project Management

This intermediate level employee will learn and receive increasingly complex and difficult assignments within one or more specialty area, leading eventually to performing at the journey level. Positions in this class are normally filled by progression from the Enterprise Technology Analyst (E), from other areas within SMUD where the incumbent gains knowledge of an enterprise technology application, or from the outside with the required minimum qualifications in one of the specialty areas.

**Duties and Responsibilities**

Enterprise Systems Design:

+ Design and configure various enterprise technology solutions to support business units; develop detailed designs and define user requirements by collaborating with process owners; document business processes and transaction steps; define codes and values; address integration issues; develop testing criteria and conduct testing; plan implementation strategies; and communicate technical information to the user community.

+ Enterprise Applications - Modifications and Enhancements:

+ Assess the need for modification and enhancement to existing enterprise applications by evaluating effectiveness of current technology; participate in facilitating user group forums; identify needed changes and enhancements; perform workflow and process evaluation; identify impacts to business processes; revise user and system requirements; design and integrate modifications; prepare change notices; develop testing criteria and conduct testing; and provide technical consultation and solutions.

+ Enterprise Applications - Optimization:

+ Offer technical support and user training; establish training needs; develop training material; conduct classroom and on-the-job training; troubleshoot user obstacles through training and/or on-line support; provide technical consultation and solutions; and troubleshoot system problems.

Enterprise System Reporting:

+ Provide business units with business necessity information by designing user reports; produce standard and custom reports; perform ad-hoc queries; modify standard forms and reports; and work with users to define reporting needs.

Project Management:

+ Plan, review, coordinate, conduct, and/or guide work activities and research of information associated with internal/external business unit projects; communicate with team members and incorporate their input to processes and techniques; provide staff training; select, or assist in selecting and orienting new staff; assist in evaluating work performance results; administer the department budget by participating in planning, monitoring, and revising schedules, work plans, expenditures, and assignments; and perform or assist in the preparation of procurement or bid documents, the evaluation of proposals, and the recommendation of awards to contractors or vendors.

+ Performs other related duties as needed to include working outside of typical business hours when necessary.

**Required Education**

+ High School diploma or equivalent

**Required Experience Qualifications**

Either one or more (1+) years of progressively responsible relevant work as an analyst in the areas of day-to-day design and maintenance of enterprise applications, or five or more (5+) years within a business unit with broad and deep knowledge of business processes and/or technology.

**Knowledge Of**

Enterprise application systems design, configuration, and functionality; concepts of the system development lifecycle; concepts of implementation strategies; concepts of data modeling, scripting, report design, data maintenance and retrieval; computer systems and resources; techniques and practices for resolving technical issues; characteristics and operational needs of various organizational units; standard business policies and procedures; standard operating procedures for modern office equipment including a computer and applicable software; and methods and techniques for training staff.

**Skills To**

Explain complex and/or controversial policies, regulations, procedures and/or activities internally/externally; assess procedures/systems and develop/implement operational improvements; develop an estimation of how a system should work under ideal conditions; evaluate and resolve technical issues; generate a number of viable alternatives to problems; identify significant organizational issues, concerns, and needs, and develop strategies for rectifying them; utilize judgement and assessment to identify the advantages and disadvantages of different approaches; read and interpret plans, diagrams and specifications; schedule and prioritize own work assignments to meet expected timeframes; work on one's own on projects of minor to moderate complexity; evaluate business processes; match user requirements to system capabilities; develop detailed specifications; recognize and understand system integration points; develop testing criteria and conduct testing; identify and assess training needs for staff; provide on-the-job training; effectively work on one's own or in a team; troubleshoot user and system problems; perform ad-hoc reporting and make script changes to reports and forms; stay abreast of new IT technology, tools and methods; utilize a personal computer, systems and software relevant to the job; communicate effectively orally and in writing internally/externally; establish and maintain effective internal/external working relationships and work effectively in diverse teams; coordinate project efforts; drive optimization efforts; and act as functional lead on projects.

**Desirable Education**

Degree/Certificate in Computer Science, Geographic Information Systems or related field

**Desirable Qualifications**

+ Detailed knowledge and understanding and support of Gtech, ESRI, Synergi, Autodesk, McLaren and LoadSEER. · Understanding and experience of ADMS, DERMS and OMS systems.

+ High level of expertise in relational database design using Oracle DBMS

+ Mastery of SQL and PL/SQL

+ Ability to model data efficiently and logically (this includes a thorough understanding of Normalization)

+ Thorough understanding of the Oracle Spatial and Locator objects and functions

+ In-depth knowledge of G/Technology software configurations through database metadata, assemblies, and supporting files

+ Ability to write and understand C# code using the .NET framework

+ Ability to create Font glyphs for the GIS symbols

+ Understanding of electrical utility circuits and the various devices

+ Expertise in database security techniques

+ Understanding of PowerClerk and DER data and the importance of the data.

+ Strong verbal and written communication skills, and ability to perform Root Cause Analysis.

+ Knowledge/experience of Python, FME, .Net, ModelBuilder, Powershell

+ Knowledge/experience of Microsoft System Center Configuration Manager

+ Knowledge/experience with Distribution Design Studio

+ Experience with ArcGIS Enterprise (Server, Portal, and Datastore)

+ Experience supporting GTechnology and ArcGIS desktop clients.

+ Knowledge and experience of Esri mobile solutions (Survey 123, Collector, Workforce,

+ Runtime)

+ Administering & troubleshooting web applications

+ Knowledge of existing SMUD enterprise system architecture

+ Ability to manage and set up Database Systems

+ Experience working with Esri ArcGIS SDE

+ Knowledge of software development using Agile methodology

+ Data Warehouse processes and techniques (ETL, BW/BI, Data mining, etc.)

+ Knowledge of change control and problem management processes

**Physical Requirements**

Applicants must be able to perform the essential job functions with or without a reasonable accommodation.

**Sacramento Municipal Utility District (SMUD) - Who We Are**

As the nation's sixth-largest community-owned electric service provider, we're proud of our reputation as one of the best places to work in Sacramento. Our employees tell us in our engagement surveys they're "Happy, satisfied and engaged" which helps create a workplace that best serves our customers. Sacramento was named as the 2nd happiest place to work in America by Forbes Magazine. Lake Tahoe, San Francisco and the world-renowned Napa Valley are within easy driving distance of our locations.

**Our Commitment to Diversity & Inclusion**

SMUD celebrates diversity, and inspires an inclusive culture based on trust and respect to create belonging and connection among our employees, customers, and communities. By working together, we are powering positive, equitable opportunities for all. We aspire to be a workplace where you can be yourself, achieve your best, and thrive together.

An example of our commitment to Diversity, Equity, Inclusion, and Belonging is when SMUD signed the California Equal Pay Pledge in 2020. This requires equal pay for employees who perform “substantially similar work,” when viewed as a composite of skill, effort, and responsibility at the time those employees started within that classification. As such, initial hiring salary range is not subject to negotiation and salaries will vary over time based on performance.

SMUD is proud to be an equal opportunity employer. We do not discriminate in employment decisions on the basis of race, color, religion, gender (including pregnancy), national origin, political affiliation, sexual orientation, gender identity or expression, marital status, disability, genetic information, age, veteran status, or any other applicable legally protected characteristic. All employment decisions are made on the basis of individual qualifications, merit, and business needs and interests.

**Why Sacramento, California?**

The capitol of California, Sacramento is the state's sixth-largest city, and the 35th largest in the U.S. Local universities include California State University, University of the Pacific's McGeorge School of Law, and the University of California, Davis and several competitive community colleges. The UC Davis Medical Center, a world-renowned research hospital, is one of more than a dozen hospitals and shared services centers in the Sacramento region. Part of the agriculturally-rich Central Valley, Sacramento is at the forefront of the farm-to-fork food movement. Northern California is home to some of the country's top technology companies, including Google and LinkedIn, and a multitude of startups in many industries. Sacramento is home to the NBA Kings, the River Cats (AAA baseball), the Republic FC (soccer) and the San Francisco Giants, NBA Warriors and NFL 49er's aren't far away. Sacramento offers an affluent liberal arts community with Broadway, Mondavi Center, Crocker Museum and summer musical theater to name a few.

**Hybrid Work**

This position may be eligible for SMUD's hybrid (office/home) work employee benefit, the schedule of which will be determined by the successful candidate and the Hiring Manager. SMUD takes pride in powering the Sacramento region community where we live and work. We value the strong working relationships we develop with our colleagues. Our approach to hybrid work will continue to evolve. Please be aware that should SMUD’s business needs change, emergencies occur, or various other reasons arise, you may be required to report onsite on a part-time or full-time basis.

SMUD provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. SMUD complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

SMUD expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of SMUD employees to perform their expected job duties is absolutely not tolerated.

Req ID: 1466