Senior AWS Data Engineer

With Intelligence; City Of London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading data solutions company based in London is looking for a Data Engineer to design and maintain scalable data architectures and ETL pipelines. The ideal candidate will have proven experience in data engineering, proficiency in Python and SQL, and expertise in AWS and database technologies. The role offers a hybrid working model and various benefits including enhanced parental leave and wellness days.

Benefits

24 days annual leave rising to 29 days

Enhanced parental leave

Health Cash Plans

Wellness Days

Flexible Fridays

Employee assistance program

Travel loan scheme

Travel loan scheme

Charity days

Breakfast provided

Social Events throughout the year

Qualifications

• Proven experience in data engineering and building scalable data solutions.
• Strong experience with ETL processes, data modelling, and data warehousing.
• Expertise in relational (SQL) and NoSQL database technologies.

Responsibilities

• Design, develop, and maintain scalable data architectures and ETL pipelines.
• Build and manage data models and data warehouse solutions.
• Integrate data from internal and third-party APIs and services.

Skills

Data engineering

ETL processes

Python

SQL

AWS

Data security principles

Data modelling

Collaboration skills

Tools

Airflow

dbt

Redshift

Git

Job description

What You’ll Do

• Design, develop, and maintain scalable data architectures and ETL pipelines
• Build and manage data models and data warehouse solutions (we use Airflow, dbt, and Redshift)
• Write clean, efficient Python and SQL code for data processing and transformation
• Integrate data from internal and third-party APIs and services
• Optimise data pipelines for performance, scalability, and reliability
• Collaborate with data scientists, analysts, and engineering teams to support business needs
• Implement and uphold data security and compliance standards
• Use version control systems (e.g. Git) to manage and maintain project codebases
• Contribute to the continuous improvement of data processes and tooling across the organisation

Qualifications

• Proven experience in data engineering and building scalable data solutions
• Strong experience with ETL processes, data modelling, and data warehousing
• Proficiency in Python and SQL
• Expertise in relational (SQL) and NoSQL database technologies
• Hands-on experience with AWS
• Solid understanding of data security, privacy, and compliance principles
• Ability to optimise data pipelines for performance and maintainability
• Strong collaboration skills and a proactive, problem-solving mindset

Bonus Points

• Experience with Airflow and/or dbt
• Experience working in Agile environments (Scrum/Kanban)
• Exposure to DevOps practices or CI/CD pipelines

Benefits

• 24 days annual leave rising to 29 days
• Enhanced parental leave
• Medicash (Health Cash Plans)
• Wellness Days
• Flexible Fridays (Opportunity to finish early)
• Birthday day off
• Employee assistance program
• Travel loan scheme
• Charity days
• Breakfast provided
• Social Events throughout the year
• Hybrid Working

Our Company

With Intelligence is based at One London Wall, London EC2Y 5EA. We offer amazing benefits, free breakfast daily and drinks provided all day, every day. We actively encourage social networks that oversee activities from sports, book reading to rock climbing, that you are free to join.

As part of our company, you will enjoy the benefits of an open plan office and working with a social and energetic team. With Intelligence provides exclusive editorial, research, data and events for senior executives within the asset management industry. These include hedge funds, private credit, private equity, real estate and traditional asset management, and our editorial brands are seen as market leaders in providing asset manager sales and IR execs with the actionable information they require to help them raise and retain assets. To maintain and grow our position in the market we need to continue to hire highly motivated, thoughtful and to ensure our subscribers are getting the exclusive intelligence they need first, and most comprehensively, through our range of services. If you are interested so far in what you have read, please apply, we look forward to hearing from you.

We are an Equal Opportunity Employer. Our policy is not to discriminate against any applicant or employee based on actual or perceived race, age, sex or gender (including pregnancy), marital status, national origin, ancestry, citizenship status, mental or physical disability, religion, creed, colour, sexual orientation, gender identity or expression (including transgender status), veteran status, genetic information, or any other characteristic protected by applicable law.