Business Intelligence Business Analyst (BIBA)
at PBT Group
Cape Town, Western Cape, South Africa -
Start Date | Expiry Date | Salary | Posted On | Experience | Skills | Telecommute | Sponsor Visa |
---|---|---|---|---|---|---|---|
Immediate | 19 Jan, 2025 | Not Specified | 20 Oct, 2024 | N/A | Etl,Data Analysis,Reporting,Sas,Information Systems,Data Extraction,Computer Science,Data Models,Agile,Etl Tools,Analytics,Data Warehousing,Transformation,Storage | No | No |
Required Visa Status:
Citizen | GC |
US Citizen | Student Visa |
H1B | CPT |
OPT | H4 Spouse of H1B |
GC Green Card |
Employment Type:
Full Time | Part Time |
Permanent | Independent - 1099 |
Contract – W2 | C2H Independent |
C2H W2 | Contract – 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