JOB DESCRIPTION
The Business Intelligence Business Analyst (BIBA) primarily serves as liaison between the end users and BI project team and gathers business requirements. The BIBA is an expert in understanding business objectives, questions, and problems, and at obtaining and presenting data to address the issues. The analyst understands the tools and techniques used to create data results that range from basic queries through multidimensional analyses and data mining, forming new relations and derivations as necessary, and extracting the maximum amount of valid information content from the data. Extensive insight into the business and the data are essential.
The BIBA participates in design of data marts to provide the optimal balance of data availability, format, flexibility, and performance. The BIBA is involved in the end-to-end Data Product Lifecyle, including requirement definition, data analysis, data modelling.
Duties:
Requirement’s definition phase:
- Interview end users to determine requirements for data, reports, analyses, metadata, training, service levels, data quality, and performance
- Help identify and assess potential data sources
- Validate that BI meets requirements and service level agreements
- Coordinate prototype reviews
- Gather prototype feedback
- Document requirements in relevant formats:
- Data Warehouse content requirements
- Data Mart requirements
- Information output requirements
- Information exploitation tool – functional requirements
Data Profiling, Feasibility and Scope Definition Phase:
- Analyse business information requirements
- Recommend appropriate scope of requirements and priorities
- Work with production data to validate business requirements
- Map business needs/requirements to subject area model and to logical enterprise model
- Discover dimension hierarchies
- Validate hierarchies with production data
- Define business rules for state detection
Design Phase:
- Work with architects to translate requirements into technical specifications
- Discover business transformation rules
- Work with production data to design access structures
- Classify business users by type
- Develop security rules/standards
- Create state transformation models
Development Phase:
- On-hand support to development team to accurately interpret requirements and translate into a quality solution.
Testing Phase:
- Plan acceptance test (functional and data integrity)
- Execute acceptance test plan internally
- Facilitate user acceptance testing
Change Management and Deployment:
- Educate users on warehousing capabilities
- Design training infrastructure
- Define and get agreement with business users on service-level agreements
- Develop training materials
- Write users' guide
- Train BI users
- Assist with definition of support plan
- Interface with process teams regarding business process reengineering
- Assist users in finding the right information
Skills and Experience Required:
- At least 3 / 5 years’ experience with a proven track record of delivering Data & Analytics projects through facilitating the Data/Analytics Development Lifecycle.