SQL Systems Analyst
Recruiter
SidTech
Listed on
12th May 2021
Location
London
Type
Contract
Start Date
2021-05-11 00:00:00
This job has now expired please search on the home page to find live IT Jobs.
Inside IR35. Location: London (Near Moorgate and Aldgate) Department/Practice: Middle Office, Transaction Banking Job Purpose and primary objectives: Work on data analysis, discovery and mapping, and creation of low level design artefacts and data flow diagrams Key responsibilities (please specify if the position is an individual one or part of a team): It is a Team Lead role with hands on knowledge in Informatica & SQL DevelopmentExperience required:10+ Duration of the Assignment:6 months - 8 months
System Analyst: Main Purpose of the Role : ? To work on data analysis, discovery and mapping, and creation of low level design artefacts and data flow diagrams Key Responsibilities: ? Possess good/advanced SQL development skills (writing SQL, complex queries, understanding of store procedures/functions etc.) ? Relational databases with understanding of data models and entity relationships ? Adept at carrying data analysis/discovery - comparisons, linage, mapping, validating rules/conditions ? Creating technical documents e.g. Basic Design Documents, Data Mapping and Data Flows Diagrams ? Experience of working in structured development environment and development teams (developers, test, system analysts, project managers) ? Optimize and automate existing ETL and data-flow processes inclusive of file imports/exports, data-mart population and data-refresh processes. ? Assist in identification and resolution of data quality and performance related issues. ? Provide guidance in the utilization of development techniques and tools to management and staff members promoting a high standard of execution. ? Strong knowledge in data warehousing concepts. ? Understand Logical and Physical data modeling best practices and techniques ? Skills and Experience: ? Banking, Finance or Financials Service and has worked in Screening or Controls/audit sector (Must have) ? Basic/good knowledge of Screening systems and processes ? Knowledge of key screening concepts, processes and datasets e.g. KYC compliance framework, AML Screening process, Anti-Money Laundering compliance, Customer Identification, Customer Due Diligence (CDD) and Enhanced Due Diligence (EDD) Work Experience: ? Ability to work both independently and collaboratively in a fast-paced environment ? Team Lead Experience of managing 5 - 10 associates ? Mentoring juniors and code reviews