remote
Senior Associate - Data Analyst - Macquarie Group
Data Analyst
Senior Data Analyst supporting a global commodities credit team, delivering high‑quality data pipelines, analytical reports, and visualisations using SQL, Python and BI tools to drive risk‑aware decision making.
About the role
Key Responsibilities
- Design, develop, and maintain automated data pipelines and ETL processes to consolidate commodity trade and credit data from multiple sources.
- Create and enhance interactive dashboards and visual reports in Tableau and Power BI for senior stakeholders across EMEA and North America.
- Perform ad‑hoc data analysis and statistical modeling in Python to identify credit risk trends and support trading decisions.
- Collaborate with traders, risk managers, and technology teams to define data requirements, ensure data quality, and implement reporting standards.
- Document data lineage, data dictionaries, and reporting procedures to facilitate auditability and regulatory compliance.
Requirements
- 3+ years of experience in data analysis or business intelligence within financial services or commodities markets.
- Strong proficiency in SQL for data extraction, transformation, and complex query development.
- Hands‑on experience with Python (pandas, NumPy) for data manipulation and statistical analysis.
- Demonstrated ability to build compelling visualisations and dashboards using Tableau or Power BI.
- Understanding of credit risk concepts and ability to translate analytical insights into actionable recommendations.
Skills
sqlpythontableaupower bi