Job Description:
Data Engineering SAS/SQL/Snowflake Specialist/Engineer (Senior Business Analyst)
Hybrid: up to 3 days WFH
London/Hybrid
Permanent
From £50.5k - £75.8k DOE and location + fantastic benefits
Full time: 37.5 hours per week
We consider all types of flexibility, including locations, hours and working patterns.
How you’ll help us make health happen:
You will be an expert in the use of and coding in SAS/SQL coding languages and expert with use of SAS Enterprise Guide or SAS Viya. You will be enthusiastic when talking about complex table joins. You will be able to talk about your experience with platform migrations and how you overcame the problems in that.
You will enthuse about code optimisation and data structuring and talk with pride about your technical ability.
You will be familiar with having to find data in source systems, helping to engineer solutions that make that data available for analytic work in the warehouse or Snowflake environment. Data that you create will be used for your own analytics or structured and presented for other analysts to use.
You will be happy and confident talking about these things at a face to face interview with other similarly skilled senior technical team members.
The role is part of the Data Operations team within the overall UKI Data & Analytics department, with the aim of developing new analytic and production data solutions, based on the principals of production effectiveness and optimisation. You will develop a sound knowledge of the business operations, with a high level of data technical expertise. You will work with fellow analysts, non technical business managers and colleagues in IT services, to understand the desired outcome and what insights are necessary for their decision making.
You will communicate effectively and clearly, both technically and in layman’s terms, to help colleagues understand the work.
You will use listening and questioning techniques to fully establish business needs and help evolve business requirements and solutions.
Contribute to or lead components of ongoing legacy solutions migrations.
You may be required to help run month end production process to facilitate re-engineering solutions, as we evolve the automation of these and migrate from SAS EG to SAS Viya and Snowflake hosted data solutions.
Key Skills needed for this role:
The accountabilities and responsibilities of the role will vary according to the specific assignment(s) at any one time:-
1. End to end development and testing of new production codes and processes.
2. Work on tasks that are purely technology driven as well as those that are business and regulatory focused, needing data exploration and agile solution development.
3. Establish quality checking procedures on new code solutions and they are effective, robust and appropriate.
4. Liaise with other teams and departments e.g. UK IT, to ensure that data flow for new initiatives are productionised.
5. Understand the importance of and adhere to information governance rules, including the importance of data lineage.
6. Make recommendation for improvements, actively looking for opportunities to optimise existing business data solutions. This could be a short term thing or a log term project.
7. Ensure all necessary documentation is maintained and updated after any change e.g. the service catalogue, data dictionary, entity relationship diagrams, operations manual. This applies to the whole team.
8. Consult with and manage working relationships across Bupa, internal customers and partners as required.
9. Partner with colleagues in other teams and departments on the delivery of new Bupa projects.
10. Work with the Data Operations Manager on development initiaves that are going to be handed over to the production team.
Technical Qualifications, skills and experience
The role holder is expected to have the following qualification(s), skills and experience:
11. Experienced in at least one: SQL dialect (T-SQL, PostgreSQL, MSSQL, MYSQL) and SAS language is essential.
12. Proven, strong experience of using industry standard tools and processing with large complex and intricate datamarts and datasets.
13. Experience with health care and finance data sets is an advantage, experience in a database programming languages strongly preferred.
14. Experience in working with RDMS such as Oracle or SQL Server and cloud-based data platforms, Snowflake preferred.
15. Excellent organisational ability in a fast-paced environment.
16. Proven experience in working on multiple concurrent projects.
17. Proven experience in process change, including reconciliation of outputs.
18. Ability to understand where efficiencies can be gained from application of technology and taking the appropriate course of action to implement and deliver benefits.
19. Ability to solve complex problems and communicate clearly and effectively.
20. Ability to work on own initiative, managing and prioritising workload.
21. Ability to work independently but also within a team environment, being flexible in taking on various projects.
22. Ability to make calm and rational decisions in a pressurised environment.
23. Willingness to take ownership of issues, ensure all interested parties are kept informed of progress and deliver solutions.
24. Strong attention to detail.
25. Ability to deal responsibly with confidential data, having an understanding of data governance controls.
26. Positive 'can-do' attitude.
Benefits
Our benefits are designed to make health happen for our people. Viva is our global wellbeing programme and includes all aspects of our health – from mental and physical, to financial, social and environmental wellbeing. We support flexible working and have a range of family friendly benefits.
Joining Bupa in this role you will receive the following benefits and more:
• 25 days holiday, increasing through length of service, with option to buy or sell
• Bupa health insurance as a benefit in kind
• An enhanced pension plan and life insurance
• Onsite gyms or local discounts where no onsite gym available
• Various other benefits and online discounts
Why Bupa?
We’re a health insurer and provider. With no shareholders, our customers are our focus. Our people are all driven by the same purpose – helping people live longer, healthier, happier lives and making a better world. We make health happen by being brave, caring and responsible in everything we do.