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:

Senior BI Developer
Location: Johannesburg
Salary: 600000 Annually
Our client is seeking a senior bi developer (Specialist) to join their dynamic team in the East of JHB - (Bruma)
22 days ago


Senior BI Developer
Location: Johannesburg
Salary: TBC Annually
Are you a senior bi developer with advanced Power bi and Microsoft Cloud expertise? Join a dynamic team and work on cutting-edge data projects that drive business decisions!
26 days ago


Senior BI Developer
Location: Johannesburg
Salary: Annually
Seeking a bi developer who will be responsible for data analysis, reporting and visualisation, with a focus on the Microsoft Cloud bi Platform.
28 days ago


Senior BI Developer
Location: Pretoria
Salary:
Turn data into decisions that shape the future—join our client as a bi developer and make an impact with cutting-edge analytics.
29 days ago


Senior BI Developer - Hybrid
Location: Sandton
Salary:
35 days ago


Senior Data Analyst
Location: Johannesburg
Salary: Hourly
Role Summary:The senior data Analyst will play a pivotal role in transforming data into actionable insights that drive strategic decision-making across the organisation. This role requires a strong analytical mindset and proficiency in data visualisation. The ideal candidate will bridge the gap between data and business. Responsibilities:Develop and maintain dashboards and reports to support ...
Today


Senior Data Scientist
Location: Johannesburg
Salary: Market Related Monthly
Role Summary:The senior data Analyst will play a pivotal role in transforming data into actionable insights that drive strategic decision-making across the organisation. This role requires a strong analytical mindset and proficiency in data visualisation. The ideal candidate will bridge the gap between data and business. Responsibilities:Develop and maintain dashboards and reports to support ...
Today


Senior Financial Accountant
Location: Johannesburg
Salary:
Today


Lead Software Developer
Location: Johannesburg
Salary: 1 000 000 Annually
Are you a senior Software developer with proven Tech Lead experience and a passion for building scalable, secure solutions? Join a leading financial services organization and drive digital transformation projects that make a real impact!
1 day ago


Senior Storeman
Location: Johannesburg
Salary:
1 day ago


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

Enter your email address below and we will email you similar jobs when they become available:

You can cancel at any time. We will not spam you.
By giving us your email address your agree to our Terms and Conditions