Data Engineer
Data Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Contract position
Minimum requirements:
- Matric / Grade 12 / National Senior Certificate
- Advanced Diplomas/National 1st Degrees
- Role related diploma/degree or equivalent certification and experience
- Minimum 7 years experience designing and developing interconnected data solutions using Microsoft platform
- Must have experience with financial and/or project data
- Highly advantageous to have experience with JIRA JQL consuming REST API
- Extract transform and Load Data
- Databases
- SQL
Skills:
- Broad knowledge of database structures and designs
- Technical understanding of data models and BI principles
- Advanced SQL skills with the MS BI stack (TSQL SSIS SSAS)
- Strong TSQL 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
Ideal:
- Previous experience with project metrics and project financials will be advantageous
- Experience building PowerBI dashboards
- Azure experience and knowledge
- Python language experience and knowledge
Responsibilities:
- 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 endtoend solutions as well as work with users to identify reconcile and correct errors.
- 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 management processes using SSIS and TSQL
- 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 technical requirements
- Technical and support documentation (including technical specification support manual and change management)
- Full lifecycle solution delivery mostly in agile methods
Employment Type
Full Time
