Data Analyst
Trafilea Tech E-commerce Group
SQLTableau
Energy Market Risk Data Analyst
Intersect
full-time
Posted on:
Location Type: Remote
Location: Remote • California, Colorado, New York, Texas • 🇺🇸 United States
Visit company websiteSalary
💰 $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
