Insight Global
Get AI-powered advice on this job and more exclusive features.
This range is provided by Insight Global. Your actual pay will be based on your skills and experience talk with your recruiter to learn more.
Base pay range
$100,000.00/yr - $120,000.00/yr Direct message the job poster from Insight Global The Middle Office Analyst will be responsible for accurate and consistent production of daily Profit & Loss reports for each of the commodity products traded by the Company This role requires product knowledge, strong quantitative and analytical skills, extreme attention to detail, and advanced Excel skills. Own the daily P&L reporting process, including validation, attribution, and commentary for front office and finance stakeholders. Enter and update trades in the Energy Trade and Risk Management (ETRM) system across various commodity groups and asset classes, including but not limited to Crude Oil, Refined Products, Agricultural Products, Metals, FX, and Equities. Perform daily trade validation and position reconciliation between front office systems (e.g., ETRM) and internal records; work closely with front office, risk, operations, and finance teams to resolve discrepancies promptly. Maintain and update the ETRM system, including book structures, instrument setup, and reference data management. Support month-end and quarter-end close processes, including reserve calculations, valuation adjustments, and coordination with the accounting team. Respond to ad hoc requests and provide market analysis and insights to traders and other stakeholders. Identify and implement process improvements, including automation of recurring tasks using Excel, VBA, Python, or Power BI. Monitor and escalate significant exposure, pricing, or valuation discrepancies impacting risk or P&L. REQUIRED SKILLS AND EXPERIENCE 4+ years of experience in a commodities trading middle office analytics role with a background in accounting and finance, P&L calculation, exposure analysis, and trade support Knowledge of physical oil markets, contracts, pricing, hedging strategies, and industry knowledge Commodities knowledge must include, but not limited to: crude/refined products Experience with ETRM systems and a clear understanding of trade flow processes Bachelor's degree in finance, economics, accounting, or related field Seniority level
Seniority level
Associate Employment type
Employment type
Full-time Job function
Job function
Accounting/Auditing Industries
Oil and Gas and Investment Banking Referrals increase your chances of interviewing at Insight Global by 2x Sign in to set job alerts for Middle Office Analyst roles.
Middle Office / Business Analyst - Aviation
Houston, TX $77,500.00-$131,500.00 1 week ago Greater Houston $85,000.00-$110,000.00 1 week ago Business Analyst - Digital Transformation- Relocate to Saudi Arabia
Houston, TX $50,000.00-$60,000.00 2 weeks ago Houston, TX $50,000.00-$80,000.00 1 month ago The Woodlands, TX $110,000.00-$150,000.00 3 days ago Senior ETRM Business Analyst | Senior ETRM BA
Houston, TX $170,000.00-$200,000.00 1 day ago Business Analyst with Supply Chain (ERP)- Onsite (Full Time)
Power Settlements Analyst, Energy Procurement Operations
Business Analyst - Default Systems and Support - (On - Site)
Analyst, Business Operations Reporting (hybrid)
Business Analyst II - Energy Transition Products
Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
$100,000.00/yr - $120,000.00/yr Direct message the job poster from Insight Global The Middle Office Analyst will be responsible for accurate and consistent production of daily Profit & Loss reports for each of the commodity products traded by the Company This role requires product knowledge, strong quantitative and analytical skills, extreme attention to detail, and advanced Excel skills. Own the daily P&L reporting process, including validation, attribution, and commentary for front office and finance stakeholders. Enter and update trades in the Energy Trade and Risk Management (ETRM) system across various commodity groups and asset classes, including but not limited to Crude Oil, Refined Products, Agricultural Products, Metals, FX, and Equities. Perform daily trade validation and position reconciliation between front office systems (e.g., ETRM) and internal records; work closely with front office, risk, operations, and finance teams to resolve discrepancies promptly. Maintain and update the ETRM system, including book structures, instrument setup, and reference data management. Support month-end and quarter-end close processes, including reserve calculations, valuation adjustments, and coordination with the accounting team. Respond to ad hoc requests and provide market analysis and insights to traders and other stakeholders. Identify and implement process improvements, including automation of recurring tasks using Excel, VBA, Python, or Power BI. Monitor and escalate significant exposure, pricing, or valuation discrepancies impacting risk or P&L. REQUIRED SKILLS AND EXPERIENCE 4+ years of experience in a commodities trading middle office analytics role with a background in accounting and finance, P&L calculation, exposure analysis, and trade support Knowledge of physical oil markets, contracts, pricing, hedging strategies, and industry knowledge Commodities knowledge must include, but not limited to: crude/refined products Experience with ETRM systems and a clear understanding of trade flow processes Bachelor's degree in finance, economics, accounting, or related field Seniority level
Seniority level
Associate Employment type
Employment type
Full-time Job function
Job function
Accounting/Auditing Industries
Oil and Gas and Investment Banking Referrals increase your chances of interviewing at Insight Global by 2x Sign in to set job alerts for Middle Office Analyst roles.
Middle Office / Business Analyst - Aviation
Houston, TX $77,500.00-$131,500.00 1 week ago Greater Houston $85,000.00-$110,000.00 1 week ago Business Analyst - Digital Transformation- Relocate to Saudi Arabia
Houston, TX $50,000.00-$60,000.00 2 weeks ago Houston, TX $50,000.00-$80,000.00 1 month ago The Woodlands, TX $110,000.00-$150,000.00 3 days ago Senior ETRM Business Analyst | Senior ETRM BA
Houston, TX $170,000.00-$200,000.00 1 day ago Business Analyst with Supply Chain (ERP)- Onsite (Full Time)
Power Settlements Analyst, Energy Procurement Operations
Business Analyst - Default Systems and Support - (On - Site)
Analyst, Business Operations Reporting (hybrid)
Business Analyst II - Energy Transition Products
Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr