Naukrijobs UK
Register
London Jobs
Manchester Jobs
Liverpool Jobs
Nottingham Jobs
Birmingham Jobs
Cambridge Jobs
Glasgow Jobs
Bristol Jobs
Wales Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

Senior Data Warehouse Analyst

Job LocationCamden (London Borough)
EducationNot Mentioned
SalaryCompetitive salary
IndustryNot Mentioned
Functional AreaNot Mentioned
Job TypePermanent, full-time

Job Description

This is a subject matter expert role for a technical Data Warehouse Analyst or a technically minded financial analyst to support Kantar’s enterprise business intelligence platform and internal management information solution. The role will involve working closely with the Head of Data and Analytics in expanding the reach and data quality of Kantar’s Azure data warehouse, primarily focusing on the integration of new data sources (structured data from ERP, accounting, CRM, HR systems), as well as maintaining and improving existing data feeds.Our analytics platform and MI solution are used by senior figures throughout Kantar to drive informed operational decision-making and the integration of additional business data sources is a critical step toward providing stakeholders with a holistic, unified view of the company. This role will focus on data from ERP (Maconomy, Navision, Dynamics AX) and other business systems (Workday/HR, Salesforce, CRM), ensuring that data is extracted securely from source platforms and moved into Kantar’s central Azure data lake, where it will be transformed into data models using the Azure technology stack (ADF, Synapse DWH, AAS). The data are presented to business users through PowerBI dashboards and advanced analytical applications.Ideally, the role will be based in Kantar’s UK or German offices (nationwide), however, we may also be open to exploring remote working/other European locations, depending on the time zone.Key Outcomes

  • Integration of additional data feeds into Kantar’s central business analytics platform and management information solution.
  • Design and implementation of secure extraction and transfer processes, to provide the data warehouse with secure, high-quality, and timely data feeds.
  • Maintenance and improvement of existing data feeds and associated extraction/transfer processes; resolution of all errors and exceptions.
  • Liaising with data owners, as well as Security and Data Governance teams, to ensure data is handled according to appropriate privacy and security protocols (covering anonymisation, aggregation, and/or encryption where required).
  • Understanding and anticipating changes to source data and systems (what is recorded, where, how); mitigating the impact of these changes on the analytics platform and MI solution.
  • Capabilities
  • Extensive technical knowledge of data warehouses and ETL processes/systems, with deep experience in source data extraction and transfer to cloud-based systems (covering scheduled CSV exports, REST APIs, template-based files).
  • Knowledge of relational databases and the required tools to manage data extraction (SQL, T/PL-SQL, SSIS), as well as strong Excel proficiency.
  • Practical experience working with reporting and dashboarding solutions; Azure and PowerBI strongly preferred, but knowledge of Tableau, Qlik, or similar systems is also useful.
  • Strong, broad understanding of business systems - across finance, HR, CRM, operations - and the applications of business data.
  • Lateral thinking and creative problem-solving skills, with a track record of improving ways of working and designing new solutions.
  • Strong organisational skills, with an ability to keep on top of project scope, progress, and deadlines, whilst diligently recording solutions and process documentation.
  • APPLY NOW

    © 2019 Naukrijobs All Rights Reserved