Share this Job

Analyst Program/Sys

Apply now

Apply for Job

Date: Jun 15, 2022

Location: San Antonio, TX, US, 78205

Company: CPS Energy

We are engineers, high line workers, power plant managers, accountants, electricians, project coordinators, risk analysts, customer service operators, community representatives, safety and security specialists, communicators, human resources partners, information technology technicians and much, much more. We are 3,300 people committed to enhancing the lives of the communities we serve.  Together, we are powering the growth and success of our community progress every day!


CPS Energy is seeking a high performing Analyst Program/System to provide informational and technical support to Financial Services.  Activities include, but not limited to, system administration of financial/budgeting/compliance modules, hardware support and implementation of financial tools, accounting/ budgeting system processes, preparation of audit schedules relative to financial master data / general ledger, system troubleshooting, efficiency & automation projects and solution enhancements for complex business needs.   Individual’s experience and technical skills will determine the placement of Analyst Program/System job level 1 – 4.



Deadline to apply: Reposted - Open until filled

Pay Grade


Qualifications may warrant placement in a different job level

Position Summary

CPS Energy is seeking a high-performing programmer analyst that serves as a technical/business resource within the Financial Services (FS) Business Area to support the following platforms:

  • SAP Enterprise Planning Module (EPM): labor planning phase of the annual 5 Year budget
  • SAP Financial Information (FI) & Controlling (CO): master data maintenance & cost allocation theory & design, month-end financial close processes & annual budget processes including overheads, settlements & assessments
  • Redwood Software’s Financial Close Automation (FCA): month-end scheduling automation software that executes Month-End processes
  • SAP Business Intelligence (BI): ability to write queries, create workbooks, work with Enterprise IT on development of new cubes as well as create reports using Crystal
  • Oracle/Access databases: develops & maintains databases and queries as needed for FS reporting
  • Tableau dashboards: develops and maintains dashboards using various data sources
  • FS Excel Workbooks & Macros / VBA code / Python & Other programming language(s): develops & maintains Excel workbooks with Excel macros and uses VBA code Python language or other programming tools to streamline and automate financial processes that bring value through improved efficiency and effectiveness

Tasks and Responsibilities

•    Leads & collaborates with other Financial Services areas to collect Headcount Count & Labor assumptions used to execute labor budgeting processes within EPM that generates the 5 Year Labor Budget
•    Reviews FI/CO master data requests and identifies FI/CO system structure updates
•    Performs cost allocation theory, design & programming functions 
•    Performs month-end financial close processes including overheads, settlement & assessments 
•    Performs annual budget processes including overheads, settlements & assessments in support of the 5-Year Budget
•    Performs FCA monthly updates in support of the Monthly Financial Close process
•    Develops, maintains & performs routine & ad hoc data queries from SAP ERP, BI, Oracle data bases and other related systems
•    Develops, maintains & supports Oracle & Access data bases 
•    Develops and maintains dashboards through data visualization tools (i.e. Tableau)
•    Recommends, develops and maintains Excel Workbooks & Macros, VB code, Python & other programming languages to streamline and automate financial processes 
•    Leads process improvement initiatives that create more efficient and effective processes
•    Serves on special project teams as assigned related to System(s)/Automation(s)
•    Performs system administration duties of various software platform (s), application(s), and integration
•    Analyzes and troubleshoots application(s)/system(s) and provides timely resolution to system design and/or operational issues
•    Develops and maintains complete and thorough Standard Operating Procedures (SOP)s for areas of responsibility 
•    Collaboratively cross-trains team members to support continuous learning and back-up support
•    Develops and conducts training classes as requested 
•    Maintains current knowledge of industry trends and technologies
•    Maintains and enhances systems as required to support operations
•    Evaluates systems to ensure reliable operational performance

Minimum Skills

Personal Computer Usage

Minimum Knowledge and Abilities

Extensive experience as a programmer/analyst in a field supporting and providing technical and analytical solutions.
Extensive experience in program/project management for Operational Units.
Exceptionally strong analytical and problem solving abilities
Demonstrated ability to multi-task various critical work assignments proactively and independently in a fast paced environment and in a professional manner.
Ability to identify alternative solutions for development of decision-making proposals, which support organizational goals/objectives and budget constraints
Initiative to work independently or as a member of a team, coordinating with others to achieve desired results
Demonstrated well-developed written and verbal communications skills for interaction within the section, across departmental lines to all levels of personnel, and vertically with management.
Ability to handle complex assignments, be a self-starter, be able to meet goals and deadlines on own initiative with minimum supervision
Demonstrated positive interpersonal behaviors toward CPS Energy, associates, and customers consistent with company core values.
Position content is substantially complex with diverse issues and problems
Possesses and applies comprehensive knowledge of a particular field of specialization to complete complex assignments.
Ability to make independent decisions and often makes recommendations which affect the section, department and/or division
High level of accuracy of work and attention to detail, to include the ability to perform precise mathematical calculations
Highest level subject matter / technical expert and may include limited supervisory responsibilities
Works with minimum supervision, conferring with superior on unusual matters. Incumbents have considerable freedom to decide on work priorities and procedures to be followed.
Ability to work at any location at any time with extensive time in the field working with business areas
Extensive experience in Information Systems, Reporting Solutions, Database Management and Web Development
Ability to translate business needs to technical specifications
Ability to articulate the business problem to be analyzed, quickly identify the critical elements of the problem, achieve a high quality answer in a timely fashion, and synthesize answers to resonate with decision makers.

Preferred Qualifications

Masters degree or relevant Certification

Extensive experience with financial and operational analytical support. Extensive experience with administration of applications.

Relative experience in supporting utility construction and maintenance. Experience with GASB accounting rules, principles and guidelines Experience with FERC accounting rules and guidelines

Experience with SAP modules and tools (i.e., GL, CO, PM, PS, MM, Budgeting, Planning & Consolidation) Experience with Data Visualization tools (i.e. Tableau)

Experience with the electric or gas utility industry gained through experience at an electric / gas utility, an investment bank, consultant, or other professional service provider serving the industry


Demonstrating Initiative
Working with Ambiguity
Driving for Results
Evaluating and Implementing Ideas
Driving Continuous Improvement
Communicates Effectively

Minimum Education

Bachelor's Degree in Information Technology, Computer Science, Environmental Science, Accounting, Finance, Business Administration, Economics, Engineering, Math, the Natural Sciences, or other quantitative field from an accredited university or related area; proven working experience may be used in lieu of degree

Required Certifications

Working Environment

Work is performed indoors & outdoors. Manual dexterity, talking, hearing, and repetitive motion. Use of computing equipment, telephone, & printer/copier. Ability to travel to and from business related events. After hours work may be required.

Physical Demands

Indoor/Outdoor Environment

CPS Energy does not discriminate against applicants or employees. CPS Energy is committed to providing equal opportunity in all of its employment practices, including selection, hiring, promotion, transfers and compensation, to all qualified applicants and employees without regard to race, religion, color, sex, sexual orientation, gender identity, national origin, citizenship status, veteran status, pregnancy, age, disability, genetic information or any other protected status. CPS Energy will comply with all laws and regulations.

Nearest Major Market: San Antonio

Job Segment: ERP, Power Plant Operator, SAP, Oracle, Database, Technology, Energy