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:

Power BI / Azure Fabric Developer
Location: Cape Town
Salary:
11 days ago

Business Intelligence (BI) Analyst Developer – Cape Town – up to R800k per annum
Location: Capetown
Salary: 800000
Business Intelligence (bi) Analyst developer – Cape Town – up to R800k per annum
15 days ago

Business Intelligence Developer
Location: Cape Town
Salary:
Business Intelligence developerThe Business Intelligence developer is responsible for designing, developing, and maintaining bi solutions that empower data-driven decision-making across the organization. This includes building dashboards, data visualizations, and reporting systems using tools like Power bi, or SQL-based platforms.The ideal candidate is both technically strong and business-aware, c...
15 days ago

BI Data Engineer (Remote)
Location: Capetown
Salary: Datafin1
bi Data Engineer (Remote)
56 days ago

AI Engineer - Cape town of Anywhere in SA - Contract
Location: Cape Town
Salary: R550 - 617 per hour
AI Engineer
23 days ago

Business Intelligence Developer
Location: Capetown
Salary: R360 000.00 plus benefits - highly negotiable
Opportunity if you are experienced in Microsoft Powerbi, SSIS, SQL. Join dynamic team where your skillset and input valued.
32 days ago

Senior Qlik Sense Cloud Developer (Remote)
Location: Capetown
Salary: Datafin1
Senior Qlik Sense Cloud developer (Remote)
57 days ago

SQL Data Engineer – Cape Town – R650k to R850k per annum
Location: Capetown
Salary: 850000
SQL Data Engineer – Cape Town – R650k to R850k per annum
63 days ago

Senior Backend Developer (Python, SQL, NoSQL)
Location: Capetown
Salary: Monthly salary
LEAD the development of scalable, high-performance analytics services tailored for a Procurement Marketplace as the next Senior Backend developer sought by a cutting-edge Finance Platform.
71 days ago

SQL Data Engineer – Cape Town – R650k to R850k per annum
Location: Capetown
Salary: 850000
SQL Data Engineer – Cape Town – R650k to R850k per annum
79 days ago

BI Developer

Similar jobs you might be interested in:

Create a free job alert for BI Developer in Capetown