Consultant | Energy Oil & Gas - Midstream | Etrm - Products

Ipolarity LLCChicago, IL

Apply with Sonara

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.¹

Reclaim your time by letting our AI handle the grunt work of job searching.

We continuously scan millions of openings to find your top matches.

Overview

Remote

On-site

Job Description

Job Title Front Office Analyst Developer Trading Analytics Technology (Chicago)Work Location & Reporting Address Chicago, IL 60606Vendor Rate $480.00/dayContract duration 12Target Start Date 01 Jul 2026Role Summary:We are seeking an experienced Front Office Analyst Developer with at least 5+ years of trading-floor experience to act as the primary bridge between our commercial trading desks in Chicago (and Houston) and our global Trading Analytics Technology teams in London and Pune.This role is critical in driving product adoption, supporting front-office analytics workflows, gathering user feedback, and ensuring our trading teams are equipped with the tools and training they need. You will combine strong analytical and engineering skills with excellent user interaction, product evangelism, and stakeholder management.To maintain strong trading-floor presence, this is an office-based role Monday Thursday every week.---Key ResponsibilitiesUser Enablement & Product Adoption Become a super-user of Trading Analytics technology products and platforms, with deep knowledge of their capabilities, limitations, and best-practice workflows. Deliver structured training, onboarding sessions, refreshers, and tailored coaching to Chicago and Houston users. Promote upcoming features, releases, and enhancements, ensuring the front office understands and adopts new capabilities. Serve as the first point of contact for high-touch trading workflows, escalating appropriately to global technology teams.Front Office Analysis & Light Engineering Build small-scale analytical utilities and workflow enhancements using Python, Excel/VBA, and SQL. Pull, analyse, and visualise large data sets including price, forward curves, fundamentals, and market data via SQL, Dataiku, APIs, and internal marts. Create dashboards and analytical tools using Power BI, Plotly, and other visualisation frameworks. Reverse-engineer existing spreadsheet logic and help migrate critical workflows into more stable, maintainable solutions. Build lightweight integration utilities between local tools and global technology platforms and products.Cross-Location Collaboration Act as Chicago s representative to global product teams in London and Pune, building a strong network of engineers, analysts, and product owners. Provide clear, structured feedback on user demand, pain points, and workflow gaps to influence the product roadmap. Participate in agile ceremonies stand-ups, planning, refinement to help translate user needs into actionable requirements. Document workflows, solution approaches, design sketches, and acceptance-criteria evidence.---Essential Experience & Skills 5+ years of hands-on trading-floor experience in analytics, risk, or front-office technology. Background in energy or commodities trading, with understanding of price data, curves, fundamentals, and market analytics. Strong working knowledge of Python (essential). Practical experience with Excel/VBA, SQL, and large-scale data sets. Experience with Power BI, Plotly, and ideally Dataiku. Familiarity with APIs, data pipelines, and integrating multiple data sources. Strong communication, relationship-building, and stakeholder management skills. Comfortable operating in a fast-paced front-office environment with frequent context switching. Degree in a quantitative or analytical discipline (e.g., Engineering, Maths, CS, Finance).---Desirable Skills Experience in commodity trading analytics, supply/demand modelling, or risk systems. Exposure to ETL concepts and workflow orchestration. Awareness of AWS, SQL Server, or cloud-based analytics platforms. Experience with Excel add-ins is useful but not required.---Personality & Working Style Empathetic communicator with strong rapport-building capability trusted by traders and technologists alike. Curious, proactive, and solution-oriented with a strong sense of ownership. Thrives in a hybrid role spanning training, analysis, support, and light engineering. Confident representing Chicago s needs to global product groups.Minimum years of experience8-10 yearsCertifications Needed :NoTop 3 responsibilities you would expect the Subcon to shoulder and executeBusiness AnalysisData AnalysisInterview Process (Is face to face required?) No

Project Code: Analytics OE TSD 2026

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.

Apply with Sonara Apply manually

FAQs About Consultant | Energy Oil & Gas - Midstream | Etrm - Products Jobs at Ipolarity LLC

What is the work location for this position at Ipolarity LLC?

This job at Ipolarity LLC is located in Chicago, IL, according to the details provided by the employer. Some roles may also include multiple work locations depending on the requirement.

What pay range can candidates expect for this role at Ipolarity LLC?

Employer has not shared pay details for this role.

What employment applies to this position at Ipolarity LLC?

The employer has not provided this information. This may be discussed during the hiring process.

What is the process to apply for this position at Ipolarity LLC?

You can apply for this role at Ipolarity LLC either through Sonara's automated application system, which helps you submit applications 10X faster with minimal effort, or by applying manually using the direct link on the job page.