Job Description

EMPLOYMENT TYPE:Contract (12 months)COMPANY:A large financial services company.LOCATION:Cape Town (hybrid working model)JOB OVERVIEW:You will be responsible for establishing new technology components and reusable solution patterns that can be leveraged by business-facing teams in their day-to-day solutions. You are regarded as a data engineering specialist with advanced analytical and technical skills who understands data modelling, data engineering, data visualisations, and analytical models.You should be competent in communicating challenges and solutions to project and operational leadership. An understanding of data management solutions and a keen sense of the strategic value of information to an organization will be of importance. You will also be responsible for developing data pipelines, and data models, monitoring programme/ job performance, designing data warehousing blueprints, evaluating hardware and software platforms, and integrating systems; translating business needs into long-term solutions.You possess the ability to orchestrate delivery with a complex series of stakeholders and able to conceptualise solutions built on a hybrid of technologies with no real scope at the get-go, i.e. create, navigate, and negotiate the scope on the fly.DESCRIPTION OF POSITION:

• Define a structured approach to problem-solving and delivery against it.
• Assist and advise the planning and management of the workload of the team.
• Collaborating with other data engineers and data modellers, you will design, implement, and manage the data pipeline to avail data in the information layer.
• Create and automate reports for use by a large user base across our branch network.
• Identify, design, and implement internal process improvements: automating manual processes, optimising data delivery, and re-designing models for greater scalability.
• Monitor and fine-tune the data pipeline, reports, and information layer for optimal performance.
• Use modern development and modelling techniques and tools to implement BI and data management solutions, including data quality, metadata, and reference data.
• Engage with a wide range of technical stakeholders including data scientists, data analysts, business analysts, other data engineers, and solutions architects.

Competencies:

• Strong analytical and numerical ability
• Problem-solving skills
• Conceptual thinker
• Good communication/interpersonal skills
• Action/results orientation
• Quality Orientation
• Knowledge-seeking/learning orientation
• Strong analytical thinking and problem-solving abilities

• Ability to collect, organise, analyse, and disseminate significant amounts of information
• Strong technical and operational ability
• Deadline-driven, even in pressurised and fast-paced environments

KNOWLEDGE AND SKILLS

• IT Data Analysis
• Database Knowledge and Monitoring
• Data Security
• Risk Management
• Project Oversight
• Strong understanding of data, data structures, and data sources

• Application and data engineering background with a specific focus on staging high-quality data

• Knowledge of database management system (DBMS) physical implementation, including tables, joins, and SQL querying
• Knowledge of structured data, such as entities, classes, hierarchies, relationships, and metadata

• Ability to comply with and manage data assets under a strict governance framework

• Data warehousing (Kimball and/or Data Vault patterns) and dimensional data modelling
• A solid background in SQL, Information Architecture, and ETL procedures
• Data Management technologies (e.g. Data cataloguing, reference data management tools)
• Data warehouse automation tools

QUALIFICATIONS REQUIRED:

• Bachelor's Degree in Computer Science, Statistics, Informatics, Information Systems, Engineering, or another quantitative field
• National Diploma in an Information Technology related discipline preferred

EXPERIENCE REQUIRED:

• 6+ years of relevant experience in a similar environment working with the relevant tools and techniques
• Experience in Database technologies
• Experience in data warehousing principles (e.g. Kimball and/or Data Vault)
• Experience in Agile Development
• Experience in structured data, such as entities, classes, hierarchies, relationships, and metadata
• OLAP and MDX experience

ADVANTAGEOUS SKILLS

• Experience with object-oriented/functional/scripting languages (e.g. Python, Unix Shell Scripting, Java, Scala, etc.)

**Please note: If you have not heard from us within 2 weeks, please consider your application unsuccessful.

Vito Solutions