Data and Analytics Engineer

NTT Data; Cape Town; On-site; ZAR 600 000 - 800 000; Full time

Job summary

A leading data management company in Cape Town seeks a highly skilled professional with expertise in database management and analytics. The ideal candidate will have a minimum of 7 years of experience, a tertiary qualification, and skills in Qlikview, ETL development, and cloud data integration. The role includes ensuring database efficiency, managing data pipelines, and performing performance tuning. This is an on-site position.

Qualifications

• 7 years experience of data and analytics.

Responsibilities

• Ensure database remains efficient and secure.
• Monitor and troubleshoot data pipelines in Azure.
• Install and configure Qlik Sense applications.
• Develop and document data procedures.
• Ensure compliance with data governance.

Skills

Database administration

Qlikview and Qliksense

ETL development

T-SQL development

Shell scripting

Education

Matric and a tertiary qualification

Job description

Database Managed Services

• Database administration: Ensure database remains efficient and secure.
• Fine tune of configurations, optimises resource allocation, ensure and implements best practices.
• Database performance tuning and management: Performance tuning and management for optimized data operations e.g. scalability and efficiency.
• Ensures peak performance through continuous monitoring.
• Continuous Service Improvement.
• Proactive approach to database management by continually evaluating performance and security through monitoring, trending topics to
• Trouble shooting and problem diagnosis to resolve issues logged via support system.
• Backup and Recovery: Ensuring the recovery of the data during system failures. Automated backups and recovery processes.
• Database storage: Continuous monitoring of storage as well as scale storage requirements
• Database security: Ensures data remain confidential and compliant including masking techniques, encryption and access controls.
• Infrastructure support: 24hr support to resolve issues by doing proactive monitoring and problem resolution.
• Database upgrade and migration: Plan and execute upgrades and migration of data. Ensure patches and updates are applied timeously to remain relevant.
• Integration with Microsoft Azure: Monitoring and troubleshooting data pipelines.

Qlikview and Qliksense Services

• Install, configure and upgrade Qlik Sense application.
• Manage migration of QLIK objects between Development, QA and Production environments
• Analyse Windows event logs and Qlik Sense server log files to troubleshoot and solve issues.
• Provide Qlik Sense administration services via Management Console: managing licenses, setting up permission, designing folder structure and scheduling tasks for publishing purposes.
• Administer and maintain access to Qlik Sense Management Console
• Performance and scalability: Monitor proactively the environment.
• Liaise and with Qlik team to troubleshoot new features and provide operational support.
• Backup and recovery: Ensure backup and recovery of environment.
• Regular checks on compliance like user access controls or any vulnerability scans on environment
• Provide technical guidance to developers.
• Support Nprinting configuration and set-up.
• Perform upgrades to the environment for new software updates. Therefore, plan and execute software upgrades.
• Collaborate with developers to ensure optimal solution implementation.
• Collaborate with infrastructure and architecture teams to ensure optimal infrastructure environment.
• Decommissioning the environment when new environments are established. Plan and execute.

Qliksense Site Management includes:

• Manage licenses.
• Manage tokens and access types.
• Configure nodes.
• Manage data connections.
• Manage content security (can define security rules)
• Manage task and triggers.
• Synchronize users.

Development

• Pipeline/ETL development (SSIS)
• T-SQL development
• Shell scripting (dotnet/C++)
• Documentation
• Occasional workflow, bot automation work
• FTP script development
• Qlik model development

Governance

• Deployment of various audit principles
• Fix issues detected + compliance
• Creation data governance strategy

Collaboration

• Business partnering on projects
• Cross collaborative efforts
• Tight integration with BA, Architecture, Security and Solutions

Qualifications

• Matric and a tertiary qualification
• 7 years experience of data and analytics