Head Resourcing are looking for a senior SQL developer for a mutual society based in Glasgow. In this role you will be responsible for maintaining and developing SQL procedures and queries as part of providing Sonata and MGM Talisman development support within the company.
In addition, you will be required to develop and maintain SSIS packages that extract and transform data from our policy admin systems for consumption by internal and 3rd party stakeholders, including development using XSL in the format of correspondence templates within Sonata. You will also be responsible for mentoring and reviewing the code of the junior members of the team.
This role is based in Glasgow 2 days per week. Pays between £50 - £58k and a 10% employer pension. This role does not offer sponsorship.
Job responsibilities
- Data manipulation and analysis using SQL and Oracle tools and writing/maintaining stored procedures
- Development and maintenance of SSIS packages
- Problem solve and debug SSIS/SQL issues
- Development and maintenance of XSL Stylesheets
- Follow the development lifecycle and release process for production implementations and fixes
- Requirements gathering, analysis, effort estimation, and solution design of new SQL projects within the business
- Testing, deploying, and maintaining SQL projects and fixes in line with best practices
- Understanding complex problems requiring a SQL solution or bespoke solution within the business software application
Knowledge/skills
- Advanced T-SQL/PL-SQL Development experience
- Advanced skills in SSIS
- Understanding of XSL
- Experience mentoring junior members
- Understanding of Java and APIs desirable
- Some software release mangement as well would be great
