Data Engineer

Leonard Curtis; Whitefield; On-site; GBP 65,000 - 90,000; Full time

Benefits offered by this job

25 days holiday

Birthday leave

Giving back days

Enhanced family friendly policies

Job summary

Leonard Curtis is seeking a Data Engineer to build, maintain, and optimise robust data pipelines. This role delivers clean, production-ready data for enterprise analytics using Microsoft Fabric tools and the Databricks Lakehouse Platform.

You will develop ETL/ELT workflows, implement automated data quality checks, and support real-time Power BI reporting needs while adhering to governance policies and industry best practices.

Qualifications

• Strong proficiency in PySpark, Databricks SQL, T-SQL and Delta Lake formats.
• Hands-on experience building production pipelines in Databricks and Fabric.
• Knowledge of Parquet, JSON, and CSV formats.

Responsibilities

• Construct scalable data ingestion pipelines using Fabric Data Factory, Dataflow Gen2 and Databricks Workflows.
• Implement Delta Live Tables to automate batch and real-time processing.
• Build and maintain silver and gold layers in shared storage with Medallion Architecture.
• Write optimised transformations in Fabric Notebooks and Databricks clusters using PySpark and SQL.
• Configure data access, masking and governance in Databricks Unity Catalog.
• Optimise Lakehouse performance with indexing and clustering techniques.
• Deploy pipelines using CI/CD, Git and Databricks Asset Bundles.

Skills

PySpark

Databricks SQL

T-SQL

Delta Lake

Tools

Databricks Workspaces

Fabric Data Factory

Dataflow Gen2

Databricks Workflows

Fabric Notebooks

Databricks Clusters

Unity Catalog

Job description

We're currently seeking a Data Engineer to build, maintain, and optimise robust data pipelines. This role develops efficient ETL/ELT workflows using both Microsoft Fabric tools and the Databricks Lakehouse Platform to deliver clean, production-ready data for enterprise analytics.

Role Requirements

• Strong proficiency in PySpark, Databricks SQL, T-SQL, and handling Delta Lake formats
• Hands-on experience building production pipelines inside Databricks workspaces and Fabric capacities
• Practical knowledge of structural data formats including Parquet, JSON, and CSV
• Experience with orchestration tools, scheduling dependencies, and error handling in a cloud environment
• Familiarity with unit testing data pipelines and implementing automated data quality checks

Role Responsibilities

• Construct scalable data ingestion pipelines using Fabric Data Factory, Dataflow Gen2, and Databricks Workflows
• Implement Delta Live Tables (DLT) to automate batch and real-time streaming data processing
• Build and maintain the Medallion Architecture silver & gold layer across shared storage
• Write optimised transformations in Fabric Notebooks and Databricks clusters using PySpark and SQL
• Configure data access, masking, and governance policies within Databricks Unity Catalog.
• Optimise Lakehouse table performance using Z-Order indexing, liquid clustering, and file compaction techniques
• Deploy data pipelines using CI/CD frameworks, Git integration, and Databricks Asset Bundles (DABs)
• Prepare finalised gold layer datasets to support real-time Power BI Direct Lake reporting model
• Salary aligned with your skills and expertise
• 25 days holiday allowance plus statutory public holidays and the option to purchase more
• Birthday leave
• 2 giving back days per year. We encourage our team to support the wider community by providing paid leave to work with local charities or good causes
• A hard working, fun and professional working environment
• Enhanced family friendly policies, including enhanced Maternity pay

Leonard Curtis is a market leading professional services provider operating across the UK and offshore. Since our formation we've supported business owners and advisors by listening and offering practical solutions and tailored advice. Our expert team of specialists deliver positive strategic advice across restructuring and insolvency, funding, legal, business services and M&A advisory across 30 offices. A career with Leonard Curtis will open the door to varied career pathways.

We have built an environment that empowers you to express yourself to have confidence in who you are and what you're capable of and develop the career you want.

Learning and Development

Leonard Curtis has a wealth of resources available to help you develop your career from the moment you join. Activities range from on-line learning modules to external training and qualifications.

Diversity and Inclusion

Diversity is a core business imperative of the Group. We are an equal opportunities employer which promotes inclusiveness and always employ the best professional for the job. Having a diverse workforce allows the Group to draw upon a range of different ideas and experiences which supports our business’s growth and creates an environment where everyone has an equal opportunity for success.