- Joined
- Jun 28, 2017
- Messages
- 6,805
- Reaction score
- 648
Business Inteligence Data Engineer | Ref: #1197 Job Details - Click Here
Kenilworth, Cape Town, South Africa Third Quarter Business Resources
Job Title: BI Data Engineer (x3)
Reference: 1197
Duration: 6 – 12 Months Contract
Location: Kenilworth, Southern Subs
Industry: Retail
*
Brief Description:
Responsible for maintenance and monitoring of existing BI reports, applications and infrastructure, as well as creation, maintenance and implementation of new applications, databases, reports, and dashboards. The candidate must be self-motivated with a strong attention to detail and the ability to fill multiple roles within the BI environment. Data engineers may work closely with data architects (to determine what data management systems are appropriate) and data scientists (to determine which data are needed for analysis). They often wrestle with problems associated with database integration and messy, unstructured data sets.
*
Responsibilities and Duties
Key Competencies
Requirements
Kenilworth, Cape Town, South Africa Third Quarter Business Resources
Job Title: BI Data Engineer (x3)
Reference: 1197
Duration: 6 – 12 Months Contract
Location: Kenilworth, Southern Subs
Industry: Retail
*
Brief Description:
Responsible for maintenance and monitoring of existing BI reports, applications and infrastructure, as well as creation, maintenance and implementation of new applications, databases, reports, and dashboards. The candidate must be self-motivated with a strong attention to detail and the ability to fill multiple roles within the BI environment. Data engineers may work closely with data architects (to determine what data management systems are appropriate) and data scientists (to determine which data are needed for analysis). They often wrestle with problems associated with database integration and messy, unstructured data sets.
*
Responsibilities and Duties
- Developing applications and coding within MS SQL Server 2012/2014
- Creating report scripts and troubleshooting existing coding
- Be involved in design of data warehouse
- Using SSRS to automate outputs for Tableau applications
- Design and create SSRS report definitions to present the data
- Data integration using SSIS and SSRS for analysis
- Availability and performance monitoring of data pipelines and models
- Architecting continuous integration/deployment platforms
- Combining data from multiple sources programmatically
- Architecting scalable data pipelines using cloud technologies
- Preparing data for analysis
Key Competencies
- Team spirit!
- Solid communication and data presentation skills.
- Discipline, diligence & accountability.
- Problem solving ability.
- Ability to efficiently plan, prioritize and manage numerous projects and tasks simultaneously.
- Highly quantitative thinking, strong analytical skills.
- Detail orientation.
- “Out of the box” thinking.
- Desire for continuous learning and skills improvement.
Requirements
- Strong data integration skills using SSIS and SSRS
- 1-3 years’ experience in relevant position (using a BI platform)
- 5 years retail industry experience
- Exceptional skills in writing SQL for Microsoft SQL server,
- Dashboarding experience using SSRS
- Professional experience developing within MS SQL Server
- Experience with datawarehousing technology and methodology
- Excellent use of MS Excel. Knowledge of advanced formulas is a must.
- Excellent command of English, both written and oral.
- Knowledge of Python, R will be considered a plus.