DATA ENGINEER ICT DATA MANAGEMENT DEPARTMENT

FSCA South Africa; Pretoria; On-site; ZAR 700,000 - 900,000; Full time

Job summary

FSCA South Africa seeks a data engineer to design, build, and optimize data pipelines supporting data initiatives. You will ingest data from source systems, transform it, and prepare datasets for analytics and predictive work.

You will Collaborate across teams to develop strategic data models and enforce data standards while enabling data-driven business outcomes. Strong SQL, ETL, and BI tool experience are required.

Qualifications

• Extensive ETL, data modeling, and segmentation experience.
• Advanced SQL knowledge and experience with relational databases.
• Experience with MS SSIS, SSAS, SSRS, Power BI and Visual Studio data tools.

Responsibilities

• Design, build, expand, and optimize data pipelines for ingesting and processing data from source systems.
• Collaborate with teams to build strategic data models enabling business outcomes.
• Create robust, automated pipelines for structured and unstructured data and analytics.
• Conduct complex data analysis and report on results.
• Develop and maintain datasets to support analytics.
• Deploy and schedule ETL jobs (Batch/Micro batch processing).
• Lead data standards and reporting requirements with stakeholders.

Skills

ETL

Data Modeling

Data Mining

Segmentation

SQL

Relational Databases

Dimensional Modeling

Root Cause Analysis

Power BI

Visual Studio Data Tools

SSIS/SSAS/SSRS

Tools

MS SSIS

MS SSAS

MS SSRS

Power BI

Visual Studio Data Tools

Job description

Purpose of the Job

To Design, build, expand, and optimize the data pipelines, as well as optimize data flow and optimize the organization’s data ingestion process to support data initiatives. The person appointed to this position will report to the Senior Specialist: ICT Data Management.

Key Performance Area

• Develop, innovate and maintain the data architecture that will drive various initiatives/projects across the organisation
• Collaborate with teams to build strategic data models that will help enable the achievement of business outcomes
• Create robust and automated pipelines to ingest and process structured and unstructured data from source systems into analytical platforms
• Conduct complex data analysis and report on results
• Build and optimise data pipelines and datasets
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• Develop and maintain datasets
• Analyse raw data and Interpret trends and patterns
• Prepare data for prescriptive and predictive modelling
• Implement existing frameworks to optimize functionality.
• Deploy and schedule ETL jobs (Batch/Micro batch processing)
• Partner with various stakeholders within the organisation to drive the improvement in the way that data is stored and consumed.
• Support application team development by writing stored procedures, functions etc.
• Develop and maintain data security and permissions, including data encryption and database user access controls and logging.
• Build algorithms and prototypes.
• Lead business stakeholder’s engagement on data standards and reporting requirements in order to derive the data driven strategy of the FSCA.

Other Key Competencies

The candidate must demonstrate the following skills and attributes: Must have extensive experience with ETL, technical expertise with data models, data mining, and segmentation techniques, experience using MS SSIS, MS SSAS, MS SSRS, Power BI and Visual Studio data tools, advanced working SQL knowledge and experience working with relational databases, dimensional modeling, query authoring (SQL) as well as working familiarity with a variety of other databases, experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement, ability to deal professionally with internal and external clients, Ability to work under pressure and meet deadlines, Innovative thinking and planning skills, Ability to function independently.

FSCA is committed to increasing the representation of marginalised groups in line with its Employment Equity Plan. People with disabilities are encouraged to apply.

Please note that correspondence and communication will only be conducted with shortlisted candidates and that the FSCA reserves the right not to appoint if a suitable candidate is not identified.