Front Office Analyst Developer

Location: Chicago, IL
Job Type: Contract
Contract Duration: 12 Months
Experience Required: 8–10 Years
Job Description

We are seeking an experienced Front Office Analyst Developer to support trading analytics, business analysis, data analysis, and front-office technology initiatives.

The candidate will work closely with commercial trading teams and global technology teams to enhance analytical workflows, develop automation solutions, improve product adoption, and translate business requirements into effective technical solutions.

Key Responsibilities

• Gather, analyse, and document business requirements from trading and front-office stakeholders.

• Develop, enhance, and maintain Excel VBA-based analytical tools and workflow automation solutions.

• Extract, analyse, and interpret large datasets using SQL and analytics platforms.

• Work with pricing data, forward curves, market fundamentals, and market analytics.

• Develop dashboards, reports, and visualisations using Power BI.

• Integrate data from APIs, internal data marts, and enterprise platforms.

• Reverse-engineer existing spreadsheets and improve the reliability and maintainability of analytical workflows.

• Support user onboarding, training, and adoption of analytics products.

• Collaborate with global technology teams to communicate user feedback and drive workflow improvements.

• Prepare functional documentation, workflow specifications, and acceptance criteria.

• Participate in Agile ceremonies and collaborate with analysts, developers, and product owners.

Primary Skills

• Excel VBA Development – Strong hands-on expertise in spreadsheet automation and analytical tools.

• Business Analysis – Requirements gathering, process analysis, and stakeholder management.

• Data Analysis – Data extraction, interpretation, validation, and visualisation.

• SQL – Query development and analysis of large datasets.

• Trading Analytics – Understanding of front-office trading workflows and analytical applications.

• Power BI – Dashboard development, reporting, and data visualisation.

Secondary Skills

• Energy and commodities trading analytics.

• Price curves, market fundamentals, and supply/demand analysis.

• Commodity risk systems and trading analytics platforms.

• Dataiku and enterprise analytics tools.

• APIs, data integration, and data pipelines.

• ETL processes and workflow orchestration.

• AWS, SQL Server, and cloud-based analytics.

• Excel add-ins and spreadsheet modernisation.

• Agile methodologies and product development.

• User training, product adoption, and stakeholder engagement.

Required Qualifications and Experience

• 8–10 years of relevant professional experience.

• At least 5 years of hands-on trading-floor experience in analytics, risk, or front-office technology.

• Strong proficiency in Excel VBA development.

• Practical experience with SQL and large-scale data analysis.

• Experience developing dashboards and reports using Power BI.

• Familiarity with APIs and integration of multiple data sources.

• Experience in energy or commodities trading environments.

• Bachelor's degree in Engineering, Mathematics, Computer Science, Finance, or another quantitative discipline.

Preferred Candidate Profile

• Strong analytical, problem-solving, and technical skills.

• Excellent communication and stakeholder management capabilities.

• Ability to work effectively with business users and global technology teams.

• Proactive approach to identifying and implementing workflow improvements.

• Comfortable working in a fast-paced trading environment with changing priorities.

• Strong ownership, documentation, and user-support capabilities.