onsite
ETRM Systems Analyst - Puget Sound Energy
Software Engineer
The ETRM Systems Analyst will design, develop, and maintain automated energy trading and risk management solutions, leveraging SQL, Python, and cloud services to streamline data flows and support business decision‑making.
About the role
Key Responsibilities
- Design, develop, and enhance automated ETRM (Energy Trading and Risk Management) systems to support trading, scheduling, and risk analysis.
- Build and maintain data pipelines using ETL processes, ensuring accurate, timely data ingestion from market feeds, internal systems, and external sources.
- Develop SQL queries, stored procedures, and Python scripts for data extraction, transformation, and reporting.
- Collaborate with traders, risk analysts, and business stakeholders to translate functional requirements into technical solutions.
- Implement and manage cloud‑based components (e.g., AWS) to improve scalability, reliability, and performance of ETRM applications.
- Perform data modeling, validation, and troubleshooting to resolve data quality issues and optimize system performance.
Requirements
- Bachelor’s degree in Computer Science, Engineering, Energy Management, or related field, or equivalent professional experience.
- 3+ years of experience with SQL, Python, and ETL development in an energy or trading environment.
- Strong understanding of energy trading concepts, market data flows, and risk management processes.
- Hands‑on experience with cloud platforms (preferably AWS) and modern data integration tools.
- Excellent analytical, problem‑solving, and communication skills, with the ability to work cross‑functionally.