Business Intelligence Business Analyst (BIBA)

at  PBT Group

Cape Town, Western Cape, South Africa -

Start DateExpiry DateSalaryPosted OnExperienceSkillsTelecommuteSponsor Visa
Immediate19 Jan, 2025Not Specified20 Oct, 2024N/AEtl,Data Analysis,Reporting,Sas,Information Systems,Data Extraction,Computer Science,Data Models,Agile,Etl Tools,Analytics,Data Warehousing,Transformation,StorageNoNo
Add to Wishlist Apply All Jobs
Required Visa Status:
CitizenGC
US CitizenStudent Visa
H1BCPT
OPTH4 Spouse of H1B
GC Green Card
Employment Type:
Full TimePart Time
PermanentIndependent - 1099
Contract – W2C2H Independent
C2H W2Contract – Corp 2 Corp
Contract to Hire – Corp 2 Corp

Description:

PBT Group has a requirement for a technical Business Intelligence Business Analyst (BIBA) with SAS experience. In addition to standard Business and Data Analysis skills, the candidate must demonstrate hands-on technical expertise in ETL processes, SAS, and experience as a developer or programmer. A strong background in dimensional data modelling and data warehousing is crucial for success in this role.

SKILLS & EXPERIENCE REQUIRED:

  • ETL: Strong experience in designing and implementing ETL processes, including data extraction, transformation, and loading.
  • SAS: Proficiency in using SAS for data analysis, reporting, and business intelligence tasks.
  • Development/Programming Experience: Hands-on experience as a developer/programmer in a BI or data-related field.
  • Dimensional Data Modelling: Proven experience in designing and implementing dimensional data models for BI reporting and analytics.
  • Data Warehousing: Extensive knowledge of data warehousing principles, including database structures, storage, and retrieval processes.

PREFERRED QUALIFICATIONS:

  • Bachelor’s degree in Computer Science, Information Systems, or a related field.
  • Certifications in SAS, ETL tools, or data warehousing technologies (preferred).
  • Previous experience working in Agile or Scrum development environments.
  • Strong analytical and problem-solving skills.
  • Excellent communication and stakeholder management abilities.

Responsibilities:

  • Collaborate with business stakeholders to gather, analyse, and document business requirements for BI solutions.
  • Translate business requirements into technical specifications for ETL processes and data transformations.
  • Design and implement dimensional data models to support business intelligence reporting and analytics.
  • Work with development teams to ensure accurate data extraction, transformation, and loading (ETL) processes.
  • Analyse and optimise existing data warehouse structures to improve performance and efficiency.
  • Develop reports and dashboards using SAS or other relevant tools to meet business needs.
  • Collaborate with data engineers, developers, and other IT teams to ensure successful delivery of BI projects.
  • Perform gap analysis and ensure data integrity across the data warehouse and reporting platforms.
  • Troubleshoot data-related issues and perform root cause analysis.


REQUIREMENT SUMMARY

Min:N/AMax:5.0 year(s)

Information Technology/IT

Analytics & Business Intelligence

Business Analysis

Graduate

Computer science information systems or a related field

Proficient

1

Cape Town, Western Cape, South Africa