Senior data warehouse engineer

TN United Kingdom; London; On-site; GBP 50,000 - 90,000; Full time

Job description

Social network you want to login/join with:

I'm currently looking for a Data Warehouse Engineer in London.

Key Skills Required for This Role:

Oracle - SQL - ETL

Introduction:

Our client, a leading insurance company based in London, is seeking a talented Senior Data Warehouse Engineer to join their dynamic Data Management team. As a Senior Data Warehouse Engineer, you will play a vital role in supporting the development of data systems, including data warehouses, dashboards, and reports. This is an exciting opportunity to be part of an organisation at a formative period in its development, with ample scope for personal and professional growth.

Key Responsibilities:

1. Translate business needs into technical specifications.
2. Create ETLs for onboarding new portfolios.
3. Develop and maintain SQL Server and Oracle data warehouses.
4. Design and maintain data models for the data warehouse.
5. Assist with solution design and system test plan preparation.
6. Build and deploy BI solutions and analytical tools.
7. Collaborate with teams to integrate systems.
8. Develop and execute database queries and conduct analyses.
9. Develop and update technical documentation.
10. Improve processes within the organisation and automate manual tasks.
11. Conduct peer review of team members' code.
12. Support and maintain existing IT services.

Job Requirements:

1. Significant experience with SQL Server data warehouse tools.
2. Experience with Oracle databases, including Oracle Cloud and Apex.
3. Knowledge of the Microsoft Business Intelligence stack and data warehousing concepts.
4. Understanding of Microsoft Azure and cloud-based IT services, particularly the Microsoft 365 ecosystem and Power Platform.
5. Experience with person-to-person workflow technologies.
6. Exposure to Microsoft Windows and web services (IIS and Tomcat), CI/CD pipelines (Azure DevOps), and generating XML files.
7. Understanding of database design techniques, optimisation, ETL best practices, and dimensional modeling.
8. BSc/BA in Computer Science, Engineering, or related field.

This is a chance to join a brilliant, established business, which still has a 'start-up' mentality. Lots of collaboration, an agile environment, the chance to work closely with the Group Head of Data, and plenty of opportunities for career progression.

Managed by: Matchtech is a STEM Recruitment Specialist, with over 35 years’ experience.