At a Glance
- Tasks: Join us as an ETL Focused Data Analyst, transforming data to drive business growth.
- Company: Be part of a global healthcare group making a real impact during the pandemic.
- Benefits: Enjoy a competitive salary, bonus, pension, health benefits, and free parking.
- Why this job: This role offers hands-on experience with cutting-edge technology in a supportive, family-like culture.
- Qualifications: Solid ETL experience, SQL skills, and familiarity with BI tools like Power BI are essential.
- Other info: No CV needed initially; let's chat about your goals and aspirations!
The predicted salary is between 19200 - 28800 £ per year.
Role: Data Analyst – ETL Focused
Location: East Midlands
The Company: This is no straightforward Data Analyst position. The role is an integral part of a small but growing IT department supporting the business in delivering 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 company’s 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 runs.
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 moving it to a common data platform is essential. A solid understanding of data structures and BI tools will be required to create a cohesive platform where data moves between systems and provides 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 of 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 Data Warehouse build on Azure and a self-service reporting build among 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.
#J-18808-Ljbffr
ETL Focused Data Analyst - Triple Growth Business in Health Sector REF 901 employer: Interface Recruitment UK
Contact Detail:
Interface Recruitment UK Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land ETL Focused Data Analyst - Triple Growth Business in Health Sector REF 901
✨Tip Number 1
Familiarise yourself with the Microsoft Business Intelligence Stack, especially Power BI and data-driven programming languages like 'M'. This knowledge will not only help you understand the role better but also demonstrate your commitment to mastering the tools used in the position.
✨Tip Number 2
Network with professionals in the healthcare and data analytics sectors. Attend relevant meetups or webinars to connect with individuals who may have insights into the company or the industry, which can give you an edge during discussions.
✨Tip Number 3
Prepare to discuss your experience with ETL processes in detail. Be ready to share specific examples of how you've extracted, transformed, and loaded data in previous roles, as this will showcase your practical skills and problem-solving abilities.
✨Tip Number 4
Research the company's recent projects and initiatives, particularly those related to data analysis and growth strategies. This will allow you to engage in meaningful conversations about how you can contribute to their goals and align your skills with their needs.
We think you need these skills to ace ETL Focused Data Analyst - Triple Growth Business in Health Sector REF 901
Some tips for your application 🫡
Understand the Role: Before applying, make sure you fully understand the responsibilities and requirements of the ETL Focused Data Analyst position. Familiarise yourself with the key skills mentioned in the job description, such as ETL procedures, SQL management, and experience with Power BI.
Craft a Tailored Cover Letter: Since the company encourages discussing motivations rather than submitting a CV initially, write a compelling cover letter that highlights your relevant experience and enthusiasm for the role. Mention specific projects or experiences that demonstrate your ETL expertise and analytical skills.
Showcase Relevant Skills: In your application, emphasise your proficiency in DAX, M, MDX, and SQL Server. Provide examples of how you've used these skills in previous roles to extract and transform data, as well as any experience with reporting tools like Power BI or Tableau.
Express Your Motivation: Clearly articulate why you are interested in this role and how it aligns with your career goals. Discuss your passion for data analysis and how you can contribute to the company's growth, especially in the context of their focus on leveraging data for business decisions.
How to prepare for a job interview at Interface Recruitment UK
✨Showcase Your ETL Expertise
Make sure to highlight your experience with ETL processes during the interview. Be prepared to discuss specific projects where you extracted, transformed, and loaded data, especially using tools like SQL Server and the MSBI stack.
✨Demonstrate Analytical Skills
Prepare examples that showcase your ability to analyse and interpret data effectively. Discuss how your insights have led to business improvements or streamlined processes in previous roles.
✨Familiarise Yourself with Microsoft Azure
Since the company is leveraging Microsoft Azure for their IT infrastructure, it’s beneficial to understand its functionalities. Brush up on how Azure integrates with ETL processes and be ready to discuss any relevant experience you have.
✨Emphasise Interpersonal Skills
Given the collaborative nature of the role, be sure to convey your strong interpersonal skills. Share examples of how you've worked effectively within a team, particularly in cross-functional settings, to achieve common goals.