Senior Data Integration Development Specialist
This is a Permanent, Full Time vacancy that will close in {x} days at {xx:xx} BST.
The Vacancy
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 recruitment@fscs.org.uk to discuss this further if helpful.
About Us
For the past 21 years, FSCS has been getting customers of failed authorised financial services firms back on track.
Our strength is in our numbers. Since 2001, we have helped 6.5m customers and paid back £26bn in compensation. Over the years we have continually strived to be better, faster, and more empathetic to our customers’ needs in an ever more complex financial world. Our people have worked together to make sure we can offer protection and reassurance every step of the way, even during the toughest of times over the last two years. FSCS is an organisation that makes a difference, and in which our people truly make a difference.
We have grown from modest beginnings in 2001 to helping customers during historic events such as the 2008 banking crisis and supporting vulnerable customers during the pandemic. As a result of this success, FSCS has become increasingly respected, insightful, and influential in the regulatory eco-system. It is an exciting time in our journey as we now have an opportunity to play a bigger role in breaking the cycle of rising consumer harm and costs; by being part of a system that is about prevention rather than cure.
Our Strategy
What we are aiming for
We shall respond to large and complex firm failures, whilst maintaining our seven-day pay-out for savers in banks, building societies and credit unions. We will actively contribute to increasingly effective resolution when firms fail.
Why this matters
FSCS needs to contribute to public confidence and financial stability by being ready to respond when called upon across the full range of protected products.
Our approach
- Maintain well-tested contingency plans, backed by necessary capabilities and robust customer information.
- Collaborate with industry to improve the customer information we rely on for payouts.
- Improve our ability to respond quickly to investment and insurance failures.
- Work with industry and regulators to improve resolution arrangements.
What we are aiming for
FSCS is known and trusted for protection that puts people back on track through outstanding customer experience.
Why this matters
Customer expectations are rising. The service our customers receive must meet their expectations in terms of speed, accessibility and ease of use, in order to maintain consumer trust and confidence.
Our approach
- Exploit digital technology to create the service our customers expect, at lower cost to our levy payers.
- Improve the speed of our service by eliminating time and process inefficiencies, particularly with third parties.
- Exploit our new strategic partnership - by drawing on our partner's expertise, scale and experience.
- Provide continuity of cover for policyholders in failed insurance companies.
What we are aiming for
We shall raise awareness of FSCS protection across all of the products and services we protect, particularly retirement savings products.
Why this matters
Awareness of, and trust in, FSCS protection maintains confidence in a crisis. Awareness also helps to inform people's choices by increasing their confidence in buying protected services and understanding the risks of unprotected products.
Our approach
- Partner with the industry to raise awareness of FSCS protection across all protected products and services, focusing on retirement savings initially.
- Engage with consumers and provide information to help people understand protection and make informed decisions.
- Encourage customers of failed firms to come directly to FSCS with their claim.
- Work with our stakeholders to provide joined-up and easy to access information about FSCS protection.
What we are aiming for
We shall collaborate with the regulators and industry to prevent future failure and to reduce future compensation costs.
Why this matters
FSCS compensation costs are rising fast - we project that compensation may rise from £405 million in 2017/18, mainly driven by escalating pensions claims. These costs put pressure on firms' finances and are passed on to consumers.
Our approach
- Commit to joint action with the regulators and industry to identify and address the root causes of mis-selling and other conduct issues which drive failure and compensation costs.
- Ensure consumers are alerted more quickly to vulnerabilities and risks as they emerge.
- Work with our partners to improve co-ordination across government, industry and regulators, ensuring insights and intelligence are generated and acted on.
- Feed back lessons learnt as a creditor and from recoveries activity, including working with the insolvency and insurance markets.
- Develop FSCS' own capability to provide actionable intelligence.
Documents
Alternatively, please sign in with...
Published
Not PublishedClosing
in X days