OPEN POSITION
Associate
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.
- High degree of fluency in math, statistics, and quantitative analysis as demonstrated through strong grades in higher level math and data analysis classes.
- Superior ability to handle multiple projects at one time and be very results oriented.
- Significant experience with at least two of the following: Excel (VBA), SQL, Python, Tableau, R, Monte Carlo modeling, machine learning / AI.
- Three years of relevant experience in energy or related field with practical, hands-on knowledge of data analysis and modeling.
The Role:
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 reveal analytical insights.
- Tell the analytical story through easily understood graphs, tables, and images.
- Communicate results to Energy GPS team and clients.
- Develop and Maintain Energy Market Models
- Develop, maintain, and run models to analyze energy markets and risk using Python, Excel, or other relevant tools. Examples of models include:
- Use and maintain Python-based Monte Carlo model used to analyze wholesale market risk associated with renewable generation resources.
- Assist in the development of short-term storage dispatch models using various machine learning and artificial intelligence techniques.
- Perform statistical analysis (such as regression) in R or Excel to estimate the energy demand based on econometric models. relationship between electricity, natural gas, and gasoline usage correlated with other variables.
- Models may require implementation of statistical analysis such as time series or regression-based modeling. Must possess strong understanding of probability, quantitative modeling techniques, statistical methods for data analysis, and the presentation of statistical results.
- Models must be designed to achieve the following:
- Documentation – Models must have documentation and comments in the code. Knowledge of industry-standard documentation approaches required.
- Efficient coding – Models must be designed and coded to be as efficient as possible. Knowledge of parsimonious model and code design is critical for success in this role to ensure model size and run-time are manageable.
- Flexible models – Models must be easily modified and re-purposed to handle different inputs or to address additional questions. Requires understanding of mathematical first principles which are at the core of the modeling techniques.
- Develop, maintain, and run models to analyze energy markets and risk using Python, Excel, or other relevant tools. Examples of models include:
- Energy Market Research and Writing Reports
- Requires an understanding of wholesale energy markets and analysis of renewable energy resources within wholesale markets. An understanding of climate and weather and the relationship to energy use is helpful.
- Must be able to perform independent research, understand the math and the modeling behind the materials that are being researched, and to summarize and present results for internal EGPS work and for third party audiences.
- Draft reports that are relevant to the portion of projects that you have worked on.
- Document findings and keep good records so that research can be supported or replicated at a future date.
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
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
- Ability to self-start and consistently work independently with minimum assistance.
- Strong skills in quantitative and mathematical analysis, decision-making, and problem solving with innovative solutions.
- 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.