What are the responsibilities and job description for the Market Risk Analyst II position at Mitsui?
Department/Division: Market Risk Team / Middle Office Division
Location: Houston, TX
Reports Directly To: Risk Director
FLSA Status: Exempt
SUMMARY:
The Market Risk Analyst II position involves monitoring and managing financial risks associated with trading portfolios. Key responsibilities include calculating and reporting daily profit and loss (P&L) metrics driven by price fluctuations, analyzing market exposures, assessing Value at Risk (VaR), enhancing existing reporting models, and developing new models to support evolving commercial activities. The role also includes preparing monthly realized profit summaries and ensuring accurate reconciliation between net earned results and accounting records. Strong analytical, technical and communication skills are essential for success in this role, as it requires interpreting complex financial data and effectively presenting findings to stakeholders.
ESSENTIAL FUNCTIONS & RESPONSIBILITIES:
- Calculate and report daily Position and P&L associated with power trading activities.
- Analyze P&L drivers and provide detailed explanations regarding portfolio changes.
- Develop tools to enhance analysis and improve processes.
- Monitor risk using VaR calculations and periodic stress testing.
- Model complex new trading activities in the reporting processes as well as in our ETRM (Allegro).
- Provide pricing support and backup for the settlements team as needed.
- Perform monthly realized profit reporting as well as net earned to accounting reconciliations.
- Collaborate with Front office, Credit, Confirmations, Settlements and Accounting teams as needed.
QUALIFICATIONS:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Advanced excel skills with the ability to utilize analysis driven functions such as sumifs, vlookups, index match/xlookup and pivot tables.
- Proven ability to analyze data and identify variances between 2 datasets.
- Proven ability to understand and explain complex concepts.
- Proven ability to effectively and clearly communicate with various levels across an organization.
- Proven ability to develop and implement excel models.
- Knowledge of programming languages such as Python, VBA, SQL, R.
- Knowledge of physical and financial commodity trading concepts such as exposures, pricing and hedging.
- Experience working within an ETRM system such as Allegro, Openlink Endur or RightAngle.
DESIRED SKILLS & ABILITIES:
- Proven experience utilizing quantitative tools and analysis techniques, including Monte Carlo simulations.
EDUCATION & EXPERIENCE:
- Bachelors Degree required, masters degree preferred; focus on Finance, Mathematics, Economics, Engineering, Computer Science, or another relevant field.
- 2-4 years experience in an analytical role in the power energy trading industry.
LANGUAGE SKILLS:
- Fluent verbal and written skills in English.
LICENCES, CERTIFICATES, REGISTRATIONS:
- Series 3 or FRM preferred but not required
WORK ENVIRONMENT & PHYSICAL DEMANDS:
This job operates in a professional office environment and routinely uses standard office equipment such as computers, phones, photocopiers, and filing cabinets. Physical demands include:
- Prolonged periods of sitting and may need to routinely move around to communicate with different groups
- Occasionally work late to meet with Tokyo office
- Must be able to lift up to 15 pounds at times.
- Must have a valid DL.
Benefits & Perks
- Medical, Dental, Vision benefits
- 401K and Company Match
- Tuition Reimbursement
- Generous PTO Policy
- Breakroom Snacks / Beverages
Position Competencies
- Job Knowledge
- Analytical Skills
- Dependability
- Reporting
- Attention to detail
- Problem Solving
- Creativity
Disclaimer:
This position description is not to be construed as an exhaustive statement of duties, responsibilities, or requirements. Employees may be required to perform any other job-related instructions as requested by their leader, subject to reasonable accommodation.
MEMS is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disabili