Front Office Developer

Role 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. 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.

Title: Front Office Developer
Location: Chicago, IL 60606
Duration:12 Duration

Role 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.

Key Responsibilities:

• 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 experience
• 8-10 years