Praesignis
1 month ago
Data Engineer
Sign up to save this job, get alerts, and apply with an optimized CV.
Company information
- Company
- Praesignis
- Location
- South Africa, Gauteng, Johannesburg, North Johannesburg, Sandton South Africa
- Posted
- 1 month ago
Job description
We are looking for an experienced Data Engineer with strong SQL, SSIS and ETL expertise to join a Compliance Technology environment within a leading financial services organisation.
Key Responsible:
Key Requirements:
Advantageous:
Key Responsible:
- Develop and enhance SQL scripts, queries and database logic to support business requirements.
- Develop, modify and maintain SSIS packages and ETL workflows.
- Perform data integration across multiple source systems.
- Optimise SQL queries, ETL processes and database performance.
- Support data modelling, schema enhancements and data transformation.
- Develop and enhance operational reports and dashboards.
- Perform data validation, reconciliation and data quality checks.
- Investigate and resolve data, ETL and production issues.
- Perform root-cause analysis and implement corrective actions.
- Monitor and support batch processes and scheduled jobs.
- Support SIT/UAT, deployments and production releases.
- Assist with data remediation, governance and compliance-related initiatives.
- Contribute to continuous improvement, process automation and optimisation.
Key Requirements:
- 5+ years' experience in Data Engineering / ETL / SQL development.
- Strong hands-on experience with SQL and Microsoft SQL Server.
- Strong SSIS development experience.
- Solid understanding of ETL/ELT processes and data integration.
- Experience with database performance tuning and query optimisation.
- Experience with data warehousing and data modelling.
- Experience troubleshooting production data and ETL issues.
- Experience working with SIT/UAT and production deployments.
- Strong understanding of data quality, validation and reconciliation.
- Excellent analytical and problem-solving skills.
Advantageous:
- Experience within banking or financial services.
- Experience with AML / Compliance data platforms.
- Exposure to NICE Actimize.
- Experience with Azure Data Factory (ADF).
- Experience with Microsoft Purview and data governance.
- Exposure to regulatory reporting and data remediation.
- Experience with DevOps and CI/CD processes.
Required skills
- compliance
- financial services
- sql
- etl
- continuous improvement
- data engineer
- devops
- data governance
- data integration
- banking
- aml
- nice actimize
- data modelling
- data warehousing
- reconciliation
- azure data factory
- dashboards
- sql queries
- data validation
- ssis
- microsoft sql server
- regulatory reporting
- ci/cd processes
- data transformation
- process automation
- adf
- etl development
- batch processes
- etl/elt processes
- data quality checks
- database performance tuning
- root-cause analysis
- query optimisation
- sql scripts
- scheduled jobs
- deployments
- microsoft purview
- database performance
- etl workflows
- sit/uat
- operational reports
- production releases
- data remediation
- database logic
- ssis packages
- schema enhancements
- compliance data platforms
Interested in this position?
Create your free account and tailor your CV to match this job.