Front Office Analyst Developer (Python, SQL)

Job Title: Front Office Analyst Developer (Python | SQL) Work Location & Reporting Address: Chicago, IL 60606 (Hybrid) Long term contract 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. 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 Responsibilities User 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. Top 3 responsibilities you would expect the Subcon to shoulder and execute Business Analysis Data Analysis