Lead Analytics Engineer

The responsibilities of the role are as follows, organised into the 5 core competencies of the role:

• Modelling Data



• Accountable for the overall quality of data integrations; both technical and domain-oriented decisions surrounding data inputs, transformations and outputs.


• Responsible for steering all additions to the data warehouse, ensuring that new data feeds are optimally configured with consideration to schema, storage and ongoing updates.


• Responsible for designing, in consultation with domain experts across our extended team, data models that sensibly organise required transformations of the data.


• Responsible for delivering/overseeing the team's delivery of the data transformations required for new integrations in DBT SQL.


• Responsible for the curation of datasets in our primary BI tool and the evolution of these datasets, ensuring existing dependencies are protected.


Assuring Data Quality & Governance

• Accountable for the overall integrity of our data processing, ensuring transformations are well-tested, bugs are effectively triaged and any problems.are solved swiftly.


• Responsible for ensuring appropriate security across our entire data warehouse.


• Responsible for ensuring all data is handled with appropriate considerations to ethical, legal and personal data standards.


Providing Technical Leadership

• Responsible for proactively supporting the Head of Data & Engineering on the technical aspects of our overall data platform in terms of its scale and evolution, and surrounding development & CI tooling.


• Responsible for conducting thorough code reviews and ensuring all merge requests are of high quality before merging.


• Responsible for staying abreast of the data analytics industry, especially the ecosystem surrounding our core stack, to ensure we are aware of upcoming change and opportunity.


• Responsible for coaching the team, to ensure high quality output and supporting individual career development.


• Responsible for coordinating delivery, ensuring status is always observable in tickets, estimations are tight and releases are well-coordinated and communicated.


• Responsible for participating in various forums across the business where a technical point of view is required, and being a consistent ambassador for Apollo.


• Responsible for collaborating with our key user groups to ensure a full understanding of their needs and that those needs are met in our data outputs.


Ensuring Best Practice

• Accountable for the overall adherence to our standards across our SQL codebases and BI tools.


• Responsible for the health of our data transformations and semantic layer in terms of being well-organised, regularly pruned and highly maintainable.


• Responsible for ensuring that appropriate documentation exists and is kept up to date as deemed necessary.


• Responsible for keeping track of technical debt alongside delivery alongside the bigger picture, ensuring you protect regular time to review.


Solving Problems

• Accountable for the identification, communication and resolving of technical problems, and fostering a culture of quick-issue spotting and over-communication.


• Responsible for ensuring the team approach problems methodically, logically dissecting the issue to understand root cause and then fixing the source, not the symptom.
  
  In order to thrive in this role, you will need the following skills & experience:


• Extensive experience of analytics engineering, data management, business intelligence or related fields, demonstrating a track record of designing, implementing and maintaining robust data systems.


• Experience working with relatively large datasets, ensuring their consistency and accuracy.


• Deep experience architecting data models - ideally traditional dimensional models alongside more modern cloud-native approaches.


• Significant experience with DBT, SQL and Jinja and cloud computing platforms.


• Knowledge of data governance practices and data privacy considerations.


• Experience with writing tests and evaluating test coverage.


• Proven experience in leading technical team members including the mentorship of junior engineers.


• Ability to collaborate effectively with cross-functional teams including data analysts, data scientists and domain experts.


• Ability to adapt to new technologies and methodologies whilst protecting the fundamentals.


• Experience working with linters, formatters and other code standards tools.


• Informed opinions on code standards but ability to adapt to existing embedded standards.


• Experience working with various BI tools.


• Strong problem solving skills, with the ability to tackle complex challenges.


Experience with BigQuery and Apache Superset is desirable.

As the senior, technical lead behind Apollo Platform, the foundation of our cutting-edge marketing intelligence proposition, the Lead Analytics Engineer will play a pivotal role in shaping its future.

This is a unique opportunity to lead and innovate within our dynamic and fast-growing business, working on a best-in-class data platform, where your hands-on approach and extensive experience will directly influence our success.

We're looking for an experienced data/analytics engineer who lives and breathes data modelling, SQL and BI to join our talented team and make a real impact., Medialab is the UK's leading independent media agency, and one of the fastest growing. We're a media agency that's made differently. Purpose-led, data-driven, founder-run and proudly independent.

Our independence means we can focus 100% on doing the right thing to secure success for our clients and our brilliant people. We work with a wide variety of clients including SunLife,Standard Life, Laithwaites Wine, EMMA, Save the Children, Mind, Guide Dogs, Alzheimer's Society, RNLI and Clearscore.

We're a diverse team of 150 people (and growing), based near Oxford Circus. Our people-first, purpose-driven culture has been key to our success. We commit to creating a more sustainable future through our partnership with FuturePlus, and foster a diverse and inclusive culture, though a number of DEI Communities to drive real change. We offer a supportive environment for working parents, carers, those who are (peri)menopausal and anyone else who needs it, and flexible working opportunities to all, from day one.

Our entrepreneurial spirit means success is rewarded and there are no limits to what you can achieve, which our employees agree with, by supporting our place in Campaign's 'Best Places to work' for 4 years in a row, and we recently won Silver in Campaign's Agency of the Year Awards.

Working at Medialab comes with lots of perks including all the usual things you would expect, such as a competitive salary package, pension, season ticket loans, cycle to work scheme, weekly social events and big summer / end of year parties.

On top of that, we offer extra incentives which make life at Medialab even more rewarding:

• 25 days holiday, (including office closure between Christmas and New Year)


• Birthday day off


• Mental Health Awareness Day off


• Holiday buying scheme


• Hybrid working between office and home.


• Flexi-hours


• Work abroad scheme.


• Private Medical Insurance


• Health Cash Plan


• Life Assurance


• Discounted Gym Membership


• Retail discounts


• Quarterly reviews to enhance career progression.


• Continuous professional development and training - CPD Platinum accreditation by the IPA


• Internal mentoring programme


• Membership to Bloom and bespoke mentorship for female talent


• A long weekend/week away at Medialab's expense for long service


• Charity volunteering days fully paid.


• Free access to Health and Wellbeing Apps.


• Free professional counselling.Access to Mental Health Allies (1 in 15 employees are trained in Mental Health First Aid).


• Enhanced parental leave pay for new parents


• Virtual Dentist