Front Office Developer
Front Office DeveloperLocation: Chicago, IL 60606 Duration: 12 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 EngineeringBuild 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 CollaborationAct 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 & Skills5 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 SkillsExperience 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 StyleEmpathetic 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.