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 Power BI Developer (Contract) - CPT
Location: Cape Town
Salary:
22 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.
42 days ago

Senior BI Analyst/Developer
Location: Cape Town
Salary:
9 days ago

Power Platform Developer
Location: Cape Town
Salary:
2 days ago

Junior Data Analyst
Location: Cape Town
Salary: 400 000 Annually
Work on data that genuinely changes lives across Africa.Get real responsibility from day one in a fastâgrowing tech scaleâup.Perfect for an analytical mind that wants impact, not busywork.
6 days ago

Junior Software & Systems Developer
Location: Cape Town
Salary: 500 000 Annually
A rare opportunity for a junior developer who wants real handsâon experience, not just maintenance work.My client is looking for someone curious, technical, and hungry to grow fast.This is a role where learning, building, and real project impact happen from day one.
8 days ago

Junior Data Analyst
Location: Cape Town
Salary:
Are you naturally curious? Do you always ask why and then prove it with data? Our clients are always on the lookout for data loving, analytical thinking Data Analysts who is ready to turn raw numbers into meaningful business impact.
15 days ago

Tableau Report & Visualisation Developer
Location: Cape Town
Salary: Market related
We are seeking a Tableau Report & Visualisation developer to support the Financial Services division
21 days ago

Junior Data Analyst
Location: Cape Town
Salary:
Our client is looking for a curious, analytical thinker ready to turn raw data into meaningful impact.
27 days ago

Data Engineer
Location: Cape Town
Salary:
Top o’ the Morning! Your lucky career break might be here. Our client is on the hunt for a Data Systems Engineer to join their team. If you are passionate about data, technology, and sustainability, and you enjoy turning complex datasets into powerful insights, then this opportunity could be your lucky charm.
43 days ago

BI Developer

Similar jobs you might be interested in:

Create a free job alert for BI Developer in Capetown