Our technology team sits at the heart of the organisation, ensuring that internal and external users benefit from the most efficient and user-friendly applications and services.
As Senior Technical Application Analyst within the IT Application Support Team you will be responsible for the design and development of coding solutions to support BAU and small project initiatives across the business. You will be required to help lead the work of Application Support teams and work closely with business stakeholders and analysts to provide valuable technical insight and expertise into solution design of complex problems, working to best practices to ensure robust outcomes.
The role will require you to be extremely proficient in SQL coding, including SSIS and have an excellent understanding of relational database design. In addition, you will serve as a source of technical knowledge for other developers and the wider IT development team, conducting code reviews and performing production implementations.
Key Responsibilities
* Contribute to leading the design and development of new coding initiatives within Scottish Friendly and recommend improvements to existing processes that utilise our core Policy Admin Systems.
* 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.
* 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.
* Conduct code reviews and provide recommendations and advise on changes.
* Implement code fixes into production as per the release process.
* Understanding complex problems requiring a SQL solution or bespoke solution within the business software application.
* Providing Tier 3 Application support to the business.
* Be a source of technical expertise for the IT Development team and wider business.
Desired Skills and Experience
* Advanced T-SQL/PL-SQL Development experience.
* Advanced skills in SSIS.
* Understanding of XSL.
* Understanding of Java and APIs desirable.
* Strong understanding of integrations, data flows, and batch processing.
* Basic scripting (Sybase, Python, Power BI)
* A logical thinker with initiative and ability to problem solve.
* Desire to learn, willingness to take on completely new tasks and work through to implementation.
* Being able to manage multiple tasks and meet development deadlines.
* Strong interpersonal skills to work with colleagues across the business as well as being able to communicate technical ideas to non-technical stakeholders.
* Awareness/experience of workflow solutions within Application Software, specifically Sonata.
* Experience in wealth management, life administration, pensions, and savings and investments are desirable.
#J-18808-Ljbffr