Data Developer (ETL Developer)

Data Developer (ETL Developer)

Pay Rate to Umbrella: £570
Security Clearance: Active SC Clearance Mandatory
CV Deadline: 26.4.22
Interview Process: TBC

Contract Length: 6 months (No extension)
Location:Bristol – majority Remote occasional travel to office
IR35: INSIDE
Minimum Requirement:
• Development of ETL pipelines and BI reports including technical impact assessments for changes required by the business.
• Technical design for new developments, determining the appropriate approach for new applications and their relationship to existing environments and other systems.
• Support and enhancement of existing applications.
• Administration and maintenance of environments.
• Provide advice and guidance to projects on the potential use of applications, development approaches, tools and 3rd party components. Investigation of issues resulting from the use of 3rd party tools.
• Unit testing including the investigation and resolution of defects identified user acceptance testing.
• Creation and maintenance of consistent and comprehensive documentation for business systems, including the relationships between IT components and business functionality.
• Provide advice and guidance on potential uses of software across the Department.
• Deployment of solutions between environments, including LIVE environments.
Essential Criteria:
• Expert Knowledge of Informatica Intelligent Cloud Services (IICS)
• Expert Knowledge of T-SQL query.
• Knowledge of data warehouse architectures.
• Knowledge of BI tools such as PowerBI, Cognos
• Provision of advice and guidance to less experienced co-workers, including potentially trainees.
• Structured analysis and documentation of business requirements.
• Your core skills will be around ETL development, SQL Server query Having strong experience of both will be an advantage.
• Strong Experience, or relevant transferable skills, in four or more of the following:
• ETL development
• SQL Coding in T-SQL
• Developing Reports in Power BI
• Full understanding of the MS-SQL stack
• Efficient and conformant Database Design skills
• Knowledge and experience of SQL Optimisation techniques
• SQL Troubleshooting skills – across and within systems
Desirable Skills:
• Knowledge of Development Patterns relevant to Web and SOA designs.
• Knowledge of CI/CD development.
• Knowledge of azure Dev ops.
• Knowledge of Version Control software
• Knowledge of Cognos, including Data Manager, Framework Manager and Reports Studio
• Experience of Power BI portal Administration
• Experience of working with Cognos, including Cognos Data Manager.
• Experience of working in the financial services sector.