Data Engineer at Co-operative Bank of Kenya

Job reference number DE/SSD/2019

Are you looking for an employer who promotes individual excellence and mutual respect in a team-driven culture with a key focus on social empowerment? The Co-operative Bank of Kenya, “The Kingdom bank” is the place for those looking to new horizons.

We seek a fearless inventor with an artistic streak who can find creative solutions to tough problems and sculpt brilliant strategies from a mountain of data, someone who can create the digital equivalent of Mona Lisa with only an algorithm and a smile.

Reporting to the Head – Business Intelligence, the Data Engineer will be responsible for developing, maintaining, testing, evaluating and implementing data solutions and data architecture design.

Responsibilities

• Identify, analyze and interpret trends or patterns in complex data sets using statistical techniques and provide reports. Acquire data from primary or secondary data sources, maintain databases/data systems, and apply ETL procedures to normalize data.
• Gather information from business users to understand their detailed requirements and expectations, analyze business/use case requirements from BI analysts to determine operational problems, define data modelling requirements, gather and validate information, apply judgement and statistical tests and develop data structures to support the generation of business insights and strategy.
• Carry out analysis of requirements and recommend solutions to address user requirements. Manage the queue of requests and communicate to the appropriate advanced analytics, BI or data management functions.
• Assist in preparing system definition/specification by the users highlighting technical requirements and roll out BI Solutions to stakeholders. Assist in developing and implementing a program of continuous improvement of BI processes through a cycle of analysis of existing systems, processes and tools, identifying areas for improvement, implement high impact changes and get feedback from stakeholders. Make changes to system/database configurations and parameters to accommodate business and technological requirements.
• Build visualizations to summarize and make presentations to business and other key stakeholders. Filter, clean data and review reports, print outs and performance indicators to locate and correct code problems.
• Secure BI solutions by putting adequate controls and restrict access to programs by users in accordance to the requirements of the Bank.
• Understand Key Performance Measures and Indicators that drive company performance measurement and reporting as well as analytics across functions and understand how these metrics and measures align and track against overall business strategies, goals and objectives.
• Guide the business in drawing report formats & wireframes and advice on the best approach to transform data and automate reports as well as Design and code reports/dashboards according to user specification with the key objective to deliver reports that will assist in decision-making and control.
• Develop and maintain documentation/manuals on system configuration or set up, carry out technical user training as required to enable users interpret BI reports as well as deal with data, dashboards and report queries from users and resolve or advise them accordingly.

Qualifications

• Bachelor of Science degree in Computer Science, IT, Engineering or any other degree in related fields.
• A minimum of 2 years’ experience in BI & Software Development using Oracle.
• Experience with relational data modeling, data management and data processing. Knowledge of statistics and experience using statistical packages in analyzing large data sets (Excel, SPS, SAS etc.) will be an added advantage.
• Technical expertise regarding data models, database design development, data mining and segmentation techniques is desired.
•  Strong knowledge of and experience with ETL tools such as Oracle ODI and Microsoft SSIS.
• Very good knowledge of Windows Operating Systems and a fair knowledge of Unix & Linux.
• A good understanding of relational databases, particularly Oracle.
• Good understanding of programming languages; specifically experience in database programming languages such as Oracle PL/SQL and SQL Server TSQL.
• Experience in analysis, design and development of efficient business systems
• Good knowledge of reporting and business analytics tools such as such as OBIEE, Microsoft SSRS.