Job Title: Senior Data Engineer
Summary:
The Senior Data Engineer will play a key role in designing, developing, and delivering high-quality, reliable data solutions that support the organisation’s strategic data initiatives. This role requires deep technical expertise in modern data engineering practices, strong analytical and problem-solving abilities, and the capability to collaborate effectively with cross-functional teams.
Key Responsibilities
* Design, build, and optimise scalable data pipelines and workflows.
* Develop and maintain data models and data warehouse structures to support analytical and operational needs.
* Collaborate with data analysts, data scientists, and business stakeholders to understand requirements and deliver robust data solutions.
* Troubleshoot data discrepancies, performance issues, and system errors.
* Ensure compliance with data security, governance, and regulatory standards.
* Support and enhance existing data engineering processes and platforms.
Essential Skills & Knowledge
SQL Server Proficiency:
* Strong expertise in Microsoft SQL Server and SQL.
* Skilled in querying, performance tuning, and database optimisation.
Data Warehousing & Modelling:
* In-depth understanding of data warehousing principles and modelling concepts.
* Experience with designing efficient schemas, including normalisation and denormalisation techniques.
ETL / ELT Pipelines:
* Proven experience building and maintaining ETL/ELT processes.
* Ability to extract data from diverse sources, transform it effectively, and load it into data warehouse environments.
Problem-Solving:
* Strong analytical skills to diagnose data issues, resolve performance challenges, and support user queries.
Security Awareness:
* Good understanding of data security best practices and compliance frameworks (e.g., GDPR).
* Experience working with sensitive corporate data.
Industry Knowledge:
* Experience within the insurance industry is required.
Technologies & Tools
* Snowflake Data Cloud and related technologies (e.g., Fivetran, DBT, Dataiku, Collibra preferred).
* Microsoft Azure, including Azure Synapse and Azure DevOps.
* Microsoft SQL Server tools, including Master Data Services, SSIS, SSAS, and SSRS.
* Programming experience with Python and C#.
* Microsoft Power BI for data visualisation.
* Microsoft Office 365.