Verisk
Data Engineer
Job Description
Company Description
Wood Mackenzie are the global research, analytics, and consultancy business powering the natural resources industry. For 50 years, we have been providing the quality data, analytics, and insights our customers rely on to inspire their decision making.
Our dedicated oil, gas & LNG, power & renewables, chemicals, metals & mining sector teams are located around the world and deliver a variety of projects based on our assessment and valuation of thousands of individual assets, companies, and economic indicators such as market supply, demand, and price trends.
We have over 1,900 employees in 30 locations, serving customers in nearly 80 countries. Together, we inspire and innovate the markets we serve – providing invaluable intelligence to help our customers overcome the toughest challenges, and make strategic decisions that will, ultimately, accelerate the world’s transition to a more sustainable future.
Wood Mackenzie is the global leader in data, analysis and consulting across the energy, chemicals, metals, mining, power and renewables sectors.
Hear what our team has to say about working with us:
https://www.woodmac.com/careers/our-people/
Job Description
An exciting opportunity to be part of a cutting-edge enterprise data platform rollout at a global energy research and consulting company. You will be working alongside Data Engineers, Data Analysts and Business Professionals to design, build and deliver an integrated and holistic reporting and analytics solution.
Main Responsibilities
- Design, develop and maintain efficient and accurate ETL pipelines.
- Requirements Analysis – evaluate and analyse business requirements gathered to gain a clear understanding of the specification and reason for the request.
- Analyse business rules and processes defining relationships between separate data sources as required.
- Combine data from multiple sources into efficient Power BI datasets for use by departmental Data Analysts.
- Develop and maintain knowledge of our Data Lake and core applications, and the functionality they provide, to analyse and meet Business Intelligence requirements.
- Report Developer Support.
#LI-MS1
Qualifications
- 3-5 years’ experience working with AWS serverless architecture, specifically Glue, Athena and Lambda.
- Advanced understanding of SQL, Python, Spark and data munging.
- Understanding of Data Warehouse and modern Lake House Architecture. Including Kimball data warehouse concepts.
- Experience working on the design, development, and optimisation of Power BI Datasets.
- Relevant formal qualification in Business / Computer Science / Information Systems or equivalent relevant work experience
- Advanced understanding of SQL, Python, Spark and data munging.
- Advanced Data modelling, and ETL concepts.
- Strong technical skills and attention to detail.
- Strong communication, consultation, and interpersonal skills to support business requirements.
- Experience of Data Analytic Expressions (DAX).
- Experience using third party PBI tools such as DAX Studio, Tabular Editor, etc.
- Exposure to Agile Development practices would be an advantage.
Expectations
- We are a hybrid working company and the successful applicant will be expected to be physically present in the office at least 2 days per week to foster and contribute to a collaborative environment, but this may be subject to change in the future
Additional Information
Wood Mackenzie is a place where we are committed to supporting our people to grow and thrive. We value different perspectives and aspire to create an inclusive environment which encourages diversity and fosters a sense of belonging.
Wood Mackenzie values everyone’s contribution and helps them reach their full potential while sustaining an organisational culture of health and well-being.
Our core values are:
- Inclusive
- Trusting
- Customer Committed
- Future Focused, and
- Curious
We understand the importance of bringing your whole self to work and to achieving balance between work, family and other life commitments. We are open to considering flexible working arrangements to enable the greatest spectrum of talent to contribute to Wood Mackenzie’s success.
Hear what our team has to say about working with us: https://www.woodmac.com/careers/our-people/
