Data Platform Engineer

Pinsent Masons; Birmingham; Hybrid; GBP 40,000 - 80,000

Job description

DATA PLATFORM ENGINEER - Any UK Office

Role Overview

We are looking for a Data Platform Engineer to join our Data Management team. You will be responsible for supporting the implementation, administration, and ongoing maintenance of data platforms in the cloud and on-premises.

Main Duties and Responsibilities

1. Support the Senior Data Platform Engineer and the Datacentre Transformation Project team in the implementation of a successful transition of the firm’s on-premises infrastructure to the Cloud.
2. Ensure that databases meet performance, scalability, and availability requirements.
3. Implement solutions and infrastructure with appropriate levels of security and encryption.
4. Implement an effective backup and recovery strategy under guidance of Senior Data Platform Engineer.
5. Maintain adequate and up-to-date documentation on the firm’s data infrastructure and platforms.
6. Ensure that backups are tested on a regular basis and that any failures are investigated and resolved.
7. Ensure that SQL and related servers are patched and maintained while minimising downtime.
8. Propose opportunities and strategies for automation and process improvement and take part in their implementation.
9. Implement and monitor processes to meet data archiving and retention requirements.
10. Implement high-availability solutions to computing infrastructure under the guidance of the Senior Data Platform Engineer.
11. Conduct regular security assessments to identify and address potential vulnerabilities in data infrastructure and platforms.
12. Optimise the use of hardware and software SQL instances to streamline resource utilisation.
13. Carry out performance monitoring and tuning of SQL instances and cloud-based database platforms, and implement measures to improve performance and reduce costs.
14. Stay current with emerging database technologies and be aware of their potential impact on the firm’s data platforms.
15. Provide support and guidance to business users and IT teams on the use of data platform technologies.
16. Follow processes and protocols for the protection of the firm’s data and systems.

Candidate Overview

The ideal candidate will be adaptable to change and ready to embrace complexity and new challenges with enthusiasm and determination. They will value diverse ideas and partner effectively with colleagues across the globe, and have an eagerness to learn and develop new skills. As well as this, they will have the following qualifications and experience:

1. Degree level candidate in computer science, systems analysis, mathematics, or a related field of study, or equivalent experience.
2. Good experience with SQL server and related technologies (T-SQL, SSIS, SSAS, SSRS).
3. Experience with cloud platforms, specifically Microsoft Azure, and related services (Azure SQL database, Azure Data Factory, Azure Backup).
4. Strong problem-solving skills and experience with troubleshooting and root cause analysis.
5. Knowledge of database design, performance optimisation, and troubleshooting.
6. Good understanding of security and compliance principles as they relate to data infrastructures and the management of data.
7. Great communication and interpersonal skills to work with a variety of stakeholders.

What can we offer you?

1. Agile working i.e. the opportunity to work from home, subject to diary commitments.
2. 25 days annual leave entitlement and the opportunity to purchase or roll over 5 days.
3. Contributory pension of up to 5%.
4. Private healthcare policy for the successful candidate and immediate family.
5. Death in service cover (4 x base salary).
6. Eligibility to apply for an interest free season ticket loan, an interest free gym membership loan and/or an interest free rental deposit loan.
7. Cycle to work scheme.

At Pinsent Masons we value diversity and inclusion. We are committed to creating a better workplace where all our talent can succeed and feel like they belong. We want to attract, retain and develop people at all levels and encourage applications from all suitably qualified candidates whatever your ethnicity, religion, age, physical or mental disability/ long term condition, sexual orientation, gender identity or expression or any other characteristics protected by local law in the jurisdictions in which we operate.

For any queries or for a copy of the full job description, please contact our in-house recruiter, Sim Dhonsi. Please note we only accept CVs that are logged on the Recruitment portal.

#LI-BOSD

#INDB