PERSONAL ATTRIBUTES AND SKILLS

• Ability to design and implement complete ETL processes using SSIS and T-SQL.
• Strong ETL experience in loading slowly changing dimensions as well as transactional and snapshot fact tables.
• Strong reporting experience using Microsoft data technology stack such as (, SSRS, Power BI)
• Ability to design and implement semantic models using SSAS
• Ability to write DAX and MDX query
• Proven experience with working with large datasets in the region of billions of records.
• Experience on working with delta datasets and versioned history on target tables.
• Solid experience in understanding ERD’s and source-to-target mappings as well as producing source-to-target mappings of solutions.
• Strong SQL query writing ability (across database environments e.g. Oracle, Netezza, Postgres etc) with a firm understanding of analytical functions.
• Must be able to evaluate technical ETL solutions for inefficiencies (from a database and code perspective) and implement optimization.
• Strong database fundamentals and data modelling knowledge (normalization and de-normalization).
• Good understanding of ODS, data warehouse, data mart, cube, and database technologies.
• Strong analytical and problem solving skills.
• Navigating ambiguity and complexity
• Excellent oral and written communication skills.
• Added advantage of Data mining and BIG data technology including (Python, Spark, H2O)

EDUCATION AND EXPERIENCE

• National Diploma in IT (BTech) – Essential
• Bachelor of Science (Information Systems, Computer Science, Mathematics) – Advantageous
• Microsoft Business Intelligence certifications will be an added advantage
• Minimum 5 years’ experience in BI with over 3 years’ experience in implementing complete BI solutions within an enterprise data warehouse.

The Business Intelligence (BI) developer is responsible for designing, implementing, and supporting ETL solutions according to defined frameworks. The right individual will in addition possess the skills and capabilities to design and implement new frameworks required by the team to keep with evolving changes in sources and technologies. Construction of complex BI Solutions based on requirements of business area owners and/or specifications produced by the BI Architects and Systems Analysts.( BI Solutions imply ETL / Analytics / Presentation).Driving Engagement and building relationships with key stakeholders which include Systems Analysts, BI Architects and Business area owners. The BI Developer should have a firm grasp of BI implementation methodologies especially in a dimensional data warehouse environment using the Microsoft BI stack as a basis for required development.

The candidate should possess the following:

• Analysis and Communication Skills
• Data gathering, research and analytical abilities so as to develop insightful conclusions and generate solutions to address user needs
• Conceptualize and design solutions
• Support and coach other junior systems and business analysts