About the position
Key deliverables:
•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
Minimum Requirements:
Education and experience:
•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
•Experience with facilitating workshops.
•Experience in negotiating for desired outcomes.
Desired Skills:
- Kimball
- Togaf Certification
- Power BI
- Oracle
- SQL
