Software Developer/ Data Engineer/ Business Analyst / Operator - ETL


Job ref no. EH
Job level
Work experience
Education Bachelor Degree
Location Kowloon
Employment type Full Time
Benifits
Industry Information Technology
Job function Information Technology (IT)
Post on 2024-08-01

System Analyst / Software Developer

Responsibilities: 

  • Develop data migration programs on data quality and data mapping processes
  • Review SQL scripts according to business requirement and data specification
  • Review reconciliation tasks 
  • Shift duties for system supports are required 

Data Engineer

Responsibilities: 

  • Translate Data Pipeline requirements into data pipeline design, guide and direct the design in collaboration with stakeholders including architecture team, developers, data consumers, data providers, and business users
  • Contribute to use case development, e.g. workshop to gather and validate business requirements.
  • Model and design the ETL pipeline data structure, storage, integration, integrity check and reconciliation
  • Prepare technical specifications and user requirements
  • Design and enhance data model to manage risk and cost of change for the data platform
  • Analyse data sources with structured Data Quality Evaluation approach
  • Bridge the gap between business requirements and ETL logic by solving data discrepancies and implementing scalable solutions.


Business Analyst / Business Analyst Lead

Responsibilities:

  • Collect and consolidate the business and technical requirements for assigned project(s) by demonstrating excellent communication and stakeholder management skills, hosting workshops, and applying other requirements collection techniques where necessary.
  • Producing, maintaining and taking ownership of project deliverables required and assigned by direct supervisor.
  • Creating process flows, mock-ups, and other materials to remove ambiguity and support project requirement definitions. 
  • Coordinate with internal teams and vendors to formulate effective solution for assigned project(s) within the defined schedule.
  • Communicate with all project stakeholders, including external customers and internal teams, to facilitate the smooth execution of the project implementation process. 
  • Willing to work on rotation shift to support 7 x 24 hours operations during the production cutover for individual project. 

Project Manager 

Responsibilities: 

  • Lead and manage the Data Engineer, Business Analyst, and QA teams to ensure project objectives are met.
  • Collaborate with cross-functional teams and stakeholders to understand data requirements and ensure data quality and accuracy.
  • Conduct data quality tests, generate reports, and work with stakeholders to address any issues.
  • Design and maintain scalable data pipelines, optimize existing processes, and monitor system performance.
  • Ensure data security and compliance with regulatory requirements.
  • Lead QA efforts for the project, ensuring that testing meets standards and requirements.
  • Work with different stakeholders to gather requirements, provide updates, and address concerns.

System Support

Responsibilities: 

  • Provide support for the night batch cycle process
  • Monitor system performance
  • Troubleshoot technical issue about system functioning, data processing, online operations
  • Liaise with cross-functional teams to resolve system-related incidents
  • Compile documentation related to system support procedures, troubleshooting guidelines, and knowledge base articles


Operator

Responsibilities: 

  • Performing data processing operations according to a business production schedule.
  • Batch jobs processing and monitoring.  Preliminary troubleshoot as per training/operation materials.   

System Analyst / Software Developer

Requirement:

  • Systems Analyst - 5 to 7 years' relevant experience
  • Software Developer - 2 to 3 years' relevant experience
  • Proven experience in PL/SQL or T/SQL
  • Proven experience in Java with SQL statement embedded
  • Knowledgeable in Oracle Relational Database & MS SQL Server


Data Engineer

Requirement:

  • Degree or above in mathematics, statistics, IT, computer science, engineering, or related disciplines
  • Proficient in both English and Chinese (Mandarin or Cantonese)
  • 8 years or above of IT experiences with 2 years in data migration / data pipelines projects
  • Solid technical knowledge in data modelling and architecture principles and techniques across master data, transaction data and data warehouse
  • Experienced in Stored Procedure (PL/SQL) & SQL DDL/DML


Business Analyst / Business Analyst Lead
Requirement:

  • Degree holder in Computer Science, IT or related subjects
  • 3+ years' expertise in the Business Analysis
  • 8+ years of relevant project experience in Business Analysis will be considered for the role of Business Analyst Lead 
  • Business knowledge in MPF scheme operations is highly preferred
  • Experience in data migration is highly preferred
  • Experience in SQL is preferred
  • Experience in system development lifecycle and system integration is preferred 
  • Knowledge in analysis of ‘As Is’ systems and ‘To Be’ systems and processes
  • Knowledge in building process flows, customer journeys, and use cases.
  • Hands-on in preparing business requirements
  • Hands-on in creating and maintaining traceability matrices
  • Able to handle and manage multiple competing priorities in a fast-paced environment
  • Proficient in MS Office suite
  • Knowledge in SQL programming


Project Manager 

Requirement:

  • Bachelor degree in Computing
  • Proven experience as a Project Manager and at least 5 years in data engineering or related fields.
  • Strong proficiency in Oracle and MS SQL Server, with hands-on experience in PL/SQL, Oracle SQL, and T-SQL, experience in SQL tuning.
  • Experience in ETL (Extract, Transform, Load) processes is a must.
  • Experience in data warehousing is a must.
  • Team lead experience is required.
  • Excellent problem-solving and troubleshooting skills.


System Support

Requirement:

  • Proven experience in system support with a focus on night batch cycle support and online systems
  • Proficient in SQL for database querying and manipulation
  • Knowledge of Spring Boot framework for Java-based application is essential
  • Hands-on in handling complicated technical issues related to systems, databases, networks, applications
  • Flexibility to work on shifts including nights, weekends, or holidays


Operator

Requirement:

  • Certificate / Diploma in Computing
  • 1-2 years relevant working experience
  • Basic knowledge in computing operation.
  • Familiar with computer operating system, such as Windows and Linux.  With SQL knowledge is preferable. 
  • Able to follow training materials or operation procedures to carry out daily operations, monitoring and scheduling jobs.