Data Engineer

Company Description

Wood Mackenzie is a worldwide business specializing in research, analytics, and consultancy within the natural resources industry. For 50 years, we have been offering data, analytics, and insights of superior quality that our clients count on for formulating their decisions.

We have committed teams covering the oil, gas & LNG, power & renewables, chemicals, metals & mining sectors positioned globally, performing a range of projects stemming from our assessment and valuation of thousands of individual assets, companies, and economic indicators, such as demand, supply, and trends in market price.

We employ over 1,900 individuals in 30 different locations, serving clients across almost 80 countries. Collectively, we spark innovation and are a source of inspiration within the markets we cater to – providing crucial intelligence to assist our customers in overcoming the most challenging obstacles, and crafting strategic decisions that will ultimately propel the world towards a more sustainable future.

Job Description

We are expanding and thus, are in search of seasoned Data Engineers.

In this role, you will be part of an Agile team that develops backend data pipelines and processes, in line with our data roadmap for unveiling new features for Wood Mackenzie’s flagship product, Lens. You will collaborate with other Data Engineers, business SMEs, product and data owners to ensure that Wood Mackenzie can offer a top-tier experience to its clients, helping them transform the way we power our planet.

Main Responsibilities

As part of a team of Data Engineers, you will be fully responsible for writing, testing, and delivering robust pipelines and processes which supply data to Wood Mackenzie’s Lens platform. Using established patterns with Python, AWS and a bespoke Data Platform, you will receive support to deliver discrete pieces of work that range in duration from a few days to a couple of months.

Once you are settled in the role, we expect you to make incremental enhancements to our patterns and processes, so we are in search of someone who has well-formed opinions on technologies, frameworks, and delivery approaches. You must be able to succinctly articulate ideas and constantly strive to better deliverables.

Essential

• Demonstrable depth of knowledge working with Python and SQL
• We also have some teams working in other languages such as R and PySpark. If you have proven experience in these, we would be interested to hear from you but it's not required for our other roles
• Proven experience with SQL and NoSQL databases (e.g. Postgres / DynamoDB)
• Working knowledge with modern ETL tools (e.g. AWS Glue, AWS Step Functions, SNS, SQS etc.)
• Working knowledge of continuous delivery and approaches to continuous integration (Jenkins, Docker, CDK/Cloudformation/Terraform)

Guidance from experienced colleagues, alongside access to online training courses, will help you to achieve a high level of expertise, especially for those whose skills are primarily in other programming languages. It’s essential that you’re keen to face the challenge of continuous learning and improvement. We actively support and encourage the acquisition of formal certification such as those offered by AWS.

#LI-JA1

Qualifications

You will interact directly with stakeholders, often on an international level, so it’s crucial that you can establish a strong working relationship with them, understand their requirements, and keep them updated on the progress.

Expectations

• Excellent problem-solving and analysis skills, superb communication skills, and meticulous attention to detail
• Commitment to excellence and adhering to the high-quality standards expected by our clients
• Experience of working in different delivery methodologies and understanding of their benefits and constraints
• We are a hybrid working company and the successful candidate will be expected to be physically present in the Edinburgh office at least 2 days per week to promote and contribute to a collaborative environment, although this could change in the future.
• Because of the international nature of the team, some degree of flexible working will be required to accommodate different time zones.

Leadership

• Contribute to a culture of product development where solving our customers' problems is the highest priority.
• Effectively communicate across functions as needed.

Collaboration

• Work collaboratively with team members to carry out scoping, estimation, and technology feasibility tasks for the intended solution.
• Manage interdependencies among engineering activities and continually monitor, assess, and control the technical execution.
• Address technical queries and draw out, prioritize, and negotiate changes to requirements and defects.
• Contribute to the identification and resolution of system and data issues within teams across the organization.

Quality

• Promote a culture of code quality and continuous improvement.

• Emphasize the importance of data accuracy from both internal and external sources.

Additional Information

WoodMackenzie is an equal opportunities employer.

We consider all qualified applicants for employment irrespective of race, religion, color, national origin, citizenship, sex, gender identity and/or expression, sexual orientation, veteran’s status, age, or disability.

https://www.woodmac.com/careers/jobs/

Unsolicited resumes sent to WoodMackenzie, comprised of unsolicited resumes sent to a WoodMackenzie business postal address, fax machine or email address, or directly to WoodMackenzie employees, will be deemed property of WoodMackenzie. WoodMackenzie will not pay a fee for any placement resulting from the receipt of an unsolicited resume.

WoodMackenzie takes your data privacy very seriously, please click here to view our privacy notices: /

#LI-JA1