OPEN POSITION
Analyst
Reports to:
Principal
FLSA Grade:
Exempt
Employment:
Full-time
Location:
Portland, OR
Required Education & Experience:
- Bachelor’s degree in quantitative or critical thinking major with computer science/math emphasis.
The Role:
An Analyst extracts and integrates data from our state-of-the-art energy data warehouse, develops models, and analyzes wholesale electricity and natural gas markets. Working closely with other analysts and senior team members, the Analyst helps deliver accurate, insightful, and actionable information to clients. This position is based at our headquarters in Portland, Oregon.
Essential Duties and Responsibilities:
- Develop and Modify Queries to Extract Data from Database
- Develop and modify SQL code to extract data from database into Excel, Tableau, and other applications.
- Understand SQL data tables and structure to efficiently extract data and integrate multiple datasets.
- Identify, evaluate, and resolve data quality issues.
- Create Data Visualizations and Develop Insights
- Transform data into graphics that identify and reveal analytical insights.
- Tell the analytical story through easily understood graphs, tables, and images.
- Communicate results to Energy GPS team and clients verbally and in writing.
- Develop and Maintain Energy Market Models
- Use Python and/or Excel to develop and run models to find solutions to energy market problems.
- Use statistical concepts in the implementation of models (e.g. time series or regression-based analysis).
- Develop models that are flexible, efficient, well commented, and shared with others within the organization.
- General Research and Write Content and Other Analyses
- Draft reports that are relevant to assigned projects.
- Perform general research as directed by Energy GPS management.
- Document findings, keeping accurate and complete records to support replication or future research.
Behavioral Requirements:
Communication
Make sure we understand what you know and don’t know. Let us know when you have conflicts between deadlines for deliverables. Communicate effectively with clients on phone and via emails. Communicate in advance when deadlines may be missed.
Initiative
Work independently and take initiative to solve problems yourself. Use good judgment about when to pull other EGPS resources in for help.
Teamwork
Share your knowledge with others at EGPS. Treat others with dignity and respect.
Code Maintainability
Adhere to standards of writing good computer code and spreadsheet programming so that others may understand and maintain your code in your absence.
Record Keeping
Keep excellent records of the work that you perform so that others at EGPS can pick up in your absence.
Knowledge, Skills, and Abilities Required:
- Strong attention to detail and result-oriented skills
- Superior customer service
- Excellent verbal and written communication skills
- Demonstrated organizational skills
- Strong prioritization and interpersonal skills to balance multiple demands
- Proven ability to grasp new concepts quickly and to work with cross-functional teams in a fast-past work environment
- Knowledge of, or ability to learn, various IT application programs/data loading/data queries (SQL/Tableau) along with Python, R or some other data analysis focused language
- Experience in Excel, preferably including VBA
- Ability to self-start and consistently work independently with minimum assistance
- Strong skills in analysis, decision-making, and problem solving with innovative solutions
- Results-oriented and superior ability to handle multiple projects at one time
- Highly motivated and ability to work well both independently and in a team environment
- Ability to sit for extended periods of time
- Ability to use keyboard with repetitive hand movements
Benefits:
20 days of PTO, eight paid holidays, and paid parental leave
3% Safe Harbor 401(k) contribution – no employee contribution necessary
Full basic medical, dental, and vision coverage for the employee
Flexible, hybrid work schedule for better work-life balance
Collaborative environment with opportunities for career growth
Competitive compensation with semiannual performance-based bonuses
To Apply:
Equal Opportunity Employer
Candidates may apply by sending a resume and cover letter. In your cover letter, please describe your interest in the position; your experience in working with small or large teams; the relative strength of your skills; and why you believe you would be a good fit for this position.
Energy GPS offers a tremendous learning environment with growth opportunities within an entrepreneurial business. We offer a competitive compensation package commensurate with experience.
About Energy GPS
Energy GPS has been helping clients make informed decisions in the wholesale and renewable energy markets since 2009. We bring data and analytical techniques to bear on difficult questions related to valuation and risk. Our team of experienced energy professionals brings creativity and significant quantitative skills to generate actionable insights for our clients. We work on cutting edge problems related to renewable electricity and the integration of renewables into the wholesale electricity grid.
With broad expertise in electricity markets, natural gas markets and energy policy, our work spans the North American energy space. Energy GPS clients include renewable project developers, energy investors, lenders, corporate energy buyers, hedge funds, integrated energy companies, utilities and others.