Senior Risk/MI Data Engineer

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. 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:

• Designing, developing and supporting data-centric applications, data models, curated datasets and enterprise reporting solutions across Risk, Compliance, Finance and Operations domains.
• Analysing key user needs and translating them into robust logical and physical data designs and enterprise-class software.
• Developing complex SQL including views, stored procedures, transformations, aggregations and performance-tuned queries, and building robust data engineering solutions that underpin reporting, analytics and MI.
• Designing and maintaining enterprise Power BI solutions including semantic models/datasets, dashboards, reports, DAX measures, refresh strategies, security controls and performance optimisation.
• Working closely with project teams, line manager and development leads to ensure solutions are technically sound, supportable and delivered accurately.
• Designing and developing applications using agreed coding standards, naming conventions, version control disciplines and quality targets, with strong focus on maintainability and reuse.
• Participating in code reviews, unit testing, system testing and release activities, with strong focus on data quality, reconciliation, report accuracy and production stability.
• Investigating defects, performing root cause analysis and optimising existing SQL workloads, data models and Power BI solutions for performance, scalability and reliability.
• Contributing to development and BI best practices within Glencore IT, and supporting and mentoring other developers across the development lifecycle.

Skills:

• A business-oriented, data-centric individual with the ability to build credibility with the business and distil complex requirements into executable technical designs.
• Senior engineer delivering robust enterprise-wide data and reporting solutions as part of a scrum team, with strong SQL-led data engineering capability and strong enterprise Power BI capability.
• 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.
• Exposure to Sybase/SAP IQ would be highly beneficial.
• Ability to work closely and independently with end users, while maintaining strong technical judgement on solution design, data integrity and reporting usability.
• Good understanding of enterprise BI governance, data quality controls, reconciliation, testing approaches and production support in data-driven environments.
• Technical expertise across the development lifecycle to include functional requirements, data mapping, dimensional modelling and system design specifications.
• Test case preparation, execution, defect triage and reconciliation of outputs.
• Setup of development environments, including source code and version control.
• Software build, release and deployment procedures, including controlled promotion of BI and reporting changes.

Education:

• Educated to Degree-level (or equivalent), as a minimum requirement.
• Minimum of five years' experience with SQL development/data engineering, preferably Sybase iQ, including optimisation of complex reporting and analytical logic.
• Three+ years' hands-on experience using Power BI in enterprise environments, including semantic models, DAX, Power Query, security, refresh management and performance optimisation.