Data Engineer

Job Description

Core Responsibilities

 Development of solutions for data engineering using relevant tech stacks

 Maintain the integrity of both the design and the data that is held within the architecture

 Adopt software development lifecycle and use of data engineering best practises

 Support the Data Engineering leads and be proactive in delivering solutions

 Contribute to the development of database management services and associated processes relating to the delivery of data solutions

 Provide requirements analysis, documentation, development, delivery and maintenance of data platforms.

 Develop database requirements in a structured and logical manner ensuring delivery is aligned with business prioritisation and best

practise

 Deliver performance enhancements, application migration processes and version upgrades across a pipeline of BI environments.

 Provide support for the scoping and delivery of BI capability to internal users.

 Work with clients, existing asset owners & their service providers and non BI development staff to clarify and deliver work stream

objectives in timescales that deliver to the overall project expectations.

 Develop and maintain documentation in support of all BI processes.

 Proactively identify cost-justifiable improvements to data manipulation processes.

 Research and promote relevant BI tools and processes that contribute to increased efficiency and capability in support of corporate

objectives.

 Promote a culture that embraces change, continuous improvement and a 'can do' attitude.

 Demonstrate enthusiasm and self-motivation at all times.

 Establish effective working relationships with other internal teams to drive improved efficiency and effective processes.

 Be a champion for high quality data and use of strategic data repositories, associated relational model, and Data Warehouse for

optimising the delivery of accurate, consistent and reliable business intelligence

 Ensure that you fully understand and comply with the organisation's Risk Management Policies as they relate to your area of

responsibility and demonstrate in your day to day work that you put customers at the heart of everything you do.

 Ensure that you fully understand and comply with the organisation's Data Governance Policies as they relate to your area of responsibility

and demonstrate in your day to day work that you treat data as an important corporate asset which must be protected and managed.

Experience Requirements

 Total 4 to 7 years of experience is essential

 4+ years Data Engineering / ETL development experience is essential

 3 years data design experience in an MI / BI / Analytics environment (Kimball, lake house, data lake) is essential

 3 years' experience of working in a structured Change Management project lifecycle is essential

 Experience of working in a financial services environment is desirable

 Experience of dealing with senior management within a large organisation is desirable

 3 years' experience of developing in conjunction with large complex projects and programmes is desirable

 Experience mentoring other members of the team on best practise and internal standards is essential

 Experience with cloud data platforms desirable (Microsoft Azure) is desirable

Knowledge Requirements

 A strong knowledge of business intelligence solutions and an ability to translate this into data solutions for the broader business is

essential

 Strong demonstrable knowledge of data warehouse methodologies

 Robust understanding of high level business processes is essential

 Understanding of data migration, including reconciliation, data cleanse and cutover is desirable

Skill and Competency Requirements

 Excellent Data Warehouse skills with substantial experience in extracting, reporting and manipulating data from a data warehouse

environment are essential

 Significant technical skills such as Transact SQL language, relational database skills are essential

 Ability to deliver complex data platforms and solutions is essential

 Excellent verbal and written communication skills are essential

 Business analysis skills are essential

 Good listening skills are essential

 Excellent organisational skills are essential

 Attention to detail is essential

 Ability to prioritise tasks and manage time effectively is essential

 Flexible approach and attitude is essential

Required Qualifications/Certifications

 GSCE/GCE qualifications in both Maths and English are essential

 Computing related degree or equivalent is desirable

 Microsoft SQL Server 2019 certification is desirable

Responsibilities re Information Security Management System (as per ISO 27001 Certification Requirements)

 Ensure strict adherence to company's security policies and procedures (for ex: Password policy, clear screen and clear desk policy, etc.)

 Take ownership of all the assets/information assigned and secure it in compliance with ISO 27001 standard implemented in the company.

 Co-operate and co-ordinate for the internal audits conducted in the company (complying to ISO 27001 standard).

 Report to the Incident Response Manager, any incidents you come across in the office with regard to Security threats like threats to

physical asset & stored information or any risks detrimental to the Security Policies of the company, etc.,.