Business Intelligence Business Analyst (BIBA)

SUMMARY:
-

POSITION INFO:

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.

Key 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.

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.