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:

Graduate BI Developer (Dashboard Dazzler) - Hybrid
Location: Cape Town
Salary:
Attention all recent graduates! We're on the hunt for a talented bi developer with a passion for SQL to join our client’s team. If you're ready to dive into the world of designing new bi solutions and reporting, this opportunity is for you!
9 days ago

Senior SQL BI Developer – Cape Town – up to R900k
Location: Capetown
Salary: 900000
Senior SQL bi developer – Cape Town – up to R900k
22 days ago

Senior Data Analyst – Cape Town – up to R850k per annum
Location: Capetown
Salary: 850 000
Senior Data Analyst – Cape Town – up to R850k per annum
7 days ago

Senior Developer - Contract
Location: Cape Town
Salary: R500 - 565 per hour
Senior developer - Contract
8 days ago

Senior SQL Developer – Cape Town (Hybrid) – up to R900k Per Annum
Location: Capetown
Salary: 900000
Senior SQL developer – Cape Town (Hybrid) – up to R900k Per Annum
18 days ago

Systems Analyst: Board Application
Location: Cape Town
Salary: Market Annually
An industry leading Bank has an exciting opportunity available for a System Analyst to join their team.
3 days ago

Senior Data Analyst – Cape Town – up to R850k per annum
Location: Capetown
Salary: 850000
Senior Data Analyst – Cape Town – up to R850k per annum
22 days ago

Senior BI Analyst
Location: Cape Town
Salary:
Are you a seasoned Business Intelligence Analyst with a passion for steering data-driven decisions? Join a leading insurance provider as a Senior bi Analyst and play a pivotal role in shaping our data strategy and insights framework.
25 days ago

BI Engineer
Location: Cape Town
Salary:
Are you passionate about transforming data into actionable insights? Do you have a knack for designing and implementing robust business intelligence solutions?
25 days ago

BI Engineer
Location: Cape Town
Salary:
Are you passionate about transforming data into actionable insights? Do you have a knack for designing and implementing robust business intelligence solutions?
28 days ago

BI Developer

Similar jobs you might be interested in:

Create a free job alert for BI Developer in Capetown