Senior SQL & Data Warehouse Engineer
Description
Who we are
Our client is a world-leading reinsurance and risk management company, delivering comprehensive solutions across insurance, underwriting, and data-driven risk assessment. With a strong focus on innovation and long-term stability, they support clients in addressing complex risks and driving sustainable value in an ever-changing global landscape.
We are looking for a Senior Data Engineer with a strong focus on SQL, data modelling, and Azure-based data solutions. Around 80% of the role will be focused on SQL-related activities, while Databricks experience is considered a plus and can be developed over time. The role is ideal for someone with a strong SQL and data warehousing background who wants to further develop their expertise within the Azure data ecosystem. If this sounds like the right next step for you, hit Apply and let’s start the conversation!
What you'll be doing
- Design and develop robust data solutions with a strong focus on SQL and T-SQL
- Develop, optimize, and maintain complex queries, data models, and database structures
- Create solution designs for new features and translate them into technical User Stories
- Drive technical refinements together with Requirement Engineers and Product Owners
- Design and maintain data models for data warehouse and transactional environments
- Develop and optimize ETL processes and data pipelines using Azure technologies
- Work with Microsoft SQL Server and Azure-based data infrastructure
- Perform schema and data migrations
- Analyze and optimize ETL and database performance
- Conduct technical QA and ensure reliable, maintainable data solutions
- Support planning activities and collaborate with development teams in an Agile environment
- Apply DevOps and CI/CD practices using Azure DevOps and Git
What you'll bring along
- Bachelor’s degree in Computer Science, Information Technology, or a related field is preferred
-
At least 5 years of experience in Data Engineering or a comparable role
- Strong hands-on experience with SQL, T-SQL, and Microsoft SQL Server
- Strong knowledge of data modelling, including data warehouse and transactional concepts
- Experience designing, developing, and optimizing ETL processes and complex data flows
- Good knowledge of the Azure data engineering stack, including Azure Data Factory, Azure Data Lake, and Cosmos DB
- Experience with schema and data migrations
- Working knowledge of Python and PowerShell
- Experience with Azure DevOps, Git, testing, and CI/CD practices
- Strong analytical and problem-solving skills
- Ability to independently design technical solutions and translate requirements into technical deliverables
- Experience working in Scrum / Agile environments
- Excellent command of both spoken and written English
Nice to Have
- Experience with Databricks and Delta Lake – not mandatory; these skills can be developed as part of the role
- Experience with Power BI
- Experience with performance optimization of large-scale data environments