Data Engineer at Cellulant Corporation

Job Description

• Develop and support current and future Cellulant Enterprise Systems (e.g. Oracle Data Warehouse, Oracle Business intelligence, NetSuite ERP, TribeHR and eHorizon Payroll).
• Work with other departments within the company to identify requirements and develop solutions (database design, scripts/ETL/ELT, workflows and user/data interfaces).
• Configure and/or customize the Enterprise Systems to meet business requirements using various database and software tools.
• Assist in presentations of system functionality to new users and departments.
• Enhance and create user and system documentation as needed.

Reports To: Group Lead Enterprise Systems Analyst.

Responsibilities

Enterprise System Operations

• Migrate all current standard and ad hoc transaction data scripts from HUB to the DWH considering the scripts’ functions and access rules.
• Setup, maintain and modify reports/queries on an as-needed basis.
• Periodically validate data and data scripts and critical reports in the Enterprise Systems to ensure data accuracy as the data applied has an impact on the integrity of the company.
• Provide guidance to various analysis/reporting teams on the best data extraction/reporting practises (knowledge sharing).
• Provide input in the design & implementation phases of various internal transaction processing Systems to ensure they adequately support transactional reporting requirements.
• Design and develop front-end tier(s), middle tier(s), and /or back-end database tier(s) for business applications.
• Map business information needs to the software and /or database components;
• Perform data modelling to analyse and specify data structures within an application system;
• Coding of all ETL and analytics processes used within the BI systems;
• Provide input on design approach, performance and base functionality improvements for various procedures and applications
• Create test plans, test data sets and perform automated testing to ensure all components of the developed systems meet specifications;
• Formalize test plans and implement troubleshooting procedures;
• Applying software patches as necessary;

Enterprise Systems Administration

• Manage and support security implementations;
• User administration in all Systems
• Managing billing factors in NetSuite
• Configuring scripts, triggers, schedules to meet user requirements in the various systems

Enterprise System Uptime

• Continuous system monitoring to proactively identify and resolve any system issues.
• Troubleshooting database connectivity issues;
• Maintain/coordinate back-up and restore the ETL and reports repositories and other Systems binaries and source codes;
• Work with the TechOps teams to resolve issues identified and escalated during daily operations;
• Perform root-cause analysis for recurring incidents;

Qualifications

• Degree in Computer Science, Statistics, Mathematics or another technical-related field;
• Oracle Certified Developer;
• Certification in RDBMS;
• 3 years development experience with development tools e.g. Java;
• 3 years development experience with low level programming C++, C.;
• 3 years’ experience RDMS preferably Oracle, MS SQL Server;
• 3 years’ experience in data warehousing, business analysis, knowledge in Business Systems modelling and data retrieval;
• Experience with Big Data Technologies (Hadoop, Hive, Hbase, Pig, Spark, etc.)
• Python/R/Spark Data Mining experience will be an added advantage;
• Systems Analysis and Solutions Architecting;
• Programming and Systems Development;
• SQL & Oracle database management;
• Data Quality & Cleansing experience;
• Advanced Unix scripting and user skills;
• Experience in processes and procedures management;
• Communication, interpersonal skills and attention to detail