Data Engineer

To ensure effective movement, collection, integration, storage and provisioning of data to meet business objectives through sound understanding of business unit requirements and frequent collaboration with relevant stakeholders (Enterprise Architecture, Database and Solutions Architects, Business Intelligence Developers, Data Scientists, Product Owners, etc.)

Design, build, and maintain scalable ETL/ELT pipelines to collect, process, and integrate structured and unstructured data from multiple banking systems.

Develop and optimize data warehouses, data lakes and streaming platform to support analytics and machine learning workloads.

Collaborate with Data Scientists to provision feature stores and model ready datasets.

Collaborate with BI teams to ensure high-quality, consistent, and governed data is available for reporting and dashboards.

Implement data quality checks, validation frameworks, and reconciliation processes to ensure accuracy and trustworthiness.

Apply data governance, security, and privacy standards (including compliance with the Botswana Data Protection Act and Group policies.)

Work with cloud platforms (AWS, Azure, GCP etc) and on-premises systems to design hybrid or localized data solutions.

Monitor and optimize data workflows for performance, cost efficiency and scalability.

Control expenditure and identify process improvements to contain and reduce costs.

Build working relationships across teams and functional lines to enhance work delivery, collaboration and innovation.

Conduct research on emerging technologies, recommend and implement technologies that improve cost effectiveness and system flexibility.

Confer with end users, clients, or senior management to understand business requirements for complex developments or enhancements.

Assist with gap analysis and business cases including cost effort analysis.

Conduct hands-on work related to profiling, documentation and validating the clients.

Execute remediation actions as agreed with clients.

Implement the necessary components and frameworks required for automated deployments and task scheduling.

Build unit and systems tests to ensure successful delivery of components in production.

Manage user acceptance testing and associated signoffs through change control.

Acquire and collect data via ETL and ELT processes from source systems into the Reservoir and Enterprise Data warehouse, adhering to the appropriate data platform standards.

Integrate data from multiple sources through the enterprise data platform architecture to meet business objectives.

Develop and maintain physical data marts and databases.

Automate tasks related to data pipelines for the deployment of operational analytics.

Prepare and provision data for advanced analytical modelling by Data Scientists.

Perform data quality assessments and introduce monitors and alerts to ensure data quality is maintained throughout all managed systems.

Create change scripts and set-up scripts ready to be implemented in production.

Participate in architecture forums (as an when required.)

Utilise various tools and components which make up the data platform for enhanced service delivery.

Create requirements and design of the technical architecture, design and development, testing and deployment of proposed solutions.

Provide analytical infrastructure or big data technologies related to support Data operations and Analytic teams.

Grow technical knowledge platform, identify best practices and develop guidelines for optimum usage of tools.

Assist and work on projects to roll out and support team members.

Participate in planned activities that are appropriate for own development.

Develop, encourage and nurture collaborative relationships across areas of specialisation.

Technical skills

Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

Experience building and optimizing ‘big data’ data pipelines, architectures and data sets.

Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

Strong analytic skills related to working with unstructured datasets.

Build processes supporting data transformation, data structures, metadata, dependency and workload management.

Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores.

Experience supporting and working with cross-functional teams in a dynamic environment.

Experience and Related Skills

3+ years of experience in a Data Engineering role

Experience with data pipeline and workflow management tools

Experience with cloud services

Experience with object-oriented/object function scripting languages:

Python, Java, C++, Scala, etc.

Demonstrate experience working with large and complex data sets as well as experience analysing volumes of data.

Experience in creation and debugging of databases critical to the business’s mission.

Have a strong working and conceptual knowledge of building and maintaining physical and logical data models.

Knowledge in developing databases using SSIS packages, T-SQL, MSSQL, and MySQL scripts.

Ability to design, build, and maintain business’s ETL pipeline and data warehouse.

Demonstrate expertise in data modelling and query performance tuning on SQL Server, MySQL, Postgres or similar platforms.

Experience in managing financial services data will be an added advantage.

Advanced data analysis skills using Excel, SQL and reporting tools to import, analyse and report on data

Qualifications

Bachelor’s degree in Computer Science, Applied Mathematics, Engineering, or any other related field.

Relative certifications in cloud technologies will be an added advantage.

Important Closing Date Note

Take note that applications will not be accepted on the below date and onwards, kindly submit applications ahead of the closing date indicated below.24/04/26

All appointments will be made in line with FirstRand Group’s Employment Equity plan. The Bank supports the recruitment and advancement of individuals with disabilities. In order for us to fulfill this purpose, candidates can disclose their disability information on a voluntary basis. The Bank will keep this information confidential unless we are required by law to disclose this information to other parties.

R48631