Never pay for any CBT, test or assessment as part of any recruitment process. When in doubt, contact us
Since our establishment in 1918, Sanlam has been a prominent part of the South African business landscape. We have always held a long-term view of how business adapts to the demands of the environment in which it operates. Today, in a dynamic world, we see an evolving set of social, economic, political and environmental imperatives that require our skilfu...
Read more about this company
Role Description
Guided by senior developers you will be responsible for establishing new technology components and reusable data pipeline solutions that can be leveraged by business facing development teams in their day-to-day solutions.
Development to be done by following set principles, standards, processes, procedures, and guidelines from the wider BI community.
You should be competent in communicating challenges and solutions to your leadership team.
What will you do?
Main Responsibilities
The performance of the Junior BI Data Engineer can be described and measured by:
- Define a structured approach to problem solving and delivery against it.
- Load large, complex data sets to and make data available for other data engineers
- Working with other data engineers and data modelers, you will design, implement, and manage data vaults and data transformations and the data pipeline
- Monitor and fine-tune data vaults and data transformations on the Cloudera Hadoop stack
- Use modern development and modelling techniques and tools to implement BI and data management solutions, including data quality, meta data, and reference data
- Engage with a wide range of technical stakeholders including data scientists, data analysts, business analysts, other data engineers and solutions architects
What will make you successful in this role?
Qualifications
Role Requirements:
- Bachelor’s degree in Computer Science, Statistics, Informatics, Information Systems, Engineering or another quantitative field / National Diploma in an Information Technology related discipline preferred
Work Experience
- The Junior BI Data Engineer must have <= 2 years relevant experience in a similar environment
Technical Knowledge And Experience
The Data Engineer is someone with a strong understanding of data, data structures and data sources. Required skills include:
- Application and data engineering background with a solid background in SQL is required
- Knowledge of database management system (DBMS) physical implementation, including tables, joins and SQL querying..
- Knowledge and experience of structured data, such as entities, classes, hierarchies, relationships, and metadata.
- Data Engineering background with a specific focus on staging high quality data
- Understanding of data warehousing principles (e.g. Kimball or Data Vault).
- Experience in agile development
Desirable/ Preferred Skills Include
- A solid background in SQL and ETL procedures
- Experience in developing data pipelines using ETL tools (e.g. SAP Data Services)
- Data warehousing (Kimball or Data Vault patterns) and dimensional data modelling (e.g. OLAP and MDX experience)
- Automation (e.g. Wherescape), scheduling and test automation (e.g. Robot) will be advantageous
- Data Management technologies (e.g. Informatica Data Quality (IDQ), Informatica Enterprise Data Catalog (EDC), Axon, EBX) will be advantageous
Competencies
- Strong analytical & numerical ability
- Problem solving skills
- Conceptual thinker
- Good communication / interpersonal skills
- Action / results orientation
- Quality orientation
- Knowledge seeking / learning orientation
- IT Data Analysis
- Database Knowledge and Monitoring
- Data Security
- Risk Management
- Strong analytical-thinking and problem-solving abilities
- Ability to collect, organize, analyze, and disseminate significant amounts of information
- Strong technical and operational ability
- Deadline-driven, even in pressurised and fast-paced environments