Senior Data Engineer

A Financial Institute in the Centre of Pretoria has a contract vacancy for a Senior Data Engineer with Business Intelligence Projects

The request for vendors to source and supply a Senior Data Engineer to perform development work in the Business Intelligence (BI) solutions projects

PLEASE NOTE THAT THIS IS A CONTRACT POSITION. PLEASE DO NOT APPLY IF YOU DO NOT QUALIFY. ONLY SUCCESSFUL CANDIDATES WILL BE CONTACTED

Must have a BSc degree in Computer Science / Informtion Systems / Mathematics / Statistics
Oracle ODI 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
Experience in the Kimball methodology
Experience with OLAP Cubes

• 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

The BI development team requires the services of a Senior Data Engineer to assist with development work required on Business Intelligence (BI) Projects, within the Business and Systems Technology Department.

The data engineer will be required to perform development functions as per BI standards in the Company

• 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 environments
• Dimensional data modelling experience
• Experience in working with multi-dimensional cubes
• 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 detail
• 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 procedur