Senior BI Solution Design Specialist (KG
Mediro ICT Recruitment
- Pretoria, Gauteng
- Contract
- Full-time
- BI detailed technical solution architecture, BI data modelling
- Participate in the interpretation of business requirements and functional specifications as provided by the business analyst into BI solution designs.
- Design of the Extract Transfer and Load (ETL) solution to get data into a data warehouse or data mart according to design specifications.
- Design of the Data Lineage models
- Identify and understand data anomalies
- Design of the star-schemas and/or cubes for consumption by the BI toolset.
- Assist in establishing accurate project timelines and development methodology
- Be able to take high-level tasks and break them into detailed actions and tasks to be completed
- Provide input to the overall project planning process by assisting in establishing accurate project timelines actions required and realistic timeframes for completion of those tasks and actions
- Participate in workshops with business owners and stakeholders in respect of clarification of detailed requirements and solutions to those requirement
- Deliver allocated project tasks and actions according to agreed quality and timeframes
- Ensure that detailed tasks and actions are allocated and completed to limit and mitigate risk within the allocated projects
- Develop training manuals, training plans and presenting training courses to support new solution implementations.
- Staying abreast of changes to analytical tools and methodologies
- Co-create with Devops Teams
- Participate in Design forums
- Review all report specifications in accordance with business requirements
- A minimum of a Bachelor Degree in Information Technology or equivalent
- TOGAF Certification
- Data Warehouse Certification (Kimball / Inmon)
- Proven knowledge of Microsoft Power BI Report Server and Microsoft Power BI Services
- Knowledge of on premise to cloud migration to Microsoft Power BI Services
- Proven knowledge of designing solution using Oracle ODI
- Minimum 5 years of experience with detailed architecture designs on Oracle, SAS, Microsoft BI product stacks
- Must be proficient in SQL, Oracle and AIX
- Must be experienced in using SQL Developer for Oracle
- Project exposure (waterfall and agile methodologies)
- Must have solid expertise in designing Star schemas
- Must have experience in BI Infrastructure components from Applications, Databases, Operating Systems and Networks
- Formulation and standards for the BI Ecosystem
- Must have hands on experience designing solutions that integrate complex data sources in both real time and ETL based data extraction mechanisms DIMENSIONS