Purpose of the job To perform and manage the solution and software development within the Transversal Solutions department in order to design, develop / procure, package, release and maintain/enhance e-Learning transversal solutions, in accordance with ICT standards and the enterprise architecture for Government.
This includes the development of enterprise Solution, the integration thereof with the other applicable Enterprise, and coordination of systems / process / product development across a number of disciplines to achieve objectives.

Key Responsibility Areas
• Support Transversal Solutions in developing and implementing strategies and roadmaps to ensure a comprehensive and integrated transversal solutions function.
• Participate in the development, implementation and evaluation of governance mechanisms and monitor the adherence thereto so as to deliver quality products in a controlled environment.
• Manage the implementation of the solution development life cycle which includes the full life cycle management of the solution to ensure standardisation in the business which will enable the delivery of a high quality solution and products for improved service delivery.
• Participate in the Architectural mechanisms to improve interoperability of government systems.
• Support implementation of software IT solutions so as to meet service delivery commitments in a way that complies with architectural standards and established methodologies and practises.
• Programmes/projects manage development/procurement and maintenance projects of transversal solutions so as to meet Transversal Solutions service delivery commitments.

Qualifications and Experience Minimum requirements:
Bachelors degree in an ICT related field (Computer Science, Information Systems, Technology and Engineering) or equivalent.

Experience:
• 7-8 years of experience in building ETL solutions using the Microsoft Suite (SSIS, SSAS, SSRS);
• OLAP Cube development;
• MDX - Multi-Dimensional Expressions:
• Strong SSIS Package development;
• SSRS report development;
• 5+ years of experience in SQL database environments;
• Ability to develop complex SQL scripts to manipulate large data structures;
• Data Modeling skills essential - solid dimensional modeling experience working with large data warehouse environments;
• 5+ years ETL (Extraction, Transformation and Loading)
• Experience; reusable ETL components;
• Experience of ETL and DWH best practices;
• ETL Performance Tuning;
• Knowledge and experience of DWH implementation methodologies;
• Design methodologies;
• Development methodologies

Technical Competencies Description Knowledge of:
• Corporate Governance;
• ICT Governance and Compliance Governance e.g. Cobit and ITIL Development Methodologies;
• Implementation Methodologies;
• IT Quality Management e.g. ISO9001 and CMMI
• IT Security;
• ICT Standards;
• Integration Methodologies;
• COTS (Commercial of the Shelf) Products;
• OSS (Open Source Software) Products;
• IT Strategies and Architectures;
• Project Management;
• Execution of Architecture methods and practices e.g. TOGAF and GWEA

Skills:
• Development (.NET Framework, Java Framework, Other IDE);
• Enterprise architecture framework (TOGAF, Zachman, FEAF, MODAF, GWEA Framework, MIOS);
• Security (Software and Technologies) ;
• Portal (HTML, CSS, JAVA scripting, Portlets with various integrations)
• Interfacing and Integration (Middleware Technologies);
• Development methodologies (RUP, OpenUp, Agile),
• SDLC (ISO9001,ISO\IEC12207) );
• Entity Relationship Diagram;
• Governance Processes and Standards (COBIT, ITIL, UML)

• Other Special Requirements Assist the Senior Software Developer in developing software solutions;
• Develop software components from UML designs and specifications;
• Understand the SDLC;
• Perform unit testing on all developed components.
• Develop SQL queries to assist data quality assessment initiatives.