Data Engineer at Uganda Development Bank Limited

Job Description JOB TITLE: Data EngineerREPORTS TO : Manager Digital InnovationsDEPARTMENT: Finance & Business OperationsSUPERVISES : NilSCALE: UDBL 05LOCATION: Head OfficeJOB SUMMARY/PURPOSEResponsible 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’sbig data ecosystem.ACCOUNTABILITY STATEMENTThe 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 andunstructured 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 issuesconcerning Digital innovation within the Bank.RELATIONSHIPSInternally: Manager Digital Innovation, Head of Business Technology, BT staff, Directorate of Research & KnowledgeExternally: Key external stakeholders including vendors, auditors, consultants, etc.RequirementsEducation 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 lifecyclemanagement.• 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 recommendationsbased on analysis.RELATIONSHIPSInternally: Manager Digital Innovation, Head of Business Technology, BT staff and all StaffExternally: Key external stakeholders including vendors, auditors, consultants etc.