Senior Data Engineer
Salary - £70-80k with 15% bonus
Hybrid working – couple of days in the office
City of London
We are looking for:
- Good understanding of data engineering principles
- A good technical grasp of Snowflake and automating it, and transforming complex datasets
- SnowPro core certification.
- AWS Skillset
- Delivery experience
- Building solutions in snowflake
- Insurance experience – advantageous but not necessary
Key Responsibilities:
- Lead the design and implementation of Snowflake [and Redshift] based data warehousing solutions within an AWS environment
- Mentoring of team members through code reviews and pair programming
- Build and support new AWS native cloud data warehouse solutions
- Develop and optimize ETL processes using AWS services (e.g. AWS Glue, Lambda) to ensure efficient data ingestion, transformation, storage, and cost optimization.
- Deliver data to presentation layers to power reporting and analytics
- Collaborate with stakeholders, product owners, and developers
- Create and maintain data models that serve as a foundation for reporting and analytics
- Monitor performance metrics and troubleshoot issues within the data architecture, ensuring optimal health and efficiency.
Skills and Experience:
- Bachelor’s degree or higher in a technical discipline
- Proven experience as a data engineer with a strong focus on Snowflake and AWS services in large-scale enterprise environments
- Extensive experience in AWS services, e.g. EC2, S3, RDS, DynamoDB, Redshift, Lambda, API Gateway
- Strong SQL skills for complex data queries and transformations
- Python programming for data processing and analysis is a plus
- Strong acumen for application health through performance monitoring, logging, and debugging
- AWS or Snowflake certifications are a plus