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.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, and gender identity), national origin, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.
We are committed to providing reasonable accommodations to qualified applicants with disabilities and for sincerely held religious beliefs, as required by applicable law. Applicants who require a reasonable accommodation during the hiring process may request assistance.
Employment may be contingent upon the successful completion of job-related pre-employment screening, which may include background and reference checks and, where permitted by applicable law and applicable to the position, drug testing. All such screening will be conducted in accordance with applicable federal, state, and local laws.
