UK – Senior SQL Engineer Full Time

Incubeta

Senior SQL Engineer

Job Overview

We are seeking a Senior SQL Engineer to join Incubeta’s Technology team and take on a leadership role in developing and maintaining the SQL code and data tools for our company’s data pipelines. As a Senior SQL Engineer, you will be responsible for writing efficient BigQuery SQL queries to process data through our Airflow and DBT driven data pipeline system. You will also be expected to collaborate with cross-functional digital advertising teams to ensure data standards and accuracy, and provide technical leadership and mentorship to junior SQL Engineers from various Incubeta offices around the world. The role offers a good opportunity for someone keen to develop their skills with modern data tools and services.

Requirements and Responsibilities

Create efficient BigQuery SQL queries and views to extract data from various sized databases.

Collaborate with cross-functional teams, including software engineers, data analysts and account managers, to understand their data needs and ensure data consistency.

Troubleshoot and resolve data issues as needed.

The ability to share and explain the best practices based on the existing coding patterns and to mentor interns, juniors and developers.

Create clear documented structure and standards that explain the way of thinking in the form of technical documentation, models or (POC) code.

Ability to design or setup different testing environments for data tools like DBT. Ability to communicate the testing strategy with other squad members and help them to integrate test writing in their everyday work.

Cost driven thinking: being aware and taking responsibility for the cost expect of the chosen technical solutions. The commercial viability is always front of mind in the planning and execution of projects / products.

New coding and platform skills/languages shared as a mentor of the team, and championed within the business.

Demonstrate applicable experience of designing vertical and horizontal scalable architecture.

Contributing on the structure of documentation and take responsibility for that to be delivered.

Ability to create architectural diagrams (ex.: UML, Flow, BPM notation) and present it to the team members in an understandable way.

Driving technical conversations in project and product kickoff / estimation and planning sessions. Clear goal setting and taking responsibility on delivery based on the agreement with the squad and the Product Owner / Project Manager.

Takes the responsibility on the delivery of the milestones by following priorities set by the product owner / project manager.

Standardisation opportunities with the business are proactively suggested, guided and implemented.

Actively contributes in setting the team goals.

Key Requirements

3+ years of experience in SQL coding and optimisation.

Strong knowledge of BigQuery (or a related modern analytics database).

Experience developing in a formal Kanban or agile oriented SDLC.

Strong analytical skills.

Experience working with large datasets from multiple sources.

Good communication and interpersonal skills.

Ability to work independently and in a team environment.

Highly Advantageous

Experience with modern ETL tools and processes, especially Airflow and DBT.

Experience with BI dashboard tools, especially Looker Studio.

Experience in leading technical projects and providing mentorship to junior developers.

Ability to read and create standards compliant documentation and system designs.

General Google Cloud Platform experience.

BigQuery system and code optimisation experience.

Any other coding skills (especially Python).

Experience working with Googling Marketing Platforms.

Client experience.

As an Incubeta Technology team member, you

• Love technology
• Love the internet
• Love to learn
• Love to solve problems

An Overview of Incubeta

Incubeta is a digital marketing consultancy with a focus on bringing together the best people, technology and data. Our specialists build solutions that embrace the power of technology, the truth of data and add a spark of human creativity. We help advertisers, agencies and publishers get the most from digital for their business.

As Google’s most experienced EMEA Sales Partner we have overseen hundreds of deployments across the Google Marketing Platform. We do this by addressing ad tech infrastructure, data management, integration, media management and provide clients with relevant and up-to-date digital marketing services and consultancy.

We know our people are what sets us apart and we strive to provide a diverse and inclusive workplace that helps every individual realise their full potential through a rewarding career. When you speak to us you’ll hear our culture shine through. When you work with us you’ll be an influential piece of what makes us a winner of Campaign Magazine’s Best Place to Work. Scroll down to read more about the role, the career opportunities, our culture and the benefits we offer.

Some top facts about us

• Incubeta UK is an award winning digital marketing group with over fifteen years of experience
• We are part of a global business, based in Old Street, London, with offices in New York, Los Angeles, The Hague, Berlin, Cape Town and Sydney, to name a few
• We have won awards for both our work and our culture!
• We have flexible working policies allowing you to work from home up to three days a week and fit work around other important life commitments
• We encourage people not to leave it at the door but instead bring their passions into the workplace. We have committees and networks who improve our thinking and action on topics such as DE&I, Mental Wellbeing and Sustainability

Our Package Salary

Incubeta pay industry benchmark salaries. Salary is reviewed on a regular basis and can increase as you progress along your career path. We also offer additional performance related bonuses, so we can be found above the industry benchmark on pay alone.

Benefits

We have a credit-based benefits package which allows you to choose from a range of benefits including health care, additional pension, gym memberships and more.

Learning and Development

We have an in-house team of learning specialists who will ensure a smooth transition into your role and the wider business. As a minimum, you’ll have a forward looking development review every 6 months to discuss your career goals and our L&D team will be on hand to support you to get there.

Our unique hiring process

We are an equal opportunities employer and are committed to a policy of Equal Employment Opportunity and are determined to ensure that no applicant or employee receives less favourable treatment on the grounds of gender, age, disability, religion, belief, sexual orientation, marital status, or ethnicity, or is disadvantaged by conditions or requirements which cannot be shown to be justifiable.

As such we use an anonymised recruitment process. When you hit apply you’ll first be asked some questions about you, if you feel comfortable, we’d love for you to provide as much information as you can. Your data will be anonymous and will not be shared. It will only be used to help us understand how we are performing against our equal opportunities metrics and where we might need to make improvements. After that you’ll be asked to answer some questions that are related to the day-to-day role. Your answers will go through our sift process where they’ll be anonymised, randomised and then reviewed by a panel of reviewers.

If you are shortlisted, we’ll invite you to the next step, which includes two or three interviews.

We love giving feedback, and you’ll be well informed of your progress throughout the application process.