Everly Search Ltd
Data Engineer - Core MI
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Job Purpose
Responsible for the development and delivery of pipelines (collect, validate and prepare high quality data) to automate and streamline processes required by different departments across the bank. Support existing SSIS ETLs (overnight and intraday), proactively fine-tune and enhance existing codes to increase robustness and error monitoring. Support the internal IT department with changes and upgrades to software platforms. Develop and maintain UK and EU regulatory reports.
Principle Accountabilities and Duties
Software Development
- Analysis of issues pertaining to problems or errors raised by in-house systems, i.e. CORE, SharePoint interface, Equation, Kondor, Eximbills, end of day cycle.
- Understanding business requirements in order to develop and deliver appropriate solutions based on system definition documents.
- Proficiency in advanced 4GL programming languages and able to apply to the fully development life-cycle.
- Keep abreast and apply software development’s best practice.
Database Support
- To build data pipelines within the SQL environment in SSIS packages, where required, introduce new field and data types for new information to be collated in the CORE environment.
- To build reports based on business requirements using SQL SSRS.
- To integrate with all the Bank’s sub-systems using data abstraction and connectivity layers, i.e. ODBC, ADO.net.
- Ensure that the environment is running optimally and with high standard house-keeping procedures.
- To build tabular models (SSAS) for different business units.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
SharePoint Integration
- To integrate the SharePoint environment and Forms with Equation system to introduce automation of processes thereby eliminating the need for duplicate entry.
- To utilise web services to integrate from cutting edge technology into legacy systems such as Equation.
End of Day Cycle
- To provide second and third level support for in-house programmes during the end of day cycle.
- To be able to analyse and rectify any problems raised in an independent and team scenario.
- To take ownership of a problem and deliver a solution in a timely manner.
- Provide out of office hours support.
Risk & Regulatory Duties
- Maintain knowledge of all applicable regulatory requirements including the Bank's Risk and Compliance policies and procedures and adhere to these to avoid exposing the Bank to undue risk.
- Report policy/procedure breaches and areas of potential non-compliance and suspicions promptly upon identification in accordance with the Bank's Risk and Compliance policies.
- Accurately execute all controls within own area to minimise risk of policy, procedure, and/or regulatory breaches.
- Identify new risks/control gaps within own area and escalate accordingly to your Line Manager.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Qualifications, Knowledge, Skills, Experience Required
Qualifications/Experience
- Degree level qualified or equivalent
- Microsoft SSIS – 7 years plus
- Microsoft SSAS, SSRS – 2 years plus
- C# Programming for Web application – 7 years plus
- Windows application – 2 years plus
Knowledge and Skills
- Software analysis and design good practice -- essential
- Second-line and Third-line Application Support -- essential
- Effective problem solving - essential
- Critical thinking - essential
- Dimensional modelling, Entity Relationship modelling, Normalised modelling – desirable
- Data warehouse design concepts, (Inmon, Kimball) -– desirable
To apply for this role
Please submit your cv to jasemin@everlysearch.com
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location