Datawarehouse Developer - Jobs in Lancashire - 1891460

CarFinance 247
Job Summary
  • Job Type
    Permanent, full-time
  • Telecommuting

Job Description

Datawarehouse Developer

Job Description

The Role:

Working in the Data and Insights team, you will be developing and improving the existing CarFinance 247 Data Warehouse hosted on SQL Database in Azure. Along with identifying business requirements for reporting on source data, you will be building the appropriate data transfer from raw change data capture output into the data warehouse, performing transformations and building aggregated summary datasets for direct reporting in Looker. You will also be involved in the maintenance and upkeep of the data warehouse, and keeping the CI/CD pipeline functional and up to date. The role will also require liaising with both product owners and developers to understand our core data structures, and working with data analysts to understand their requirements for reporting within Looker.

Key skills & Experience

  • Microsoft SQL Server
  • Strong T-SQL and Stored Procedures
  • ELT/ETL using SSIS Projects
  • Data warehouse design
  • Kimball and Inmon DWH methodologies

Desirable skills

  • SQL Server internals understanding, indexing and columnstore in particular
  • Azure Event Grid
  • Azure Functions
  • CDC
  • SSDT projects
  • Source control
  • Agile/Scrum
  • CI/CD
  • Azure Data Factory
  • 3rd party tools such as Matillion/FiveTran/Talend etc
  • Looker

Quick Apply

Similar Jobs

Related Jobs

Aliexpress WW