Our client, a commodities trading company, is seeking a business analyst strong in data analytics and familiar with front office environments.
Job Description
Position Description:The Market Data Business Analyst will report to the Lead IT Business Analyst within the Data Team in the IT Department. The company is investing in Data and Analytics to enable a more data-driven approach to commercial decision-making, risk management, and operations. As part of this initiative, the Data Team is delivering a modern data platform using Azure Databricks, providing new capabilities across the business, including:
- A central warehouse of trade, valuation, and risk data
- A central hub for sharing market fundamentals for commodity markets
- Pipelines for scraping, ingesting, and analyzing internal, public, and licensed data
- Processes and tools for data governance and discovery
- A reporting tool for EOD P&L Attribution
- Analytics and visualization tailored to business user needs
Responsibilities:
Business Analysis for Small Changes and Projects:
- Understand and prioritize user needs, creating prototypes, worked examples, or mock-ups to clarify functional requirements
- Perform system or data analysis to define system requirements
- Design and implement reports and solutions to fulfill functional and system requirements
- Document user requests and system changes in JIRA
- Collaborate with the IT team to breakdown, design, and estimate changes
- Act as Product Owner in agile delivery teams
- Perform testing and run UAT
- Support release planning and go-live
- Create user documentation and provide training
- Assist users in setting up and using the Data platform
- Support end-users by explaining key datasets and analyzing data with tools such as DataBricks, SQL, Python (Pandas, pySpark), and PowerQuery
- Help users access data in end-user tools like Python, Excel, or PowerBI
- Create Power BI datasets and dashboards to visualize data
- Create DataBricks Notebooks to process and visualize data
- Deliver reports or analytics using source control and CI/CD pipelines
- Build relationships with Data Owners in the business
- Coordinate and administer data governance processes
- Support role-based access control across different components
- Maintain data catalogues
- Document and communicate platform capabilities and data catalogue updates
- Assist users in finding data and using self-service data discovery tools
- Conduct periodic reviews of data usage and access control, recommending changes as needed
- Enhance data governance processes and tools
Qualifications:
- Bachelor's degree in a numerate subject or equivalent professional qualification
- 5 years' experience as an IT Business Analyst, Analyst Developer, or Front Office/Middle Office Analyst within a trading house, investment bank, or through a tier-1 vendor/consultancy
- Experience in a Commodities Trading business and working with an ETRM application (e.g., Allegro, Endur, Aspect) and data (e.g., trade, operations, market data, valuation, and risk)
- Proficiency with data analysis and BI tools (e.g., SQL, PowerQuery, Excel, Python, DataBricks, SnowFlake, Power BI, Tableau)