Sr. Analyst Settlements (Energy Imbalance/Regional Transmission Organization Market)

Job Type: Business Operations

Pay Range $90,840 to $106,869

Location Colorado Springs, CO

Date First Posted 9/18/24

Applications are being accepted through: 10/1/24

*If no date is displayed, applications are being accepted on an ongoing basis; however, this job posting may close at any time after a minimum of 5 days of being posted.

Sr. Analyst Settlements

(Energy Imbalance/Regional Transmission Organization Market)

*This job is eligible for relocation assistance to aid with the costs associated with moving to the Colorado Springs area.

Colorado Springs Utilities is looking for two Energy Imbalance Market (EIM)/Regional Transmission Organization (RTO) Energy Settlement Senior Analysts to provide support and expertise in our Planning and Finance Division (PFD). Our division has four departments: Accounting, Financial Planning and Risk, Treasury and Finance, Pricing and Rates. Both positions will reside within the Accounting Department and the Energy Settlements group.

Under general supervision, you will manage Power Bilateral, Energy Imbalance Market (EIM), and Regional Transmission Organization (RTO) settlements, including confirmation, calculation, billing, invoicing, reconciliation of charges and payments, timely and accurate production of energy bills, invoice processing, journal entries, general ledger reconciliation, meter data validation, reporting, audit support, and utilizing EIM and RTO Market software and meter data functionality. Additionally, this job will support the meters associated with EIM/RTO settlements.

Key Areas of Focus:

• Conducts research to aid in the interpretation of economic relationships and aid in solving problems specific to electric load research and data analysis associated with wholesale databases

• Use EIM/RTO Energy Accounting Systems to verify the quality of meter data and ensure proper conformance of data for transmission to Utilities Settlement systems

• Support Balancing Authority Area Day After and Month End Interchange checkout activities

• Validate and run multiple settlement statements for a given operating date to include pre-settlements, forecasted loads and offers, base schedules, operational and trading coordination, tagging setup, meter submittals, dispatch instructions, shadow settlements, settlement disputes, invoicing, and month-end and year-end accounting close

• Provide analytical support for power traders by using both data mining and fundamental analysis techniques to support trading decisions

• Analyze and communicate information and reports to others for key decision-making

• Ensuring compliance with FERC, GAAP/FASB/GASB, Colorado Springs Utilities legal, contract terms, regulatory requirements, and other standards and policies

• Understand interconnected bulk power generation and transmission systems, including delivery points and paths, and physical transmission congestion risks, and interpret both the language and terms and conditions of Open Access Transmission Tariff (OATT)

• Comprehension of EIM/RTO daily, monthly, and yearly settlement calendar for all aspects of settlements

• Ability to manage multiple settlement tasks taking place at the same time based on each day’s activity

• Complete accounting month-end and year-end closing activities, as well as year-end audit requirements

Who you are... You will bring your bachelor’s degree in Accounting, Business, Marketing, Finance, Management, Economics, Statistics, Mathematics, or a closely related field as well as years of direct experience in accounting and/or energy settlements or relevant energy analytical or business research-oriented field. We are also interested in the following so please make sure to highlight on your application/resume:

• Experience in the application and use of EIM/RTO Energy accounting systems is preferred to include:

• Power Cost Inc. (PCI)

• PI Vision

• OATI Oasis (or other tagging system)

• Strong understanding of the EIM/RTO Energy Markets in the United States

• Understand all proposed EIM/RTO Charge Codes, Determinants, and Invoicing line items defined in the EIM/RTO Market Protocols. These charge codes are complex and multifaceted

• Basic understanding of Market Protocols

• Strong understanding of accounting principles and functional knowledge of accounting concepts including excellent analytical skills to properly assess errors & variances to reconcile data to complete settlements

• Basic understanding of SQL programming language is a plus

• Ability to execute and run pre-written SQL queries for various Settlement reconciliation activities

• Know all aspects of the energy trader’s (Front Office – FO) EIM/RTO tasks and operational goals to determine expected outcomes

• Strong Microsoft Excel spreadsheet and Word software skills

• Understand system requirements and communicate trade capture software functionality in support of software reliability and consistency

• Knowledge of regulations, laws, FERC tariffs, business practice manuals, and best practices applicable to the EIM/RTO market

• Understand contract details and existing contractual rights for numerous contracts

• Ability to recognize business-planning activities directly or indirectly concerned with load forecasting, load research or program evaluation issues and to participate in those activities where appropriate

• Requires strong interpersonal skills in high-pressure situations and strong organizational skills.

• Ability to employ creative problem-solving techniques covering a wide variety of topics both in and out of the immediate areas of responsibility

• Strongly versed in continuous process improvement, root cause analysis, and change management.

• Power BI Experience is a plus

Our Commitment to Our Employees…

Our people are the heart and soul of Colorado Springs Utilities. They keep the lights on, gas flowing, water coming in, and wastewater leaving. We do not just say people are important – we prove it! That’s why we are honored to invest in protecting the health and financial security of our employees and their families through our rich benefits program.

• Time Off – Because everybody needs time off to recharge

• Vacation – New employees accrue 13 days of paid time off to start, while our more tenured employees accrue 24 days per year

• Personal Leave –3 days per year of personal leave

• Paid Holidays –12 paid holidays per year

• Sick Leave – Accrue 12 days of sick leave annually for those days when you or a family member is feeling under the weather

• Vacation Buy – Purchase up to 40 hours of additional vacation time

• Pension Plan – Looking forward to a comfortable lifestyle once you’re done working? The Colorado Public Employees’ Retirement Association (PERA) provides you with retirement benefits and peace of mind when you retire

• Medical – Select from three comprehensive medical plans, starting at $0 per month. Employees also enjoy access to a Health Savings Account (HSA) and Flexible Spending Account (FSA). (effective the 1st of the month following your start date)

• Wellness Program – Voluntary wellness program that allows you and your spouse to each earn up to $500 to use towards healthcare expenses, $100 in Visa gift cards, and up to $400 in gym membership reimbursements

• Dental – Select from two dental plans, with in-network PPO preventive care covered at 100% and access to orthodontia coverage (effective the 1st of the month following your start date)

• Vision – Voluntary plan that covers full vision care services and discounts on LASIK eye surgery (effective the 1st of the month following your start date)

• Retirement Saving Programs – Supplement your pension plan with voluntary retirement programs such as the PERAPlus 401(k) and MissionSquare’s Roth IRA and 457 plans

• Disability Coverage – Short-Term (STD) and Long-Term Disability (LTD) insurance available for purchase (effective the 1st of the month following your start date)

• Employee Assistance Program (EAP) – Makes the going a little easier by aiding with mental health, stress management, work-life balance, financial and legal matters, and much more

• Long-Term Care Insurance (LTC) – Whether it's due to an accident or a serious illness, LTC insurance is available for purchase to help you and your loved ones (effective the 1st of the month following your start date)

• Life Insurance – Company-paid life insurance and supplemental coverage available (effective the 1st of the month following your start date)

• Tuition Reimbursement – Employees are eligible to receive up to $5,250 annually for Tuition Reimbursement

• Qualifying Public Service Employer – Payments made towards student loans may qualify for the Public Service Loan Forgiveness Program

ATTENTION :

• All positions will be posted for a minimum of 5 calendar days.

• Starting pay will be determined within the posted pay range based on the experience, education, and training of the successful candidate; if there is a single pay rate posted, the job starts at that rate.

• Colorado Springs Utilities does not sponsor work visas of any kind (including but not limited to F-1, H-1B, or TN visas with a STEM OPT extension). Eligible applicants must be authorized to work in the United States.

Colorado Springs Utilities is an Equal Employment Opportunity/Affirmative Action employer. Our differences make us richer. Learning and growing from one another makes us more than what we were. We want our workforce to be as diverse as our business and recognize the limitless benefits of this commitment. Our desire is to have the organization reflect the diversity of the Pikes Peak Region. As an Equal Employment Opportunity employer, it is our commitment that no person shall be unlawfully discriminated against because of race, color, national origin or ancestry, sex, age, religious convictions, veteran status, disability, political beliefs, sexual orientation, or gender identity. Affirmative Action is Colorado Springs Utilities’ effort to ensure positive steps are taken to have a representative workforce reflective of the relevant available labor force.

For more information regarding applicant rights, visit https://www.dol.gov/ofccp/regs/compliance/posters/ofccpost.htm

Accessibility Accommodations . If you are an individual with a disability or disabled veteran who is unable to use our online tools to search and apply for jobs, you may request a reasonable accommodation by contacting us at accessibility@csu.org or by calling 719-668-7500. This option is reserved for individuals who are unable to use or require assistance with the online tools as the result of a disability and is not intended for other purposes.

E-Verify and Right to Work Notice . Federal law requires all employers to verify the identity and employment eligibility of all persons hired to work in the United States. Colorado Springs Utilities participates in E-Verify. For more information on your rights and responsibilities as an applicant, please visit: http://coloradospringsutilities.jobs/applicants-rights-and-responsibilities/ . If you have a legal right to work in the United States, there are laws to protect you against discrimination in the workplace. You should know that no employer can deny you a job or fire you because of your national origin. Unless mandated by law or government contract, employers cannot require you to be a U.S. Citizen or permanent resident or refuse any legally acceptable documents. If any of these things have happened to you, you may have a valid charge of discrimination that can be filed with the OSC. Contact the OSC for assistance in your own language. Call 1-800-255-7688. TDD for the hearing impaired is 1-800-237-2515. In the Washington, D.C., area, please call 202-616-5594, TDD 202-616-5525 Or write to: U.S. Department of Justice Office of Special Counsel NYA 950 Pennsylvania Ave., N.W. Washington, DC 20530.

Have a question? If you have a question about a position or need assistance from a recruiter, email us at csurecruiting@csu.org or call 719-668-7500.

Job Type: Business Operations