Senior Risk/MI Data Engineer
- Full time
- London, Greater London, United Kingdom
- Engineering
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.
-
Analyse key user needs and translate them into robust logical and physical data designs and enterprise-class software.
-
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.
-
Work closely with project teams, line manager and development leads to ensure solutions are technically sound, supportable and delivered accurately.
-
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.
-
Contribute to development and BI best practices within Glencore IT, and support and mentor 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.