Senior BI and DATA WAREHOUSE DEVELOPER

Recruiter:

HR Genie

Job Ref:

BI Developer

Date posted:

Friday, April 8, 2022

Location:

South Africa, South Africa

Salary:

Market related

SUMMARY:
- Exposure to big data - Experience in report writing and user interaction - Experience in managin

JOB DESCRIPTION:

Duties & Responsibilities

Ensure that the data being brought into the data warehouse is managed, secure, accurate, clean, easily available, and complete. Assist the business in ensuring that data warehouse processes are running at an optimum capacity at all times.
Maintain the business’s physical and logical data models, reflective of the current business environment. Provide technical assistance in the identification, evaluation and development of data warehousing systems and procedures. Define and promote the data warehouse design principles and best practice about architecture and techniques.
Design and support the table schemas and database for new and existing data sources for the business’s data warehouse. Create and support the ETL processes to facilitate the integration of data into the data warehouse using SSIS and other technologies. Lead data-related technical projects for the business across platforms; participate in project planning and the analysis of the business’s data requirements and solutions.

Desired Experience & Qualification

Bachelor’s Degree (Master’s preferred) in Computer Science, Data Science, Information Technology, Statistics, Information Systems, or any other related field
3 – 4 years solid experience in a data warehousing environment and ETL development framework
Exposure to big data
Experience in report writing and user interaction
Experience in managing/creating DataMart’s, dimension modelling and facts
Expertise in the Microsoft BI solution offerings including SQL Server 2017 Stack (SSRS, SSAS, SSIS). Knowledge of Power View, PowerPivot, SharePoint and Excel are an advantage
Understanding of BI solutions: operational and analytical, strong knowledge of relational and multi-dimensional database architectures
In-depth understanding of the Ralph Kimball data warehouse methodology
Experience in report writing
Knowledge in the technical aspects of BI, including data modelling, ETL, metadata/data management and OLAP tools
5+ years working experience in the field of data warehousing and BI
A good feel and understanding of business in general
Advanced Excel, OLAP and presentation skills
Familiar with a semantic layer and designing frameworks for reporting and analysis
Cube development using SSAS
ETL knowledge (SSIS)
Data warehousing conceptual and practical knowledge
Exposure to MS PowerQuery and PowerBI is an advantage
Knowledge of MDX query
Agile Development principals.

Other BI tools (Cognos Analytics) Advantages.

NB! This job is now closed. You can apply for other jobs by uploading your CV.

Similar jobs you might be interested in:

Lead Developer
Location: Centurion
Salary: 90000.00 Monthly
Our client is looking for a Lead developer to join their team. This role is suited to a technically strong and experienced development professional with a passion for building secure, scalable identity solutions while leading delivery within a collaborative team environment. The successful candidate will be responsible for driving high-quality software delivery, defining technical architecture, an...
1 day ago

Java Software Engineer
Location: Johannesburg
Salary:
Our client is looking for a Java Software Engineer to join their team. This role is ideal for a developer who is passionate about building scalable, cloud-ready services and high-quality APIs, while working in a collaborative and modern engineering environment. The successful candidate will take ownership of end-to-end feature delivery, contribute to system design, and help drive engineering excel...
3 days ago

C# Solutions Architect
Location: Johannesburg
Salary:
Our client is looking for a C# Solutions Architect to join their team. This role is suited to a highly experienced technical professional who can bridge the gap between business requirements and robust, scalable software architecture. The successful candidate will play a key role in shaping technical direction, guiding development teams, and ensuring the delivery of high-quality, maintainable solu...
3 days ago

DevOps Engineer
Location: Johannesburg
Salary:
Our client is looking for a DevOps Engineer to join their team. This role is ideal for a technically strong Engineer with solid experience in CI/CD, cloud infrastructure, automation, and supporting software delivery across development, testing, and production environments. This opportunity is well-suited to someone passionate about building reliable, scalable, and automated delivery pipelines whil...
3 days ago

Software Tester
Location: Johannesburg
Salary:
Our client is looking for a Software Tester to join their team on a 3-month contract. This role is suited to a detail-oriented testing professional with solid experience in executing structured test cases, identifying defects, and ensuring software quality across multiple testing environments. The successful candidate will be responsible for supporting system and process testing activities within ...
3 days ago

COMMISSION AND DATA REPORTING OFFICER
Location: Pretoria
Salary: Market related
Growth-focused role, ownership of reporting deliverables, contributing to revenue transparancies
3 days ago

Fusion Compensation Functional Resource
Location: Sandton
Salary:
Our client in the Software sector is looking for Fusion Compensation Functional Resource on a contract duration of 4 months. Role SummaryThe Fusion Compensation Functional Resource is responsible for designing, configuring, and supporting Oracle Fusion Compensation modules across the annual compensation cycle, including salary reviews, bonuses, stock/equity, workforce compensation plann...
9 days ago

Senior Salesforce Developer
Location: Johannesburg
Salary:
Our client is seeking a senior Salesforce developer to join their team, based fully in-office in Bedfordview. This role is suited to a highly experienced Salesforce professional who is passionate about designing scalable architecture, leading technical solutions, and delivering high-quality enterprise systems.
7 days ago

Project Manager
Location: Johannesburg
Salary:
Drive large scale technology change that truly matters. This role places you at the centre of complex digital transformation where your decisions shape systems, teams, and long term impact. If you thrive in high stakes environments and love turning strategy into reality, this opportunity delivers challenge, influence, and growth.
10 days ago

Senior Data Specialist
Location: Johannesburg
Salary:
Are you a senior data professional looking to apply advanced analytics and data science in a highly regulated environment where your insights directly influence strategy, cost management, and risk mitigation? This is an opportunity to work at the centre of decisionâmaking, using sophisticated data tools to drive meaningful business impact.
10 days ago

Senior BI and DATA WAREHOUSE DEVELOPER

Similar jobs you might be interested in:

Create a free job alert for Senior BI and DATA WAREHOUSE DEVELOPER in South Africa

Jobseekers

Recruiter

General