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.