Business Intelligence Developer

 

Recruiter:

AGA Recruitment Specialists

Job Ref:

CPT000012/AJ

Date posted:

Friday, February 19, 2021

Location:

Capetown, South Africa

Salary:

Market Related


SUMMARY:
Our client is looking for a Business Intelligence Developer. They are 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.

POSITION INFO:

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 Business Intelligence Developer
Location: Cape Town
Salary:
Are you driven by data and passionate about turning complex information into meaningful insights that influence real business decisions? This opportunity offers a chance to work in a structured, data focused environment where your expertise will directly support strategic and operational outcomes within a well established financial setting.
25 days ago


Senior Business Intelligence Developer
Location: Cape Town
Salary:
Our client, a leading financial services organisation, is looking for a Senior business intelligence developer to join their team. 
26 days ago


Business Intelligence Business Analyst (BIBA)
Location: Cape Town
Salary:
36 days ago


Business Intelligence Engineer
Location: Cape Town
Salary:
61 days ago


Senior Business Intelligence Analyst
Location: Cape Town
Salary:
One of South Africa's Banking Giants is looking for a Senior business intelligence Analyst to join their team. 
26 days ago


Senior BI Developer
Location: Cape Town
Salary:
Our client is searching for a business intelligence developer ready to step into the spotlight and perform feats of analytical brilliance that amaze and delight across the business arena.
26 days ago


Junior Front-End Developer
Location: Cape Town
Salary:
Craft Experiences. Define the Interface. If you’re energised by transforming design into intuitive, pixel‑perfect digital interfaces, this is where your craft becomes impact. Join a collaborative engineering team where your work shapes the user experience across every product touchpoint.
18 days ago


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.
75 days ago


BI Developer - Cape Town (Remote/ Hybrid options available)
Location: Cape Town
Salary:
78 days ago


Intermediate Data Engineer (with GCP)
Location: Cape Town
Salary:
78 days ago


Create a free job alert for Business Intelligence Developer in Capetown

Enter your email address below and we will email you similar jobs when they become available:

You can cancel at any time. We will not spam you.
By giving us your email address your agree to our Terms and Conditions