

Ampstek
Front Office Assistant [Only W2]
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Front Office Analyst Developer with 5+ years of trading-floor experience, based in Chicago, IL. Contract length is unspecified, with a pay rate of "W2." Key skills include Python, SQL, Power BI, and Agile methodologies.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
March 26, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
Hybrid
-
📄 - Contract
W2 Contractor
-
🔒 - Security
Unknown
-
📍 - Location detailed
Chicago, IL
-
🧠 - Skills detailed
#BI (Business Intelligence) #Dataiku #Plotly #Scala #Microsoft Power BI #Agile #Python #SQL (Structured Query Language) #VBA (Visual Basic for Applications)
Role description
Job Title Front Office Analyst Developer – Trading Analytics Technology (Chicago)
Work Location & Reporting Address Chicago, IL 60606
•
• Hybrid work setup
•
• Job Details:
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.
Detailed Job Description
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.
Thanks and regards
paul
paul@ampstek.com
Job Title Front Office Analyst Developer – Trading Analytics Technology (Chicago)
Work Location & Reporting Address Chicago, IL 60606
•
• Hybrid work setup
•
• Job Details:
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.
Detailed Job Description
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.
Thanks and regards
paul
paul@ampstek.com






