Database Engineer

Team Responsibilities

Inside the Technology Services & Omni Customisation team, the Data Architecture & Management team oversees the delivery of global performance from the biggest automotive advertiser in the world. The key elements of our product are accuracy, reliability and availability of the data to our analysts and clients. On the horizon we are looking to expand our capabilities and build new products that will enable new opportunities for our clients.

Role Summary

This is a key role in the Technology Services & Omni Customisation team as it will create a new layer and maintain existing layer of data and technology validation, helping us to ensure the quality of all our products. At the same time this is an exciting opportunity where you will be in a Designing Brand new data Models with cutting edge technology across different cloud platforms such as AWS, Snowflake and GCP.

Key Responsibilities

1. 5+ years of hands-on experience with physical and relational data modeling.
2. Must have experience of BI.
3. Analyzing and translating business needs into long-term solution data models.
4. Design and create conceptual data model to identify key business entities and visualize their relationships.
5. Perform data profiling/analysis activities that help to establish, modify and maintain data model.
6. Regularly engage and consult stakeholders on solving business problems through data.
7. Reviewing modifications of existing systems for cross-compatibility.
8. Implementing data strategies and developing physical data models.
9. Updating and optimizing local and metadata models.
10. Evaluating implemented data systems for variances, discrepancies, and efficiency.
11. Troubleshooting and optimizing data systems.
12. Good to have Data Vault modelling experience.

Good to have Skills

1. Knowledge or experience of AWS, Snowflake, Redshift and CI/CD.

About Annalect

Annalect is the data, technology, and analytics division of Omnicom. We help CMOs and their teams harness data, technology, and advanced analytics to grow their brands. We have built a variety of innovative product and specialist service solutions for clients and agency partners.

We build and maintain the Omni platform which gives agency and client teams access to these capabilities as well as the ability to integrate and combine their own data and technology with Omni. Omni has over 30,000 active users and is recognized in the industry as a leading marketing platform. We continuously innovate the platform to ensure our clients stay ahead of their competitors in data driven marketing.

Flexible Working

We are committed to supporting and helping Annalectuals have a great work/life balance and a positive attitude to well-being. As part of this we have a flexible and hybrid working model as a core part of how we operate.

We believe flexible & hybrid working can increase individual motivation, improve performance and productivity, and reduce stress as well as helping manage well-being generally. We will work with you to implement the best flexible working solution for you without compromising team performance and client delivery.

Employee Benefits

We offer pension contributions, life insurance, health insurance, a generous holiday entitlement and many other employee benefits for all. We have an enhanced maternity leave, shared parental leave, paternity leave pay policy.

Diversity

At Annalect, we are focused on equality and believe deeply in diversity & inclusion of race, gender, sexual orientation, religion, ethnicity, national origin and all the other fascinating characteristics that make us different.

We welcome remarkable people from a broad range of backgrounds who bring their diverse attitudes, opinions, and beliefs into a culture where you are treated with respect and can be comfortable at work just being you. Embracing our differences results in a stimulating and inspiring environment will lead to everyone viewing the world, our work and each other with fresh eyes.

Be Your Best

We want everyone to make the most of the opportunity to shine and showcase your talents and we are happy to make adjustments in the recruitment process so you can be your best. Please discuss any specific requirements with your dedicated Talent Team member or if you would feel more comfortable, you can email us confidentially at beyourbest@omnicommediagroup.com to let us know how we can support you.

Diversity, Equity & Inclusion at OMG

At OMG, our vision is to be an agency where difference is valued and everyone is able to thrive in a culture of equality, inclusion and belonging. We are committed to providing a truly inclusive environment that reflects today's society, where everyone is able to bring their true selves to work, and where diverse voices and backgrounds are valued, heard, and well-represented.