Harnham
SEARCH
Shortlist

Data Warehouse Engineer

London
£40000 - £50000 per annum
Apply Save job

DATA WAREHOUSE ENGINEER
MEDIA COMPANY
LONDON
£50,000

One of the UK's best known media outlets based in London are looking for a Data Warehouse Engineer to help build and operate their data warehouses during major migration and transitional projects including finance, CRM and order management systems.

THE COMPANY

The company are a very well known UK umbrella company with a number of different brands and product offerings and they have a large centralised Analytics team split between Data Engineering, Data Warehousing and Analytics

THE ROLE

If you were to be successful in your application for this Data Warehouse Engineer, your responsibilities would include:

  • Use SQL and Python to take data from the AWS data lake and transforming that into more digestible data marts using Snowflake so it can be effectively used by data science and analytics teams (specifically transforming it for use in Tableau)
  • Using SSIS for ETL processes and helping them to transition to DBt for a more modern approach to their ETL
  • Have a good understanding of the concepts of data warehousing and things like Kimball methodologies

SKILLS AND EXPERIENCE

In order for your application for the Data Warehouse Engineer to be successful you will need;

  • A strong coding ability in SQL, and ideally an understanding of Python.
  • Excellent ETL experience using tools like SSIS or ideally some knowledge of custom ETL using Python or even better Dbt or Airflow
  • Ideally some exposure to cloud based environments
  • A strong understanding of platforming data for analytics and building data marts where data can be reporting on and pulled from directly

HOW TO APPLY

If you are interested in this Data Warehouse Engineer please apply via this site.


KEYWORDS

Business Intelligence, Data Warehouse, Analytics, ETL, SQL, Python

Apply Save job
Send similar jobs by email
110349/EP
London
£40000 - £50000 per annum
  1. Permanent
  2. Business Intelligence

Similar Jobs

Senior Manager Business Intelligence
Salary

£60000 - £90000 per annum

Location

London

Description

This Company are looking for a BI Manager to deliver on their hub and spoke approach to bi and analytics using Kimball modelling and agile working

ADD TO SHORTLIST
Data Product Owner
Salary

£55000 - £60000 per annum + benefits

Location

London

Description

Great opportunity for a Product Owner who has worked on Data Driven products to join a media company and work on new and existing products

ADD TO SHORTLIST
Business Analyst
Salary

€70000 - €85000 per annum

Location

Düsseldorf, Nordrhein-Westfalen

Description

Looking for an experienced Business Analyst/ BI Analyst to contribute to the team by discussing and collecting business requirements.

ADD TO SHORTLIST
Data Manager (SAS)
Salary

£65000 - £70000 per annum + bonus + benefits

Location

Hemel Hempstead, Hertfordshire

Description

Great opportunity for someone with extensive SAS experience and DWH/ETL knowledge to use their skills and up-skill with new cloud tech

ADD TO SHORTLIST

Harnham blog & news

With over 10 years experience working solely in the Data & Analytics sector our consultants are able to offer detailed insights into the industry.

Visit our Blogs & News portal or check out our recent posts below.

How Can Your Career In Big Data Help You To Accelerate Change?

Data & Analytics is fast becoming a core business function across a range of different industries. 2.5 quintillion bytes of data are produced by humans every day, and it has been predicted that 463 exabytes of data will be generated each day by humans as of 2025. That’s quite a lot of data for organisations to break down. Within Gartner’s top 10 Data & Analytics trends for 2021, there is a specific focus on using data to drive change. In fact, business leaders are beginning to understand the importance of using data and analytics to accelerate digital business initiatives. Instead of being a secondary focus — completed by a separate team — Data & Analytics is shifting to a core function. Yet, due to the complexities of data sets, business leaders could end up missing opportunities to benefit from the wealth of information they have at their fingertips. The opportunity to make such an impact across the discipline is increasingly appealing for Data Engineers and Architects. Here are a just a selection of the benefits that your role in accelerating organisational change could create. Noting the impact In a business world that has (particularly in recent times) experienced continued disruption, creating impact in your industry has never been more important. Leaders of organisations of a range of sizes are looking to data specialists to help them make that long-lasting impression. What is significant here is that organisations need to build-up and make use of their teams to better position them to gather, collate, present and share information – and it needs to be achieved seamlessly too. Business leaders, therefore, need to express the specific aim and objective they are using data for within the organisation and how it’s intended to relate to the broader overarching business plans. Building resilience Key learnings from the past year have taught senior leaders around the globe that being prepared for any potential future disruption is a critical part of an organisation’s strategic plans. Data Engineers play a core role here. Using data to build resilience, instead of just reducing resistance or limiting the challenges it presents, will ensure organisations are well-placed to move into a post-pandemic world that makes use of the abundance of data available to them. Big Data and pulling apart and understanding these large scale and complex data sets will offer a new angle with which to inform resilience-building processes.  Alignment matters An organisation’s ability to collect, organise, analyse and react to data will be the thing that sets them apart from their competitors, in what we expect to become an increasingly competitive market. Business leaders must ensure that their teams are part of the data-driven culture and mindset that an organisation adopts. As this data is used to inform how an organisation interacts with its consumers, operates its processes or reaches new markets, it is incredibly important to ensure that your Data Engineers (and citizen developers) are equipped and aligned with the organisation’s visions. Change is a continuous process, particularly for the business community. Yet, there are some changes that are unpredictable, disruptive and mean that many pre-prepared plans may face a quick exit from discussions. Data professionals have an opportunity to drive the need for change, brought about by the impacts of the pandemic, in a positive and forward-thinking way. In understanding impact, resilience and alignment, this can be truly achieved. Data is an incredibly important tool, so using this in the right way is absolutely critical. If you’re in the world of Data & Analytics and looking to take a step up or find the next member of your team, we can help. Take a look at our latest opportunities or get in touch with one of our expert consultants to find out more.

Georgina Garraway

Georgina Garraway

25. March 2021

News

How Are Data & Analytics Professionals Mapping COVID Trends With Data?

The coronavirus pandemic has impacted industries across the globe. There’s no ignoring that simple fact. This disruption (most notably) caused devastating effects in two strands: to our health and to business operations. As the virus spread, the health and wellbeing of people in society worsened, and businesses felt the strain of projects being placed on hold, and work slowing or completely grinding to a halt. As of the 24th February 2021, the disease has infected more than 112,237,188 people, with 2,487,349 reported deaths. For Data & Analytics professionals, it soon became evident that they could use their skills to help. Using the mass of data available, professionals and researchers turned to big data analytics tools to track and monitor the virus’s spread, along with a variety of trends. Here’s how: Genomics and sequencing Life science is a significant application within Data & Analytics and explores the study of all living things on earth. One particular section of this study looks at the concept of genomic sequencing.  Genomic sequencing is significant as it allows us looks at the entire genetic code of a virus – in this case, COVID-19. Most importantly, the technique means that researchers and analysts can identify dangerous mutations and track movements of specific variants. We know that the UK has the most advanced system for tracing covid variants too. Last year, Britain launched one of the world’s largest coronavirus sequencing projects, by investing £20 million in the Covid-19 Genomics UK consortium. In a group that included NHS researchers, public health agencies, academic partners and the Wellcome Sanger Institute, they set out to map the genetic code of as many strains of the coronavirus as possible. And the buy-in paid off. It took the US approximately 72 days to process and share each genetic sequence, compared with 23 days for UK researchers, according to figures compiled by the Broad Institute with data from Gisaid. Tech giants stepping in Ultimately, your organisation is more agile than you think it is. Regardless of the size of the business, or the industry in which it operates, the sector’s response in applying analysis and data to track the coronavirus was nothing short of miraculous. Google introduced a series of features such as popular times and live busyness, COVID-19 alerts in transit, and COVID checkpoints in driving navigation in order to keep their one billion (and growing) app users safe. They also introduced the COVID layer in Maps, a tool that shows critical information about COVID-19 cases in a given area, allowing their customers  to make informed decisions about where to go and what to do. Apple also released a mobility data trends tool from Apple Maps. This data was shared in order to provide insights to local governments and health authorities so that they could support mapping specific covid trends. These first-hand examples indicate the influence and power of using data to better our understanding of the virus. Before the coronavirus pandemic, professionals, businesses and industries alike worked in siloes. What we have witnessed since has been very much the opposite, as experts quickly came together to begin mapping out data requirements and supporting the world’s focus to improve the public’s health and get businesses back on their feet. Without Data & Analytics, none of this would be possible. If you're looking to take the next step in your career or build out a diverse Data & Analytics team, we may be able to help. Take a look at our latest opportunities or get in touch with one of our expert consultants to find out more. 

Amy Topcakan

Amy Topcakan

25. February 2021

News

Recently Viewed jobs