Senior AWS Data Engineer

Senior AWS Data Engineer

ABOUT RAPP

RAPP is a digital transformation business. We help our clients to invent a new future for their marketing through data and technology. We work at the intersection of technology, marketing, data, media and user experience.

We offer our clients services in Transformation Consultancy, Data Engineering, Customer Experience Management technologies and Marketing Technology.

Our key clients include Best Western, Christie’s, Jaguar Land Rover, Mercedes-Benz, and Just Giving.

RAPP is the data and technology division of Omnicom Precision Marketing Group (OPMG) and provides technology and data innovation.

Culturally, Code is an innovative, fast moving, exciting, occasionally demanding place to work.

YOUR ROLE

We want to make sure that RAPP is the first choice for customers for marketing solutions and customer communications. It’s our goal to be seen as the best in class for technical innovation – and the company that delivers a great customer experience for our clients’ customers.

This role sits within the data & technology arm of our business, specifically within the Tech Delivery team.

This role is highly technical and hands-on capable and involves delivering solutions independently and at very high standard.

RAPP delivers large scale back end database solutions & implements multi-channel campaign management applications such as Adobe Campaign, Acoustic, Braze and Salesforce Marketing Cloud which are generally hosted and managed by a team of Service Delivery, Campaign Management and email experts. We provide web services around these solutions, integration to web sites, back office systems and deliver anything from simple email templates to more complex website & digital applications as well as stand-alone tactical digital communication programs in support of our Creative & Media Agency.

YOUR RESPONSIBILITIES

Managing delivery of multiple complex simultaneous development projects from design through to release

Capable of understanding and contributing to the technical solution from design through to code level

Working closely with Project Managers to produce accurate delivery estimates

Hands on development and maintenance of CRM database and datalake solutions

Writing technical specifications, participating in code reviews and meetings, and providing updates on project progress

Liaising with key stakeholders, client, and other Code departments to facilitate the transition of solution from analysis through to design and delivery

Attend client meetings if required to discuss and demonstrate solutions at both technical and business level

System integration of multiple products to build multichannel communications solutions to meet client requirements

General development and support programming involving investigation of code and data issues.

Providing training to internal & external personnel

Ready to learn new skills and technologies required for the job

SKILLS AND EXPERIENCE

Strong design and development experience on datalake and database solutions using AWS services

Experience in delivery of complex data projects

Strong Data Modelling, Database & Data Warehouse analysis and design skills

Experience in ETL & Database design and development

Data manipulation, exploration, analysis, and data integrity (experience of manipulating data of varied sources and targets like RDBMS, XML, JSON and Flat Files)

Demonstrated ability to understand and discuss complex technical concepts.

Knowledge of software development processes including Agile, Lean, Waterfall & V-model

Commercial experience in technical delivery of projects

Integration of 3rd party products, such as Adobe Campaign, Acoustic Campaign Automation & Salesforce Marketing Cloud to solutions to enable multi-channel communications

Essential Skills:

AWS Glue with PySpark/Python

AWS Lambda with Python

AWS Step functions or Apache Airflow

Amazon S3

Apache Kafka

Amazon Redshift and Redshift Spectrum

Data Analysis and Data Modelling

Other AWS Services: IAM, CloudWatch, Secrets Manager, Parameter Store

Experience in development of Datalake on AWS

Experience in specifying deployment packages on AWS

Advanced SQL knowledge

Desirable/beneficial Skills:

Amazon Athena

AWS API Gateway

Amazon Cognito

Terraform and CI/CD

Git

.Net C#

Web service utilities

Azure technologies

Experience in Adobe Campaign, Salesforce Marketing Cloud or Acoustic Campaign Automation

LASTLY, BUT IMPORTANTLY…

What we need from you: Jump in. Find problems. Fix them. Build relationships. Imagine new solutions. Invent them. Do whatever it takes to go above and beyond. And stand up for individuality.

What do you need from us? As an inclusive and flexible employer we understand that everyone has unique requirements and needs. So please let us know what we can do to help, should you require adjustments to the process or have specific needs within the role.