Key outcomes:

• Designing, developing, and maintaining Data Warehouse and analytics architecture to meet the enterprise’s business analysis and reporting needs;

• Designing, developing, and supporting new and current ETL processes employing industry standards and best practice to enhance loading of data from and into different source/ target systems;
• Working collaboratively with IT architects and business stakeholders to transform the technical vision for applications in Enterprise Data Warehouses employing Pentaho and SQL server.

The Head of Business Intelligence and Analytics will be responsible for:

• Providing support to the organisation’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other suitable source systems;
• Ensuring daily EDW data load completion along with correct data quality;
• Running daily source to destination data reconciliations;
• Analysing business information requirements and transform it to technical DWH design;
• Reviewing, analysing, modifying, and creating ETLs, utilising Pentaho in addition to testing and debugging, integration, implementation processes and ETL backup;
• Understanding and providing insight into Smile’s overall data architecture and working with Smile IT teams in the design and implementation of ETLs and Data Warehouse Scheme;
• Documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilised;
• Supporting BI heads across OpCos to define processes to accommodate new launched services and promotions and guarantee their impact on current data warehouse model;
• Collaborating with business and technology stakeholders in ensuring data warehouse architecture development and utilisation;
• Implementing data access policies and procedures with alignment with Group business risk management;
• Defining requirements and aiding in the implementation and rollout of tools, processes and procedures relating to EDW;
• Defining and managing KPIs for data quality in the data warehouse;
• Implementing the security policies of access to data;
• Identifying and providing input to new technology opportunities that will have an impact on group-wide BI systems;
• Educating users and OpCos on data warehousing capabilities;
• Monitoring and maintaining EDW database to ensure optimum performance;
• Managing server space and motivating for additional resources if required (Space, Processors and Memory);
• Owning data purging policy and server space utilisation
• Backing up data based on data purge policy to SFTP server and to offline data backup storage;
• Managing EDW local version and ensuring cloud and on premise EDW server/s are synced/replicated;
• Owning and managing projects that introduce any new data technology to Smile ECO system such as big data and campaign management.

Qualifications and Experience

Bachelors’ degree/Diploma in Computer Science or BCs Informatics

Essential:

• 5+ years of experience performing data warehouse architecture; development and management in telecommunications industry;
• Solid experience in designing and implementing data warehouse models, ETL and Data Warehousing Concepts;
• Strong knowledge of SQL query language;
• Experience in database administration.

Desirable:

• Knowledge of open source ETL tools like Pentaho
• Experience in designing and delivering analytics models and data marts, Experience in working with Hadoop and big data technologies;
• Demonstrated proficiency in the following competencies preferred:
  • Telecom KPIs;
  • Telecom Business Rules;
  • Telecom Source Systems.
• Ability to perform database housekeeping tasks such as:
  • Database health checks;
  •  Database backup and purging;
  •  Storage Planning and Management;
  •  Database performance tuning.