Intersect

Energy Market Risk Data Analyst

Intersect

full-time

Posted on:

Location Type: Remote

Location: Remote • California, Colorado, New York, Texas • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Salary

💰 $105,000 - $118,750 per year

Job Level

JuniorMid-Level

Tech Stack

CloudETLPythonSDLCSQL

About the role

  • Leverage Google Cloud environments to design and orchestrate ETL pipelines
  • Write, optimize, and maintain SQL queries supporting reporting and analytics
  • Maintain schedules, security, and documentation for data warehouses
  • Build and support Power BI dashboards and reporting tools across multiple teams
  • Use Plotly Enterprise and Python to create risk management applications and visualizations
  • Leverage Intersect’s Trade Capture System for reporting and analysis
  • Partner with trading, software development, and operations teams to design scalable data solutions
  • Identify, build, and maintain API connections with key applications
  • Translate business requirements into technical workflows and clear reporting outputs
  • Develop change management procedures for processes impacting operational data
  • Create and maintain documentation of pipelines, tools, and reporting standards
  • Manage and guide consultants and service providers supporting Intersect’s data infrastructure

Requirements

  • THIS ROLE REQUIRES 2+ YEARS OF EXPERIENCE IN U.S. ENERGY MARKETS
  • Expert knowledge of Python, BigQuerySQL, object-oriented programming, and Power BI
  • Experience with Google Cloud environments and modern data team practices
  • Familiarity with business analysis, requirements gathering, data modeling, warehousing, and Software Development Lifecycle (SDLC)
  • Undergraduate degree in computer science or a related technical field or equivalent experience
  • Exposure to Trade Capture or Enterprise Trading and Risk Management Systems preferred
  • Working knowledge of Plotly Enterprise is an asset
  • Excellent communication skills, with the ability to present complex ideas clearly
Benefits
  • 100% premium coverage for you and your dependents on medical, dental, and vision
  • Unlimited PTO, plus two company-wide breaks (Fourth of July & end of year)
  • Up to 12 weeks of fully paid parental leave, plus 6 additional weeks for birth parents; access to family planning support via Carrot
  • Free access to Ginger coaching and counseling, plus a Headspace account for mindfulness and meditation
  • 3% non-elective employer contribution to your 401k or RRSP, ensuring your financial future is on the right track
  • $150 monthly food stipend, pet insurance allowance, and full home office setup

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLPythonBigQuerySQLobject-oriented programmingETLdata modelingdata warehousingAPI connectionschange managementreporting
Soft skills
communicationbusiness analysisrequirements gatheringdocumentationteam collaborationpresentation skillsproblem-solvingorganizational skillsleadershipconsultant management