We are currently recruiting for one of the UK’s Leading FMCG companies, for the role of a BI Developer. Join our client, a leading player in the pet health services and insurance industry, as they aim to secure the coveted position of the UK's #1 Pet Insurer.
Our client is embarking on an exhilarating journey, backed by substantial funding that will propel them to the forefront of global product leadership. This pivotal moment includes a dynamic company rebrand, extensive departmental expansion, a sweeping transformation, and substantial investments in cutting-edge technologies.
What You Can Expect
* Work Type - Contract (6 months)
* Location - Borehamwood (Hybrid - 2 days per week)
* Salary - £450 - £550 (Inside IR35)
* Industry - Insurance
Main Responsibilities as a BI Developer
1. Work on DWH ETL processes (SSIS and native T-SQL) and re-engineer to improve daily ETL run times to continue to meet business/partner SLAs.
2. Examine the end-to-end DWH ETL process (SSIS and native T-SQL) and recommend possible improvements.
3. To ensure all improvements made are documented in detail where necessary.
4. Provide expertise regarding the migration of the current SQL Server 2022 DWH on-premises platform to a Microsoft Azure cloud environment.
5. Use experience to mentor existing developers in advanced SQL optimisation techniq...