Home/Careers/Data and Analytics/Data Warehousing and Integration Specialist

Data Warehousing and Integration Specialist

June 21, 2022

Apply for this job

Job summary

We are looking for strong individuals, with a willingness to learn and excellent baseline skills in SQL data warehousing and integration with a background in consultancy and knowledge of NHS datasets. The individual will be working in a growing team, supporting the implementation of a mature Data Platform delivering real value to NHS organisations. Implementation is expected to be centred around Cloud (Azure) architecture in the future, providing a platform for strong candidates to begin to develop their skills or further take their existing skills to new levels.

Accountabilities and main responsibilities

You will be part of a team, bringing a new and innovative approach to the delivery of data warehousing (and analytics) into healthcare. Your skills will support clients in designing and building new Data Warehouses in SQL, deploying new and modern data warehouse architectures, supporting integration of complex datasets and developing new features and tools on the existing Data Platform. We are looking for passionate individuals, capable of working autonomously, but also in our team and bringing insight, energy, new approaches and techniques to the NHS data warehousing and integration market. You will support Trustmarque in continuing to be at the leading edge of data warehousing and integration in health. The majority of our delivery work is currently remote, this may change in the future, but it is anticipated to remain significantly remote. Responsibilities include:

• Delivery, maintenance and providing end client support and training for a Cloud based data platform.

• Working in the technical Analytics and Data team to develop new insight and tools that deliver value for our clients.

• Maintaining and developing technical skills in new areas featuring MS Azure Analytics stack.

• Becomes a valued part of the Analytics Team, sharing your skills and experience throughout the team, and learning from others.

• Lead programmes and projects in Data Warehousing and integration.

• Experience of SQL Server upgrades, version/deployment differences.

• Experience of using Microsoft SQL Server (Database and SSIS) and in more general the Microsoft SQL “stack”.

• Demonstrable understanding of Data Warehousing in Azure (Managed Instances / PaaS)

• Demonstrable ability in defining complex integration pipelines and transformations in both on premise SSIS and/or Azure Data Factory.

• Demonstrable skills in SQL Server Analysis Services.

• Demonstrable experience of building complex data migration strategies and architectures.

• Development of requirements to support specific user environments such as on premise, hybrid, and Cloud deployments.

• Excellent interpersonal skills and ability to demonstrate working in co-operation with internal and operational (client) staff.

• Excellent self-starting and time / project management skills and the ability to operate in a flexible and changeable environment

• The ability to work in a multidisciplinary team where other people may have different views that need to be incorporated.

•  Knowledge of NHS data sets would be a distinct advantage.

• Data Factory including development & deployment of pipelines and datasets

• Data Lakes (Azure) • Modern Data architectures to support high performance analytics.

• Microsoft DevOps including CI/CD

• Knowledge of Microsoft Synapse would be a distinct advantage.

• Skills in Azure Analysis Services. • Experience in working on projects that involve change management.

• Supporting sales processes, business development, proposal writing.

About Trustmarque

At Trustmarque we strive to help our customers go further, innovate faster and achieve more through technology-enabled transformation. By making IT all about our customers, we pledge a partnership that ensures technology works to their advantage.

Our people are at the heart of our customer-centric business. When you join Trustmarque, you will work with some of the best experts in their field. Since mid-March 2020, all our staff have been working remotely and are given all the tools to work with effectively. Alongside this, we support our people’s mental health through regular work and well-being seminars and a team of dedicated mental health champions.

All interviews, assessments and background checks will continue to take place online, to completely remove the need for face-to-face contact. All Capita colleagues who can work from home should do so; and where it is not possible for colleagues to work remotely, we have taken important steps to protect those working from Capita’s offices. Social distancing, enhanced hygiene and safety measures are already in place at all Capita locations that are open to protect our colleagues and manage the risk of COVID-19. The welfare of our people is of paramount importance to us, and we’re doing everything we can to keep our colleagues and customers safe during this time.

Standard benefits

As well as competitive rates of pay, we offer a substantial benefits package which includes 25 days holiday (rising to 27), plus bank holidays, and the option to buy extra leave, a company-matched pension, life assurance, a cycle2work scheme and more.

Trustmarque is an award-winning IT partner that delivers IT solutions allowing our customers to work smarter and more effectively. We simplify business, through a flexible and cost-effective approach that empowers organisations and their people. Giving honest, simple, and independent advice we help our customers to navigate an increasingly complex world of IT – and that’s exactly what you’ll do too, if you join our talented team here.

Apply for this Job