Data Integration Development Lead
Financial Services Compensation Scheme
2021-12-03 07:34:43
salary: 80000.00 British Pound . GBP Annual
Barkingside, Greater London, United Kingdom
Job type: fulltime
Job industry: I.T. & Communications
Job description
Data Integration Development Lead - London - £70-80,000
The Data Integration Development Lead is 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. The lead will be required to work closely with our suppliers and partners delivering solutions to meet the business needs and therefore requires strong communication, planning, and co-ordination skills.
Application Development-
* Work with business users and SCRUM team to ensure business requirements are defined and agreed, co-ordinating requests for enhancements and developments for IT controlled applications
* Work with the Development Manager to ensure that the data integration team is following 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 CIO Teams, Partners and Suppliers
* Solution architecture and design
* Quality Assurance, including quality planning and controls for both internal and external Suppliers
* Advice and guidance to users in support of their application requirements
* Follow the IT Release Management process and control all IT application releases to the environment including:
o Reviewing release planning
o Discovery, documentation, resolution and escalation of release dependencies, risks, and issues
o Adherence to IT Change Management process and controls
o Formal communications to management and stakeholders
o Coordination of Environment and Configuration Management
o Coordinate release approval and closure
Application Support
* Provide 2nd and 3rd line support across key data applications. Categorising, prioritising, triaging, and progressing service requests, incidents, problems, and changes which are logged with IT, in-line with industry best practices (i.e., ITIL)
* 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
Essential
* Microsoft SQL Server 2012 or higher
* Azure SQL database
* SQL Server Integration Services (SSIS)
* SQL Server Reporting Services (SSRS)
* SQL Server Analysis Services (SSAS)
* Power BI
* Azure cloud platform
* Azure Data Factory
* 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
* Application integration using SOAP web services and REST APIs
* Agile and SCRUM
* Version control and branching methodologies using GIT
Spring acts as an employment agency for permanent recruitment and an employment business for the supply of temporary workers. The Spring Group UK is an Equal Opportunities Employer.
By applying for this role your details will be submitted to Spring. Our Candidate Privacy Information Statement explaining how we will use your information is available on our website.