Job Description
We are looking for a brilliant UK based Data Engineer to join the team to help us by expanding and optimising our data and data pipeline architecture, as well as optimising data flows and collection for cross functional teams. Reporting into the Head of Data and Analytics, the Data Engineer will work alongside our software engineers and Data & Analytics team (data analysts, business analyst) providing a foundation for analysts and scientists to provide insights to the departments and leadership team. Working under the guidance of our data initiatives ensuring optimal data delivery and architecture is consistent throughout ongoing projects. The role requires experience in AWS data pipeline building from the ground up, and optimising data architecture to support the next generation of projects and data initiatives along with working on Snowflake and Tableau data(sets) to deliver the evolving needs of the Data & Analytics department.
About Natwest Rooster Money
Natwest Rooster Money is a pocket money app and prepaid debit card that helps parents teach their kids the value of money in a digital age. Simple, progressive and gameful, we bring to life all the sound traditional financial principles we were brought up with (or wish we were!) and make managing money smart, fun & relevant for the modern world.
We believe the world would be a better place if we all talked about money a little earlier on in life. Research shows that our money habits are formed by the age of seven. That’s a pretty amazing opportunity to help give kids a head-start in building habits that will stick with them for life.
We operate a remote first culture, but make time to all get together every couple of months.
Why Natwest Rooster Money?
Hundreds of thousands of families have downloaded the Natwest Rooster Money app since our launch in January 2016.
We have been featured in The Times, Telegraph, Guardian, Financial Times to name a few. We’ve been on the BBC and are considered experts in our field.
In addition to our Tracker, we offer the Rooster Card, a prepaid Visa card for kids with parental controls. We are scaling rapidly which offers lots of scope to grow for anyone joining the company.
Natwest Rooster money became part of the Natwest Group in October 2021. With the backing of Natwest, one of the UK’s largest high street banks, we can help even more parents and children build their financial confidence and capability. The vision of Natwest aligns strongly with our own and their commitment to improving financial capability matches our shared passion for helping to teach children about money. This offers exciting opportunities for both our staff and customers.
Requirements
We are looking for someone who can:
- Maintain optimal data pipeline architecture
- Connect into new sources of data and assemble large, complex data sets that meet functional/non-functional business requirements
- Maintain data set integrity through changes in development and business processes
- Identify and implement internal process improvements: automating manual processes, optimising data delivery, re-designing infrastructure for greater scalability.
- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Python, SQL and AWS ‘big data’ technologies
- Work with stakeholders across all business departments to assist with data-related technical issues and support their data infrastructure needs
- Keep our data separated and secure across data silos and AWS buckets
- Create datasets for analytics and data scientist team members that assist them in building and optimising our product into an innovative industry leader
- Work with data and analytics experts to strive for greater functionality in our data systems
- Create and maintain infrastructure for secure and efficient data-sharing internally and with external partners
- Work with and optimisation of tools, platforms and services utilised throughout the data pipeline
- Implement data engineering best practices, and enterprise data governance standards
- Champion ETL tools and Python within the team
- Maintain an up to date Data Dictionary – enabling consistent data
With previous proven experience and strong skills in the following:
- Experience in AWS Glue (Apache Spark) or EMF, S3, Lake Formation
- Data Transformation Optimisation
- Snowflake
- Data Controls and Management
- Connecting Structured and Unstructured Databases to extract data to a Lake
- Python – Transformation – PySpark / Pandas
We will provide you with an in depth induction to get you up and running, familiar with our processes and people. You will work remotely but should be expected to attend meetings in London and Bristol and when required.. We are a small team so a good cultural fit and understanding our remote working culture is really important.
Benefits
- Work with a fun, passionate team building something awesome
- Competitive salary, generous pension and benefits allowance
- Regular team get-togethers and social events in London, Bristol and Edinburgh
- Fully remote working