Senior Data Engineer

Senior Data engineer

Insurance Underwriter / MGA - Insurance experience essential

Full time - 1-3 Days a week in the office (City of London)

I am looking for a Senior Data engineer to join an incredibly interesting Insurance Underwriter / MGA. Within this role you will be working closely with the Data analytics team focusing on ETL processes, creating roadmaps for their central data warehouse and working with stakeholders to gather requirements.

Technical Skills

• Languages: Python, SQL
• Databases: Microsoft SQL Server (Azure SQL Database, SQLite)
• ETL Tools: SSIS, Azure Data Factory
• Cloud Platforms: SaaS and PaaS environments
• Reporting: Power BI
• Productivity Tools: Advanced Excel skills
• Comprehensive knowledge of data warehouse lifecycles and architecture
• Experience working within Agile or Kanban frameworks
• Familiar with Azure DevOps, Git, and associated development tools
• Desirable:
• Azure administration experience
• PowerShell scripting

Knowledge

• Deep understanding of ETL best practices, common data engineering challenges, and proven remediation approaches.
• Experience working in an Agile delivery environment.
• Competence in designing and developing data engineering workflows and solutions.
• Ability to script and implement dimensional data models (e.g., star schemas) with awareness of common modelling pitfalls.
• Knowledge of OLTP versus OLAP/DWH design considerations.
• Desirable:
• Insurance Experience
• Familiarity with Microsoft Azure security and administrative concepts.