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:

Intermediate BI Developer
Location: Cape Town
Salary: Hourly
Our client is seeking an Intermediate bi developer (Data Scientist) to support the design, development, and delivery of business intelligence solutions. The successful candidate will leverage tools such as AWS QuickSight and Power bi to transform raw data into actionable insights, enabling smarter decision-making across the business.
12 days ago

BI Developer
Location: Cape Town
Salary:
24 days ago

Power BI Developer
Location: Capetown
Salary: Market-Related
This junior to mid-level role is focused on developing, maintaining, and optimising Power bi dashboards, reports, and paginated reports.
25 days ago

Senior BI Developer
Location: Cape Town
Salary:
49 days ago

BI (Business Intelligence) Developer
Location: Somerset West
Salary:
bi developer needed in Bellville, Cape Town.Bachelorâs degree in Data Science, Engineering, Programming or similar discipline. At least 1 year of relevant work experience in bi Development. Experience with the development of bi tools (primarily Power bi).
1 day ago

Business Reporting Analyst
Location: Cape Town
Salary: Annually
Are you a data-driven professional with a passion for transforming numbers into actionable business insights? We’re seeking a Business Reporting Analyst to join a dynamic finance team in Cape Town, helping guide strategic decision-making through meaningful analysis of operational and customer data.
4 days ago

Technical Business Analyst
Location: Cape Town
Salary: Monthly
Join a Growing FinTech Leader as a Business Analyst / Project Manager and Accelerate Your CareerThe ideal candidate brings proven technical experience in software development projects, either as a technical lead or technical analyst, and is eager to advance their career within the FinTech sector. Whether transitioning from a software developer or engineer role into technical analysis and requireme...
5 days ago

Finance Systems Lead â The Architect of Automation
Location: Cape Town
Salary: 690 000 Annually
Calling all .NET necromancers and Power Platform conjurers! A global tech-driven organisation is seeking a Finance Systems Lead to tame the chaos of legacy systems and summon a new era of automation. If you thrive in the shadows of complexity and lead with precision-this is your moment.
7 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.
8 days ago

Junior Systems Analyst
Location: Cape Town
Salary: 200 000 Annually
Gather ‘round, brave tech adventurers...For I’ve got a tale to tell. A tale of systems unseen… diagrams so complex they twist and turn like a trail through the haunted woods… and a team in search of one bold analyst to help uncover the mysteries within the machine.Are you the one?
25 days ago

BI Developer

Similar jobs you might be interested in:

Create a free job alert for BI Developer in Capetown