Data Engineer

FirstRand Limited; Johannesburg; On-site; ZAR 800,000 - 1,200,000; Full time

Job summary

FirstRand Limited is seeking a Data Engineer to expand and optimize our data and data pipeline architecture. The role focuses on building and refining data delivery for cross-functional teams, supporting analysts, scientists, and engineers, and ensuring scalable, secure data systems across multiple data centres.

The ideal candidate will design and implement ETL processes, leverage SQL and big data technologies, and drive improvements to data architecture to support next-generation products and

Qualifications

• Experience building and optimizing data pipelines.
• Proficiency with SQL and big data technologies.
• Experience with ETL processes and data integration.
• Experience with Hadoop platforms and large-scale data systems.
• Experience migrating data across databases/servers.
• Knowledge of data governance and quality.

Responsibilities

• Create and maintain optimal data pipeline architecture meeting functional and non-functional requirements.
• Identify and implement internal process improvements for data delivery and scalability.
• Build infrastructure for ETL from diverse sources using SQL and big data tech.
• Implement analytics tools to provide insights on key metrics.
• Collaborate with stakeholders to support data needs and issues.
• Keep data secure across national boundaries via multiple data centres.
• Develop scripts for maintenance, monitoring, and performance tuning.
• Lead innovation by evaluating big data technologies for platforms.
• Oversee large Hadoop platforms and support growing data needs.
• Enable and run data migrations across databases and servers.

Skills

Data pipeline

SQL

Big data

ETL

Hadoop

Data migration

Data governance

Tools

Ab Initio

Job description

The Data Engineer will be responsible for expanding and optimizing the data anddata pipeline architecture, as well as optimizing data flow and collection for crossfunctional teams. The Data Engineer is an experienced data pipeline builder anddata wrangler who enjoys optimizing data systems and building them from theground up. The Data Engineer will support software developers, databasearchitects, data analysts and data scientists on data initiatives and will ensureoptimal data delivery architecture is consistent throughout ongoing projects. Theymust be self-directed and comfortable supporting the data needs of multiple teams,systems and products. The Data Engineer will be required to optimise or even re-redesign the data architecture to support the next generation of products and datainitiatives. The Data Engineer is also responsible for the maintenance,improvement, cleaning, and manipulation of data in the business's operational andanalytics databases in order to understand and aid in the implementation ofdatabase requirements, analyse performance, and troubleshoot any existentissues.

• Create and maintain optimal data pipeline architecture, assemble large, complex data sets that meet functional and non-functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and 'big data' technologies.
• Implement analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.
• Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
• Keep our data separated and secure across national boundaries through multiple data centres.
• Implement data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
• Work with data and analytics experts to strive for greater functionality in our data systems.
• Supports junior data engineering personnel by creating databases optimized for performance, implementing schema changes, and maintaining data architecture standards across all of the business's databases.
• The Data Engineer leads innovation through exploration, benchmarking, making recommendations, and implementing big data technologies for platforms.
• Develop and implement scripts for database maintenance, monitoring, performance tuning, and so forth.
• Designing and developing scalable ETL packages (Abinitio) from the business source systems and the development of ETL routines in order to populate databases from sources and also to create aggregates.
• Oversee large-scale data Hadoop platforms and support the fast-growing data within the business.
• The Data Engineer is responsible for enabling and running data migrations across different databases and different servers, for example, data migration from SQL servers to Oracle.
• Define and implement data stores based on system requirements and other requirements.
• Perform thorough testing and validation in order to support the accuracy of data transformations and data verification used in machine learning models. Ensure proper data governance and quality across the Data and Analytics department and the business as a whole.
• The Data Engineer plays an analytical role where ad-hoc analyses of data stored in the business's databases is performed and writes SQL scripts, stored procedures, functions, and views.
• Troubleshoot data issues within the business and across the business and presents solutions to these issues.
• Proactively analyse and evaluate the business's databases in order to identify and recommend improvements and optimization.
• Analyse complex data elements and systems, data flow, dependencies, and relationships in order to contribute to conceptual physical and logical data models.
• Develop and implement scripts for database maintenance, monitoring, and performance tuning to be applied across the business.

The Data Engineer also plays a supporting role to the data warehousing department in the implementation of the data warehouse for the new big data platforms. He/She works collaboratively with the entire Data and Analytics team, providing support to the entire department for its data