Data Engineer
Johannesburg, ZA
Nedbank
Get a financial partner who will help, guide and support you on your personal journey.Requisition Details & Talent Acquisition Consultant
REQ 133003 - Keabetswe Modise
Job Family
Information Technology
Career Stream
Data
Leadership Pipeline
Manager of Self Professional
Job Purpose
As a BI/DW specialist you will be responsible for the analysis, design, development, enhancement, support and maintenance of the BI/DW environment using Microsoft SQL Server (database, SSIS, SSAS) and PowerBI tools. You will be required to understand and translate high-level requirements into working end-to-end solutions, as well as work with users to identify, reconcile and correct errors.
Job Responsibilities
- Data analysis, data modelling, data integration, data warehousing and database design
- Support and maintenance of the BI/DW environment
- Design and develop/enhance ETL data transformation and data managementprocesses using SSIS and T-SQL
- Design and develop/enhance SSAS tabular models including DAX calculations
- Design and develop/enhance BI dashboards
- Data Modelling using Kimball data modelling principles (snowflake and star schemas)
- Work with the broader team to gather and analyse business and technicalrequirements
- Technical and support documentation (including technical specification, supportmanual and change management)
- Full lifecycle solution delivery, mostly in agile methods
How you work
- You are proactive and interested in learning about new things
- You’re self-motivated to deliver your best work in a timely and effective way with minimal supervision.
Skills
- Broad knowledge of database structures and designs
- Technical understanding of data models and BI principles
- Advanced SQL skills with the MS BI stack (T-SQL, SSIS, SSAS)
- Strong T-SQL and DAX experience
- Strong problem solving, analytical skills and attention to detail
- Ability to identify and correct/reconcile errors
- Ability to deliver solutions from high level requirements
- Solid experience designing and developing star schemas using Kimball methodologies
- Data related studies/certifications
Desirable
- Previous experience with project metrics and project financials will be advantageous
- Experience building PowerBI dashboards
- Azure experience and knowledge
- Python language experience and knowledge
Essential Qualifications - NQF Level
- Matric / Grade 12 / National Senior Certificate
- Advanced Diplomas/National 1st Degrees
Essential Certifications
- Role related diploma/degree or equivalent certification and experience
Minimum Experience Level
- Minimum 7 years’ experience designing and developing interconnected data solutionsusing Microsoft platform
- Must have experience with financial and/or project data
- Highly advantageous to have experience with JIRA, JQL, consuming REST API’
Technical / Professional Knowledge
- Cloud Data Engineering (Azure , AWS, Google)
- Data Warehousing
- Databases (PostgreSQL, MS SQL, IBM DB2, HBase, MongoDB)
- Programming (Python, Java, SQL)
- Data Analysis and Data Modelling
- Data Pipelines and ETL tools (Ab Initio, ADB, ADF, SAS ETL)
- Agile Delivery
- Problem solving skills
Behavioural Competencies
- Decision Making
- Influencing
- Communication
- Innovation
- Technical/Professional Knowledge and Skills
- Building Partnerships
- Continuous Learning
---------------------------------------------------------------------------------------
Please contact the Nedbank Recruiting Team at +27 860 555 566
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile APIs AWS Azure Data analysis Data pipelines Data Warehousing DB2 Engineering ETL HBase Java Jira MongoDB MS SQL Pipelines PostgreSQL Power BI Python REST API SAS Snowflake SQL SSIS T-SQL
Perks/benefits: Career development
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Manager jobs
- Open Marketing Data Analyst jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Business Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Product Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Analyst Intern jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Big Data Engineer jobs
- Open Research Scientist jobs
- Open Principal Data Scientist jobs
- Open Data Quality Analyst jobs
- Open Azure Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Product Manager jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open NLP-related jobs
- Open PyTorch-related jobs
- Open Finance-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open LLMs-related jobs
- Open Consulting-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Hadoop-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Data warehouse-related jobs