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.