Share this Job

Sr Market Risk Reporting Analyst Job

Location(s): CO - Denver


Are you looking for an exciting job where you can put your skills, talents and education to work at a company you can feel proud to be a part of? Do you want a workplace that will challenge you and offer you opportunities to learn and grow?  A professional position at Xcel Energy could be just what you’re looking for.



Position Summary

Responsible for accurate, timely and meaningful market risk reporting to key internal consumers of Trading Risk and Risk Strategy information, including Senior Leadership, Commercial Operations, Trading, Risk Management and Accounting. Collaborates across Structured Deal Evaluation and Booking team to ensure robust valuation of complex transactions, using key valuation models and concepts. Ensures high integrity risk reporting process by comparing report results to multiple independent perspectives. Conducts analysis required to measure and explain real risk.

Essential Responsibilities
  • Leads the effort to translate Risk Strategy and Valuation methods into requirements, processes and tools that integrate with existing risk modeling and reporting framework. Design, develop and update portfolio risk reporting tools, and P/L and risk decomposition tools in a variety of implementations, including VBA, MATLAB, SAS and vendor reporting tools.
  • Using understanding of complex transactions, deploy model libraries for robust outside the system valuation, connect risk system with model outputs via load objects, and validate that resulting risk metrics and reports meet commercial intuition. Coordinate closely with Non-Standard Transaction Booking Team to ensure valuation model reflects transaction pricing.
  • Use understanding of commercial business strategy, commodity market fundamental drivers, portfolio theory and risk theory to identify discrepancies between expected results and system outputs, deploy market and systems expertise to resolve concerns, and accurately report real market risk.
  • Review operational risk controls, processes, and results. Provide feedback and training to Risk Operations team to obtain accurate and meaningful risk system inputs.
  • Coordinates monthly Risk System to GAAP reporting process with Technical and Operational Accounting. Use understanding of key accounting concepts to validate report outputs.
  • Deploy system design expertise, coding skills, valuation skills, and commercial abilities to enhance and streamline existing risk system. Coordinate closely with Valuation & Systems Strategy group on long term risk system project.

Minimum Requirements
  • Bachelor's degree in a highly quantitative discipline such as engineering, mathematics, physics, quantitative analysis, finance, economics or a related discipline.
  • Numerate graduate degree strongly preferred.
  • 3 years of experience in highly quantitative position within the energy industry or financial markets.
  • Knowledge of energy trading terminology, commodity markets and the analytical and statistical methods required to evaluate those markets.
  • Strong Excel and Excel VBA skills.
  • Coding and analysis package skills required, such as Python, MATLAB, or Java.
  • Excellent verbal, presentation and written skills.
  • Expected to work with minimal oversight in fast paced, open trade floor environment.





As a leading combination electricity and natural gas energy company, Xcel Energy offers a comprehensive portfolio of energy-related products and services to 3.4 million electricity and 1.9 million natural gas customers across eight Western and Midwestern states. At Xcel Energy, we strive to be the preferred and trusted provider of the energy our customers need. If you’re ready to be a part of something big, we invite you to join our team.


Posting Notes:  CO - Denver || CO - Denver || United States (US) || Risk Audit and Compliance || 25275:Risk Strategy & Control & Cred || Full-Time || Non-Bargaining ||

Requisition Number: 26484

Equal Opportunity Employer: Minority/Female/Disability/Veteran

Individuals with a disability who need an accommodation to apply please contact us at

EEO is the Law | EEO is the Law Supplement | Pay Transparency Nondiscrimination | Equal Opportunity Policy (PDF) | Employee Rights (PDF)

Xcel Energy endeavors to make accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact Xcel Energy Talent Acquisition at This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.






Our Values: One Team Powered by Many


Nearest Major Market: Denver

Job Segment: Risk Management, Accounting, Developer, Engineer, Finance, Technology, Engineering, Energy