As a member of this team, you will contribute to the development and maintenance of our existing systems, as well as establishing how our data-driven solutions are developed and coded. You will be encouraged to contribute your own ideas and expertise, as well as to keep your skills up to date through training and learning.
The position reports to the Head of Integration and you will have the opportunity to engage with multiple teams across a number of different technological disciplines and geographical locations.
Core Responsibilities
Monitor and maintain core ETL processes.
Troubleshooting and problem resolution for MS SQL Server related issues.
Work closely with senior database developers to document requirements, design technical solutions and attend project workshops and meetings.
Develop changes in T-SQL and SSIS for both "business as usual" and project work streams.
Model and document SQL data mapping solutions, working with business and other technical teams to decide on the best solution.
Assist with regular releases to live systems and monitor monthly data processing batches.
Proactively suggest improvements to code, tools and ways of working.
Essential Skills
Minimum of 5 years' experience in developing and supporting SQL Server solutions
Expertise in T-SQL, including writing complex stored procedures, views and triggers
Experience of developing ETL routines utilising SSIS
Have knowledge and experience of OLAP and OLTP environments
Excellent problem-solving skills and a flair for reverse engineering complex code
Experience working with Agile development methodologies
Highly Desirable
C#, VB.net or any other programming language
Git or other source control expertise
Experience of continuous integration/delivery
Experience in SQL Server Reporting Services or other reporting tools
Experience working in an Agile team utilizing SAFe
The Person
A real self-starter, happy to see a project or issue through to the end
Passionate about technology and applying it to business solutions
Enthusiastic and possessing a "can do" attitude
Have a track record of getting things done whilst adhering to a governance framework
A passion for SQL Server and all things data related