Senior Data Engineer (Business Intelligence)

PLEASE NOTE: THIS IS A CONTRACT POSITION. ONLY APPLY IF YOU QUALIFY ON THE REQUIREMENTS

You must have a BSC degree in Computer Science/Information Systems/Mathematics/Statistics or equivalent. Oracle certification

• 3-5 years + experience working with Oracle PL/SQL, SQL and MDX
• 3-5 years + experience in Extraction Transformation and Loading (ETL) development environment using the Oracle Data Integrator (ODI).
• Work with the technical architecture and development team to contribute to design and
• Interpret data and analyse
• Work with external teams to resolve data
• Design\Implement Data Management strategies which include validation of source data and the use of data in management reporting
• Good technical understanding of data modelling, design and architecture principles and
• Experience in high data volume
• Must have experience in the Kimball methodology
• Experience with OLAP Cubes
• Dimensional data modelling experience
• Experience in working with multi-dimensional cubes
• Project development exposure (waterfall and/or agile methodologies

The following will be adding advantageous to your Skills:

• Working knowledge on programming tools like Python, R, Java, Scala and Julia is advantageous
• Working knowledge on PostgreSQL, Spark, Hadoop, HDFS and Amazon S3
• Experience of working in an agile development Disciplined Agile Development (DAD) experience will be an added advantage

Minimum Technical Competencies and Competencies will be as follow:

• System architecture (technical design and implementation processes)
• Database analysis, design & administration
• Technical Test Plan Design
• IT systems development processes
• System Engineering
• Programming
• Application development
• Standards and governance
• Data modelling using:
• Table structures
• Store Procedures
• SSIS Packages
• SQL

• Proficiency in English (both verbal and written skills);
• Client Orientation
• Verbal and written communication
• Managing Work/Time management
• Problem solving and analysis
• Contributing to Team Success
• Proven ability to accurately estimate work
• Pays attention to details

The Key deliverables will be:

Key deliverables:
·Participate in the interpretation of business requirements and functional specifications as provided by the business analyst into BI solution designs to implement all ETL procedures for all new projects
Design, construct, install, test and maintain highly scalable data management systems.
Development of the Extract Transfer and Load (ETL) function using appropriate technology toolsets to get data into a data warehouse or data mart according to design specifications.
Design and development of the Data Warehouses batch management control processes and error handling procedures.
Application of appropriate Data Quality tools and techniques to ensure that consistent and quality data is provided to the data warehouse
Assist with the design of the star-schemas and/or cubes for consumption by the Oracle BI
Design and develop reports, graphs, analytics, KPIs on the desktop and mobile platforms for analysis purposes in line with the business requirements
Ensure systems meet business requirements and industry
Integrate new data management technologies and software engineering tools into existing
Install and update disaster recovery procedures.
Recommend ways to improve data reliability, efficiency and
Collaborate with data architects, modellers and IT team members on project goals.
Determine in conjunction with the Data Architect what data management systems are
Obtain information from the Data Scientist to determine which data is needed for analysis to determine and provide data which is needed .
Support the achievement of the business strategy, objectives and values
Seek opportunities to improve business processes, models and systems through Agile Thinking