Summary
In details, the position encompasses duties and responsibilities as follows:
Glencore is actively looking to recruit a Senior Risk/MI Data Engineer with a passion for data, strong hands-on data engineering capability and strong enterprise Power BI expertise. The role requires a senior, technically strong engineer who can design, build, optimise and support robust data pipelines, data models, curated datasets, reporting layers and analytical solutions that meet demanding business and risk-management needs.
Knowledge of Risk Analytics, ideally gained in the commodity or financial trading sectors, would be beneficial. The successful candidate will be expected to work closely with business users, understand trading and risk processes, translate requirements into scalable technical designs and deliver high-quality data structures, transformations, semantic models and enterprise reporting outputs.
Finally, a solid understanding of agile methodologies including story definition, sprint planning, source control, continuous integration, automated testing and controlled software release procedures would be useful. The candidate should be delivery focused, technically strong and able to mentor colleagues in development standards, code quality, testing discipline and effective solution design.
The ideal candidate disposes of:
Design, develop and support data-centric applications, data models, curated datasets and enterprise reporting solutions across Risk, Compliance, Finance and Operations domains.
Develop complex SQL including views, stored procedures, transformations, aggregations and performance-tuned queries, and build robust data engineering solutions that underpin reporting, analytics and MI.
Design and maintain enterprise Power BI solutions including semantic models / datasets, dashboards, reports, DAX measures, refresh strategies, security controls and performance optimisation.
Design and develop applications using agreed coding standards, naming conventions, version control disciplines and quality targets, with strong focus on maintainability and reuse.
Participate in code reviews, unit testing, system testing and release activities, with strong focus on data quality, reconciliation, report accuracy and production stability.
Investigate defects, perform root-cause analysis and optimise existing SQL workloads, data models and Power BI solutions for performance, scalability and reliability.
Skills
Strong track record of data analysis, data modelling, technical design and delivery, preferably in a physical commodity trading environment.
Practical grounding in data engineering, including transformation logic, dataset design, performance optimisation, data quality controls and supportable production solutions.
Excellent SQL knowledge, including complex joins, CTEs, stored procedures, window functions, query tuning and troubleshooting, with strong understanding of both relational and dimensional models.
Enterprise Power BI knowledge including semantic model / dataset design, DAX, Power Query, report and dashboard design, drill-through, row-level security, gateway / refresh management and performance tuning.
Good understanding of enterprise BI governance, data quality controls, reconciliation, testing approaches and production support in data-driven environments.
Education
Three+ years' hands-on experience using Power BI in enterprise environments, including semantic models, DAX, Power Query, security, refresh management and performance optimisation.
