Skip to main content

This job has expired

You will need to login before you can apply for a job.

Data Architect

Employer
McGregor Boyall
Location
London, United Kingdom
Salary
Up to GBP95000.00 per annum
Closing date
Aug 24, 2022

View more

Job Function
Other
Industry Sector
Finance - General
Employment Type
Full Time
Education
Bachelors
**Permanent role**

**Up to £95Kper annum (+ package)**

**SPONSORSHIP - AVAILABLE**

**Hybrid working - home/office split**

The role

In this role, the candidate will form part of a centralized data architecture function. This is a hands-on role in helping to create various types of software to consolidate, normalize, unify, and track data from disparate upstream vendors and create a data platform for all downstream data applications. The ideal candidate will have a deep interest in data, modelling data (No-SQL, relational and dimensional) and in building cloud-based applications to help with various aspects of data management.

The responsibilites
  • Provide analytical support using SQL to measure KPIs or perform ad-hoc data exploration for business LoBs
  • Gain familiarity with a variety of data sources including both event-stream data and tabular, relational data
  • Help the LOB stakeholders innovate through data-driven decisioning by querying data and merging information from diverse data sources to create rich datasets that enable better decision-making
  • Create a consolidated data model merging the various data sources ingested by the platform. This will involve creating a dimensional model.
  • Work with other Analytics teams and multi-task on projects to summarize and synthesize data in a clear and logical manner
  • Identify unexplored data opportunities for the business to unlock and maximize the potential of digital data within the organization
  • Support ongoing technology evaluation process and proof of concept projects
  • Create cloud-based applications to facilitate various aspects of data management (e.g. reference data management, master data management, data lineage).

Essential
  • Technical expertise in creating Dimensional Data Models and database design
  • Experienced in ELT/ETL processes, reconciliations, data pipelines creation and implementation
  • Intermediate level experience of Python
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
  • Adept at queries, report writing and presenting findings
  • Experience with relational & non-relational databases utilizing SQL to pull and summarize large datasets, report creation and ad-hoc analyses
  • Knowledge of modern MPP databases and big-data (Hadoop) concepts

Desirable
  • Some SQL experience and ELT tooling experience like DBT or similar.
  • Experience in agile reporting development and ability to interpret unstructured data and draw objective inferences given known limitations of the data
  • Demonstrated ability to think beyond raw data and to understand the underlying business context and sense business opportunities hidden in data


McGregor Boyall is an equal opportunity employer and do not discriminate on any grounds.

Sign in to create job alerts

Sign in or create an account to start creating job alerts and receive personalised job recommendations straight to your inbox.

Create alert