Data Engineer – Cloud to Cloud Transformation
My client, one of the worlds biggest names in the Insurance Industry are looking for a Data Engineer to join their growing team. This is an exciting time to join as they are in the process of undertaking a large transformation program migrating all of the old technologies to an exciting new technical environment, utilising AI / Machine learning tech stacks. Cloud to cloud transformation (IaaS to PaaS) and value based analytics
•Designing and deploying ETL solutions.
•Database monitoring and tuning.
•Test and reconcile data between source and enterprise data warehouse.
•Create, manage and maintain SSIS projects and packages.
•Create, manage and maintain reports and dashboards using SSRS and Power BI.
•Create, manage and maintain SSAS projects.
Technical skills & expertise:
•Proven experience as a SQL Developer/Tester (industry experience preferred).
•Advanced SQL skills, including the creation complex queries (e.g. nested SQL statements, recursive CTEs, etc.).
•Microsoft BI Stack – advanced T-SQL, SSIS (with BIML), SSAS (Tabular), SSRS and DAX.
•Knowledge or waterfall and/or agile methodologies (including all stages of software development).
•Oracle SQL Developer and Microsoft SQL Server Management Studio (SSMS).
Extremely desirable experience:
•TFS or similar
•Snowflake or similar (e.g., Amazon Redshift, Google Big Query)
•Job schedulers (i.e. creating, implementing and maintaining jobs using SQL Agent or equivalent).
•Experience in Erwin DG
•£80,000 – £90,000 + Excellent Benefits
• 10 – 25% Bonus (10 % minimum)
• 80% remote working options
• 25 days holiday
• 17% Pension Contribution
• 10 X salary Death in Service benefit and income protection