Senior Data Integration Development Specialist

This job is with FSCS, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly.

In today's digital world, ensuring we remain at the forefront of data and technology is critical to our success and stability. As part of our Data, Intelligence and Technology teams, you'll be responsible for helping to deliver outstanding digital experiences for our customers and our people. Our different teams work together to provide essential data insights that support and enhance our operations and strategic decisions, develop the essential platforms that underpin our work, and protect our digital security. The Role Within this role you will be responsible for delivering high quality Data applications, ETL processes and operational reports following development best practices and security standards, as well as providing 2nd and 3rd level support for those same applications. This role will work closely with our suppliers and partners delivering solutions to meet the business needs. Key Priorities Work with business users and SCRUM team to ensure business requirements are defined and agreed, co-ordinating requests for enhancements and developments for FSCS IT controlled applications. Collaborate with the Development Manager to design, develop, optimize and support data applications following development best practices, using the appropriate tools and adhering to the most efficient development process. Deliver development and enhancement activities in support of the business raised change requests and releases working closely with the CDITO Teams, Partners and Suppliers. Coordinate and direct suppliers where 3rd party suppliers are required to deliver the end-to end application support capability, ensuring end-users are regularly updated on progress against their service request /incident /problem /change request. Responsible for monitoring data applications and ETL processes and proactively act upon any detected issues. Key Knowledge, Skills and Experience Good organisation skills with a logical, analytical approach to solving IT problems and the ability to prioritise work to meet demands and deadlines of both application development and support. Work effectively following the SCRUM methodology. Working closely with Product Manager and alongside the development team Ability to work on your own initiative whilst at the same time adhering to strict IT policies and procedures. Willingness to record, capture and document all tasks and projects without exception through the appropriate IT process/procedure. Experience Significant experience developing and implementing data solutions in a high-volume data loading environment Excellent understanding of SSIS framework, ADF data pipelines, administration, maintenance and configuration Considerable experience and clear demonstration of T-SQL programming - be able to write/review scripts in SQL including stored procedures Solution design and architecture Quality Assurance and best practice Previous experience working in continuous delivery within the agile mindset Technical Skills Microsoft SQL Server 2019 or higher SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS) Dynamics 365 integration using KingswaySoft Creating complex T-SQL queries (Dynamic SQL, Cursors etc.) SQL Stored Procedures and Functions Visual Studio 2015 or higher Design of complex SSIS or DTSX packages using Package and Project deployment configurations CI/CD Version control and branching methodologies using GIT Application integration using SOAP web services and REST APIs OWASP Top 10 security framework Agile and SCRUM Desirable Azure Integration services including Logic Apps and Azure Functions. ITIL experience and qualifications AI working knowledge Working at the FSCS At FSCS we are purpose driven and committed to delivering an exceptional service and results for our customers. We have invested greatly in a flexible people offering that we're proud of, that our employees love and that supports and promotes diversity, inclusion, and overall wellbeing. Key benefits include: Employer pension contributions from 9% - 15% dependant on your contributions and length of service Life assurance, income and critical illness protection Private medical and dental insurance EAP and Virtual GP 26 days annual leave + bank holidays and the option to sell 5 or buy up to 9 additional days per annum to suit your lifestyle Enhanced Maternity, Paternity and Adoption leave - 6 months full pay Additional discounts and options to earn rewards to spend at your choice of retailer To Apply Use the Apply Now button to apply. We are happy to consider any reasonable adjustments that candidates may need during the recruitment process and within a future role. You will be asked whether you require any adjustments during your application and you can also contact our recruitment team at to discuss this further if helpful. #LI-DNI