BI Developer

Recruiter:

AGA Recruitment Specialists

Job Ref:

CPT000096/AG

Date posted:

Friday, February 18, 2022

Location:

Capetown, South Africa

JOB SUMMARY:
Our Client an International Company is looking for a motivated, energetic, inquisitive and highly numerate person who has a solid technical base but also possesses an appreciation for numbers and understands the value that can be derived from interrogating them.
Our dynamic environment is fast paced, using Agile and self-organizing principles in order for our teams to deliver the highest quality products.

JOB DESCRIPTION:

Duties include, but not limited to:

Integration of new sources of data into company databases so that it can also be analyzed and included in relevant reports.
Designing new database structures or enhancing existing ones to cater for optimal process flow and optimal user querying.
Integration of data into relevant workflow processes, with the specific aim of continuously improvement and data optimization
Conceptualizing, defining and delivering new reports as well as improving existing ones
Analysis of data from various sources in order to ensure that the business acts proactively on the information at its disposal
Continually searching for new and useful ways to obtain, integrate and analyze data that is relevant to the company’s business model
Debugging, monitoring and troubleshooting current solutions
Work with Project Managers and Product Owners in developing and executing project plans or development tasks within assigned schedule and timeline.
Guide and mentor junior resources when needed
Education of report end-users so as to ensure a maximum spread of expertise around the company

Essential Criteria:

3 years relevant work experience or Undergraduate degree with majors in Information Systems, Mathematics, Statistics, Engineering or similar. Alternatively, at least 3 years’ work experience in a business intelligence role will be considered.
3-5 years MSSQL experience with specific reference to creation of stored procedures, functions, automation of jobs, performance tuning and optimization, RDBMS, error handling and logging, etc.
Working knowledge of SSIS is essential, with specific reference to ETL processes, error handling, data loading
Working knowledge of SSRS is essential, with specific reference to building parameterized reports, create subscriptions and schedules, expressions and sub reports
SSIS (creation of complex ETL (Extract, Transform, Load) processes, error handling, loading data from various data sources (flat files, xml), integration of new data into data warehouse, precedence constraints, parameterized connections, etc.)
SSRS (ability to build parameterized reports, create subscriptions and schedules, expressions, sub reports, etc.)
1+ years hands-on experience in developing applications using Kafka (Architecture) and other messaging systems.
1+ Working experience with Kafka Client APIs (Producer, Consumer, Streams).
1+ years of Real-time Data pipelines/Streaming in distributed env.

Desirable Criteria:

Relevant Post Graduate degree
SSAS (basic knowledge of multi-dimensional cubes)
Knowledge of Kimball methodology (star schema)
Knowledge of Agile Scrum methodology
Knowledge of MySQL
Change Tracking/CDC
XML
MDX
Software Development background

Person Specifications:

Accountability and Execution
Resilient
Self-Starter
Problem Solving
Collaborative Relationships
Influences effectively
Time management
Adaptability / Flexibility
Attention to detail

NB! This job is now closed. You can apply for other jobs by uploading your CV.

Similar jobs you might be interested in:

Senior Microsoft BI Developer (Power BI & Fabric)
Location: Capetown
Salary: Market-Related
This role is focused on designing and delivering complex bi solutions using the Microsoft Fabric platform.
1 day ago

BI Developer
Location: Cape Town
Salary:
3 days ago

Data Engineer
Location: Cape Town
Salary:
3 days ago

Business Analyst / BI Manager
Location: Somerset West
Salary:
An established fruit marketing concern based in Somerset West is seeking to employ a Business Analyst / bi Manager to join their team. The main purpose of the position is to gather and channel information from their various systems throughout primary agriculture, production, cooling and marketing divisions into a centralised information system with reports that allow management to effectively...
9 days ago

Data Analyst
Location: Stellenbosch
Salary:
In a universe of raw data, absolute truth is often hidden. A pioneering collective seeks a Relativistic Observer—a thinker who understands that insight depends entirely on one’s frame of reference. Your role is not to simply report numbers, but to bend the fabric of data, to observe it from new dimensions, and to reveal the elegant, hidden equations that define reality.
11 days ago

Microsoft Power Platform & SharePoint Developer
Location: Cape Town
Salary:
Join the team at Barefoot Cyber!Barefoot Cyber is a partner at IT Naledi Solutions. If you're ready to take the next step in your career, we'd love to hear from you: employment@itnaledi.co.za See below for details on this exciting opportunity: We are seeking a highly skilled Microsoft Power Platform & SharePoint developer to design, build, and maintain modern digital solutions ...
17 days ago

AI Operations & Strategy Engineer
Location: Cape Town
Salary:
63 days ago

SAP BI/BW Consultant
Location: Cape Town
Salary:
SAP bi/BW Consultant (Contract)ð Onsite | Cape Townð Experience: 5-7 YearsWe are looking for an experienced SAP bi/BW Consultant for a contract role in a large enterprise SAP environment. The role is fully onsite in Cape Town.
23 days ago

BI Developer

Similar jobs you might be interested in:

Create a free job alert for BI Developer in Capetown