Data Engineer Edinburgh, Scotland
Job 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.
WoodMac.com
Wood Mackenzie brand video
We are growing and so we are looking for experienced Data Engineers.
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 SME’s, product and data owners ensuring Wood Mackenzie can deliver a world class experience for its customers, helping them change the way we power our planet.
Main Responsibilities
Working in team of Data Engineers you’ll take full responsibility for writing, testing, and delivering robust pipelines and processes which 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 discreet pieces of work which vary in length from a few days, up to a few months.
Once established in the role we expect you to make incremental improvements to our patterns and processes, so 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 and SQL
- We also have some teams working in other languages such as R and PySpark, if you have proven experience in those then we're 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)
Mentoring from experienced colleagues, and access to online training courses will help you to attain a high level of skill, especially for those who primarily have skills 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.
#LI-JA1
You’ll work directly with stakeholders, often internationally, so it’s essential that you can form a good working relationship with them, understanding what they want and keep them up to date with progress.
Expectations
- Excellent problem solving, and analysis skills coupled with great communication skills and strong attention to detail
- Commitment to excellence and meeting 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, but 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, prioritize, 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.
Additional Information
WoodMackenzie is an equal opportunities employer.
We consider all qualified applicants for employment without regard to 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, including unsolicited resumes sent to a WoodMackenzie business mailing address, fax machine or email address, or directly to WoodMackenzie employees, will be considered WoodMackenzie property. WoodMackenzie will not pay a fee for any placement resulting from the receipt of unsolicited resume.
Consumer Privacy Notice
WoodMackenzie takes your data privacy seriously, please click here to view our privacy notices: Candidate Privacy Notice | Wood Mackenzie | Wood Mackenzie / Candidate Notice - California
#LI-JA1
