ETL Focused Data Analyst - Triple Growth Business in Health Sector REF 901

Interface Recruitment UK; England; On-site; GBP 32,000 - 37,000; Full time

Job summary

A leading recruitment firm in the UK is seeking a Data Analyst focused on ETL to support their IT department and aid in data-driven decision making. The successful candidate will have solid ETL experience and proficiency in SQL and PowerBI. This role offers a competitive salary of £32k plus a £3k bonus, along with benefits such as pension and health insurance.

Benefits

£3k Bonus

Pension

Health insurance

Life insurance

Free parking

Qualifications

• Experience in ETL and data transformation.
• Capable of managing SQL and SQL Server.
• Ability to design cohesive data platforms.

Responsibilities

• Extract and transform data from the ERP system.
• Analyze data to streamline business processes.
• Combine analytics from different business applications.

Skills

DAX, M, MDX

Excel (Power Query)

SQL / SQL Server

Analytical skills

Power BI

Interpersonal skills

Planning and organization

Mathematical ability

Tools

MSBI

PowerBI

Tableau

Qlik

SAP BI

Job description

Role

Data Analyst – ETL Focused

Location

East Midlands

The Company

This is no straight forward Data Analyst position. The role is an integral part of a small but growing IT department supporting the business indelivering triple turnover growth over the next 3 years. There has been a diversification of services and a huge amount of investment from the global group leading to the most sustainable and secure growth phase in the companies’ history. Never before has data been so important to the business. The IT infrastructure has recently been modernized such that all resources are held in Microsoft Azure and they are now looking to leverage new technologies and services to further grow the business with accurate analysis from the many data sources and applications the company run.

The Group

A global healthcare group offering services critical to the current pandemic and safe management of Healthcare delivery. An entrepreneurial Group with a desire to hire or create leaders, valuing a family culture which empowers employees by giving them autonomy and freedom to diversify their skills and responsibilities enabling the individual to grow in line with the business.

The Role

This Data Analyst role requires an individual who has really solid experience in ETL. Drawing data from multiple data sources, transforming and the moving to a common data platform. A solid understanding of data structures and BI tools will be required to create a cohesive platform where data moves between systems and gives incisive reporting to inform critical business decisions from factory shop floor to auditing and consulting divisions. This will mainly be delivered using the MSBI stack (Microsoft Business Intelligence Stack) in the form on PowerBI as well as Data Driven programming languages such as 'M'. This is very much a starting point and there will be the opportunity to get involved in bigger, Global projects such as a Datawarehouse build on Azure and a self-service reporting build amongst others.

Key role responsibilities and technical requirements

• Extract and transform data from our bespoke ERP system.
• Analyse data with a focus on streamlining and growing the business
• Gather transactional data and feeds into SQL servers for analytics
• Combine analytics from other business applications such as Salesforce, MS Dynamics, PeopleHR.
• Manage SQL / SQL Server

Essential skills and experience

• DAX, M, MDX
• Excel (Power Query)
• Ability to analyse, model and interpret data, ETL procedures
• Capable SQL / SQL Server skills - Manage
• Exposure to Power BI or other reporting suites such as Tableau, Qlik, SAP BI would be an advantage but training given if not.
• High level of mathematical ability and problem-solving skills
• Excellent interpersonal skills
• Strong planning and organisation skills, able to meet deadlines
• High level of accuracy and attention to detail

Non Essential Skills / Experience

• Report production using SSAS, SSRS, MS Excel & PowerBI.
• ETL to RDS in AWS and Azure
• Data Warehouse / Database Concepts
• Visual Studio

Benefits

Salary: £32k + £3k Bonus

Hours of work: Monday – Friday

Pension: Yes

Health: Yes

Life: Yes

Free parking: Yes

To apply

In the first instance there is little need to submit a CV. Let’s talk about your motivations and what you want from your next role.