Role Overview:
We are seeking a Technical Business Analyst with SQL experience to support a data remediation and operational controls programme within a regulated banking environment.
This is a hybrid BA/SQL role requiring someone who can bridge business requirements and technical data activities. The successful candidate will be responsible for documenting requirements and processes, developing and validating SQL-based population controls, supporting regular data operations, and ensuring robust governance and operational controls are in place.
Key Responsibilities:
Business Analysis & Documentation
- Complete and maintain Business Requirement Documents (BRDs) for data population control processes.
- Elicit and document business and technical requirements from stakeholders.
- Translate operational and regulatory requirements into clear, structured process documentation.
- Create and maintain Standard Operating Procedures (SOPs) for recurring data activities and controls.
- Support process improvement initiatives and identify opportunities to enhance operational efficiency.
SQL & Data Analysis
- Write and execute SQL queries, including complex joins and data extraction activities.
- Document SQL logic used to identify and extract customer populations.
- Perform data validation, sample testing, and reconciliation activities to ensure outputs are accurate and fit for purpose.
- Investigate data issues and support root-cause analysis.
- Produce and maintain management information (MI) and reporting outputs.
Population Controls & Data Processes
- Design and implement population control processes.
- Validate data populations and ensure appropriate governance and audit trails are maintained.
- Support sanctions screening, CRA pre-check activities, customer communications, and operational data processes.
- Manage and monitor regular data runs, ensuring all controls are completed and evidenced.
Process Governance & Operational Support
- Create and enhance SOPs covering:
- SharePoint operational processes and data outputs
- Sanctions screening updates
- CRA pre-check work item management
- Third-party supplier input/output processes
- MI production and reporting activities
- Ensure all processes are documented, controlled, and aligned to regulatory expectations.
We are seeking a Technical Business Analyst with SQL experience to support a data remediation and operational controls programme within a regulated banking environment.
This is a hybrid BA/SQL role requiring someone who can bridge business requirements and technical data activities. The successful candidate will be responsible for documenting requirements and processes, developing and validating SQL-based population controls, supporting regular data operations, and ensuring robust governance and operational controls are in place.
Key Responsibilities:
Business Analysis & Documentation
- Complete and maintain Business Requirement Documents (BRDs) for data population control processes.
- Elicit and document business and technical requirements from stakeholders.
- Translate operational and regulatory requirements into clear, structured process documentation.
- Create and maintain Standard Operating Procedures (SOPs) for recurring data activities and controls.
- Support process improvement initiatives and identify opportunities to enhance operational efficiency.
SQL & Data Analysis
- Write and execute SQL queries, including complex joins and data extraction activities.
- Document SQL logic used to identify and extract customer populations.
- Perform data validation, sample testing, and reconciliation activities to ensure outputs are accurate and fit for purpose.
- Investigate data issues and support root-cause analysis.
- Produce and maintain management information (MI) and reporting outputs.
Population Controls & Data Processes
- Design and implement population control processes.
- Validate data populations and ensure appropriate governance and audit trails are maintained.
- Support sanctions screening, CRA pre-check activities, customer communications, and operational data processes.
- Manage and monitor regular data runs, ensuring all controls are completed and evidenced.
Process Governance & Operational Support
- Create and enhance SOPs covering:
- SharePoint operational processes and data outputs
- Sanctions screening updates
- CRA pre-check work item management
- Third-party supplier input/output processes
- MI production and reporting activities
- Ensure all processes are documented, controlled, and aligned to regulatory expectations.
Requirements
Essential Skills & Experience; Proven experience as a Business Analyst with strong SQL skills.; Ability to write, understand, and troubleshoot SQL queries, including joins and data validation activities.; Experience producing BRDs, process maps, SOPs, and operational documentation.; Strong data analysis and reconciliation experience.; Experience working within banking, financial services, or other regulated environments.; Strong stakeholder management and communication skills.; Excellent attention to detail and governance mindset.; Desirable Experience; Remediation, complaints, customer outcomes, or regulatory change programmes.; Data quality, data controls, or population control activities.; Exposure to sanctions screening, customer remediation, or operational risk programmes.; SharePoint and MI reporting experience.; Experience working with third-party suppliers and operational delivery teams.; How We Work:; Who We Are:; Our 3 offerings are:; Managed Services; Consulting & Solutions; Technology; To know more about Delta Capita and our culture click here: Working at DC - Delta Capita .Jak aplikować
Aplikuj online: https://www.jobs.pl/oferta/100078706/aplikuj
JOBS.pl · https://www.jobs.pl/ba-sql-consultant-oferta-100078706
