Lead Data Engineer - 6-12 month FTC

We are looking for a Data Warehouse Engineering Lead to develop and deploy data products through our Azure Analytics Platform. You will work closely with the Data Warehouse team, Data Architect, and senior stakeholders across the business. It's an exciting time to join us as we're delivering our Data Strategy to support the transformation of our business through innovation & technology., * Provide expertise and guidance to your direct reports ensuring that the team can deliver a vital Data Service to the business.

• Ensure our Data Governance principals are implemented and adhered to and to be an advocate of best practice in Data Product delivery.
• Build and maintain optimal data pipeline architecture.
• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimising data delivery, re-designing infrastructure for greater scalability, etc.
• Work with key stakeholders including Senior management, Developers, Data, and Project teams to assist with data-related technical issues and support their data infrastructure needs.
• Develop and maintain a group-wide Data Estate incorporating a Data Lake and Data Warehouse using best practice warehouse methodologies.
• Define data integration and ingestion strategies to ensure smooth and efficient data flow from various sources into the data lake and warehouse.
• Develop data modelling and schema design to support efficient data storage, retrieval, and analysis.

OUR HIRING PROCESS:

• You've checked out our job ad
• It's gathered your interest and you've applied using our easy application process
• If selected, you will be invited to attend an initial 30 minute introductory video call with the hiring manager so we can learn a little more about you, your skills and experiences, and in turn allow you to ask us any questions you may have at this stage!
• If all goes well, and the role looks to be a good fit for you, we will invite you to attend a 90 minute formal video interview. In addition to competency based questions you will also be tasked with providing a short 'solution' presentation to a role specific problem to best demonstrate your skills and expertise
• If successful, we make the offer and get the ball rolling
• Once in post you can recommend your friends come on over and receive a referral bonus for each one that we appoint!

• Cloud & Data Engineering Platforms: Azure Data Factory, Azure Databricks (including Unity Catalog & Notebooks), Azure Functions, Azure Apps, Azure DevOps Pipelines

• Data Transformation & Modelling: dbt (Data Build Tool) for scalable modelling and transformation in cloud data platforms

• Programming & Query Languages: PySpark, PySQL, T-SQL, MS SQL, Stored Procedures

• ETL/ELT & Data Integration: MS SSIS, WebHooks, RESTful APIs, automated pipelines for batch and streaming data

• Data Architecture & Quality: Data Modelling, Data Analysis, Data Quality frameworks, dimensional modelling

• Leadership & Communication: Proven experience in team management, mentoring cross-training initiatives, and coordinating with diverse business stakeholders

• Governance & Compliance: Data Privacy (GDPR, CCPA), Metadata management, data discovery, data security (RBAC, CLS, RLS)

• Project Management and organisational skills

Competitive Salary of up to £75,000.00, Remote Working Options, 25 Days Holiday (Plus 8 Days Public Holiday), Option To Buy Or Sell Holiday, Company Pension, Life Assurance, Enhanced Maternity, Paternity & Adoption Pay, Free Conveyancing Legals, GP 24-hour service, Retail Discounts Plus Many More!

Simplify is the UK's leading conveyancing and property services business, comprising nine businesses which include some of the largest conveyancing law firms in the UK, two leading independent property services businesses as well as being the market-leading direct to consumer online conveyancer.