Power Markets Data Analyst: ERCOT & PJM Insights

Priority Power Management, Inc.; Houston (TX); On-site; USD 70,000 - 110,000; Full time

Job summary

Priority Power seeks a Market Analyst to support power and natural gas forward curves, data analytics, and customer-facing market communication, with a focus on ERCOT and PJM. The role spans junior to experienced levels based on background, and involves Databricks, PostgreSQL, and Tableau work.

The position emphasizes building and presenting market insights to clients and internal teams, with opportunities to publish quarterly market recaps and outlooks while pursuing automation of analytics

Qualifications

• Bachelor's degree in a quantitative field or equivalent experience.
• Willingness to develop SQL, Python, and Tableau on the job.
• Strong written and verbal communication for non-technical audiences.
• High attention to detail in customer-facing materials.
• Genuine interest in power and natural gas markets.

Responsibilities

• Mark and maintain forward price curves for ERCOT and PJM power products.
• Pull, clean, manipulate data from Databricks, PostgreSQL, and Amazon Athena/S3, and build ad hoc and permanent visualizations and dashboards in Tableau.
• Write SQL queries and manage data pulls across multiple database environments in support of recurring and one-off analysis.
• Maintain and analyze large Excel workbooks; perform ad hoc analysis in Excel as needed.
• Apply analytical methods, including basic statistical analysis, to identify pricing trends across power markets.
• Help build and deliver customer-facing market update decks; present market moves and analysis directly to customers and to internal sales teams.
• Write and publish quarterly market recaps and outlooks covering ERCOT and PJM fundamentals.
• Identify opportunities to improve or automate existing analytics and reporting processes and build the tools to implement them.
• Partner with Commercial Markets leadership and internal teams to align market commentary and analysis with broader company messaging.

Skills

Data analytics

Tableau

SQL

Python

Excel

Communication skills

Market knowledge

Education

Bachelor's degree in Finance, Economics, Statistics, or related

Tools

Databricks

PostgreSQL

AWS (S3)

Athena

Job description

Priority Power seeks a Market Analyst to support power and natural gas forward curves, data analytics, and customer-facing market communication, with a focus on ERCOT and PJM. The role spans junior to experienced levels based on background, and involves Databricks, PostgreSQL, and Tableau work.

The position emphasizes building and presenting market insights to clients and internal teams, with opportunities to publish quarterly market recaps and outlooks while pursuing automation of analytics