Data Engineer Uganda Development Bank Limited

JOB TITLE: Data Engineer
REPORTS TO : Manager Digital Innovations
DEPARTMENT: Finance & Business Operations
SUPERVISES : Nil
SCALE: UDBL 05
LOCATION: Head Office

JOB SUMMARY/PURPOSE
Responsible for preparing data for analytical and/or operational uses. Also responsible for building data pipelines to bring together information from different source systems and integrate, consolidate and cleanse data and structure it for use in analytics applications. They will make data easily accessible and will work to optimize UDBL’s
big data ecosystem.

ACCOUNTABILITY STATEMENT
The data engineer will prepare and organize the data that UDBL has existing in numerous internal and external databases accessed and in other formats. They will also build data pipelines that make data available to data scientists. They will deal with both structured and
unstructured data.

PRINCIPLE DUTIES & RESPONSIBILITIES
• The role holder will own, manage and configure the Business Intelligence (BI) platform(s) and interactive dashboards, as well as establish connections among data warehouses, data lakes and other data sources both internal and external.
• The role holder will improve data transparency and enable the UDBL analysts at all levels to facilitate the business to make more trustworthy BI-driven business decisions.
The role holder will facilitate and organize end-to-end data collection, intake, and processing plus support systems architecture design.
• The role holder will help in the creation of tools for data scientists and analysts to search metadata for information about the various business use cases. They will work with the data analysts to design predictive algorithms to project UDBLs future business projections.
• The role holder will implement, maintain and populate analytics databases including tuning of databases for efficient analysis and creating table schemas using extract, transform, load (ETL) methods.
• The role holder will write codes to get data into the analytics database and support the analytics teams. They will deliver aggregated data to UDBL business executives, analysts and other end users so they can analyze it and apply the results to improving business operations.
Staff Development
• Plan and implement appropriate training for the BT staff for all Business Applications
• Ensure appropriate system support services and training to all authorized bank staff.

LEVEL OF AUTHORITY
• Execute tasks as assigned by the Manager Digital Innovation.
• Collaborate with the Manager Digital Transformation to design and implement digital solutions.
• In consultation with the Business users, take decisions on issues
concerning Digital innovation within the Bank.

RELATIONSHIPS
Internally: Manager Digital Innovation, Head of Business Technology, BT staff, Directorate of Research & Knowledge
Externally: Key external stakeholders including vendors, auditors, consultants, etc.
Requirements
Education Requirements/ Qualifications
• University degree: Bachelor’s degree in applied mathematics, computer science, physics, or engineering.
• A Master’s degree in computer science, computer engineering, data science or in a related field shall be an added advantage.
Experience
• 3+ years proven working experience as a Data Engineer or similar role.
• 2 years of technical experience supporting various Business Intelligence systems.
• Experience with BI Dashboards.
• Working with collaboration platforms like git/GitLab or bitbuckets, Slack, Jira.
• Significant experience in working with relational database technologies (preferably Oracle, PostgreSQL, MySQL/MariaDB, Microsoft SQL).
• Knowledge of product design and product lifecycle
management.
• Experience with databases and Object-Relational Mapping (ORM) frameworks (e.g., Hibernate).
• Working knowledge of programming languages such as C#, Java, Python, R, Ruby, Scala, and SQL. Python, R, and SQL (MySQL and PostgreSQL) will be key.
• A good understanding of ETL tools and REST-oriented APIs for creating and managing data integration jobs.
• Working knowledge of data warehouses and data lakes.
• A clear understanding of NoSQL databases and Apache Spark systems, and relational database systems.
• A good understanding of different approaches to data architecture and applications to handle both structured and unstructured data types.
• A good knowledge of open-source data ingestion and processing frameworks.
• Attention to detail.
• Working knowledge of BI platforms.
• Working knowledge of configuring interactive dashboards.
• Working knowledge of machine learning.
• Working knowledge of Linux server management and security.
• Experience with software Projects delivery.

Competencies
• Self-motivated
• Strong communication skills (oral and written)
• Team player
• Analytical Thinking & Inductive Reasoning
• Good negotiation skills with the ability to interact with and influence others.
• Strong customer orientation
• Planning and Organization
• Project Management including software release management.
• Exceptional oral and written communication skills
• Able and willing to solve complex analytical challenges, independently analyze information; and make recommendations
based on analysis.

RELATIONSHIPS
Internally: Manager Digital Innovation, Head of Business Technology, BT staff and all Staff
Externally: Key external stakeholders including vendors, auditors, consultants etc.