Software Engineer II

Wood Mackenzie is the global data and analytics business for the renewables, energy, and natural resources industries. Enhanced by technology. Enriched by human intelligence. In an ever-changing world, companies and governments need reliable and actionable insight to lead the transition to a sustainable future. That’s why we cover the entire supply chain with unparalleled breadth and depth, backed by over 50 years’ experience. Our team of over 2,400 experts, operating across 30 global locations, are enabling customers’ decisions through real-time analytics, consultancy, events and thought leadership. Together, we deliver the insight they need to separate risk from opportunity and make confident decisions when it matters most.

WoodMac.com

Wood Mackenzie Brand Video

Wood Mackenzie Values

• Inclusive – we succeed together

• Trusting – we choose to trust each other

• Customer committed – we put customers at the heart of our decisions

• Future Focused – we accelerate change

• Curious – we turn knowledge into action

Job Description 
We are looking for a Data Engineer who can leverage Python to build new data pipelines.  

Your role will sit within an Agile team developing backend data pipelines and processes, aligned to our data roadmap for delivering new features for Wood Mackenzie’s flagship product offering, Lens.  

You will work alongside other Data Engineers, business SMEs, product and data owners to ensure Wood Mackenzie delivers a world-class experience for its customers - helping them change the way we power our planet. 

Main Responsibilities 
As part of a team of Data Engineers, you’ll take full responsibility for writing, testing, and delivering robust pipelines and processes that feed data into Wood Mackenzie’s Lens Platform. Using established patterns with Python, AWS, and a bespoke Data Platform, you’ll be supported to deliver discrete pieces of work ranging from a few days to a few weeks. 

We are particularly interested in candidates who bring experience or a strong interest in leveraging AI tools such as code generation, anomaly detection, or intelligent automation - to improve the efficiency, quality, and scalability of data pipelines and development workflows. 

Once established in the role, we expect you to make incremental improvements to our patterns and processes. We’re looking for someone who has informed opinions on technologies, frameworks, and approaches to delivery. You must be able to articulate ideas effectively and strive to constantly improve deliverables. 

Essential 

• Demonstrable depth of knowledge working with Python 

• Experience working with data, e.g. Pandas, SQL 

• A proactive approach to continuous learning and improvement, including the use of AI tools to support development tasks 

• Mentoring from experienced colleagues and access to training courses will help you attain a high level of skill, especially if your background is in other programming languages 

• We actively encourage and support obtaining formal certification such as those offered by AWS 

Desirable 

• Experience with or a strong interest in applying AI/ML tools to enhance data engineering workflows (e.g. automated testing, code optimization, data quality monitoring, or intelligent alerting) 

• Some R experience, and a willingness to help support a legacy R Shiny application is an advantage but not necessary 

• Familiarity with tools such as GitHub Copilot, AWS AI services, or open-source LLMs for development support 

Mentoring from experienced colleagues and access to training courses will help you attain a high level of skill, especially for those who primarily have experience in other programming languages. 

It’s essential that you’re able to take on the challenge of continuous learning and improvement. We actively encourage and support obtaining formal certification such as those offered by AWS. 

Expectations 

• You’ll work directly with stakeholders, often internationally, so it’s essential that you can form a good working relationship with them, understand what they want, and keep them up to date with progress 

• Excellent problem-solving and analysis skills coupled with great communication skills and strong attention to detail 

• Commitment to excellence and meeting the high-quality standards expected by our clients 

• Experience in working in different delivery methodologies and an understanding of their benefits/constraints 

• We are a hybrid working company and the successful applicant will be expected to be physically present in the Edinburgh office at least 2 days per week to foster and contribute to a collaborative environment, though this may be subject to change in the future 

• Due to the global nature of the team, a degree of flexible working will be required to accommodate different time zones 

Leadership 

• Contribute to a culture of product development where solving problems for our customers is the highest priority 

• Communicate effectively across functions as required 

Collaboration 

• Work in collaboration with team members to perform scoping, estimation, and technology feasibility tasks for the intended solution 

• Manage dependencies among engineering activities and constantly monitor, assess, and control the technical execution 

• Address technical queries and elicit, prioritise, and negotiate changes to requirements and defects 

• Contribute to system and data issue identification and resolution within teams across the organization 

Quality 

• Promote a culture of code quality and continuous improvement 

• Drive the importance of data accuracy from internal and external sources 

Equal Opportunities

We are an equal opportunities employer. This means we are committed to recruiting the best people regardless of their race, colour, religion, age, sex, national origin, disability or protected veteran status. You can find out more about your rights under the law at www.eeoc.gov 

If you are applying for a role and have a physical or mental disability, we will support you with your application or through the hiring process.