Data Engineer/ Project Manager/ System Analyst/ System Support - ETL (~65k)
| Job ref no. | EH |
| Job level | |
| Work experience | |
| Education | Bachelor Degree |
| Location | Hong Kong Island |
| Employment type | Full Time |
| Benifits | |
| Industry | Information Technology |
| Job function | Information Technology (IT) |
| Post on | 2024-07-11 |
Data Engineer (40k-65k)
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 (30k-45k) / Project Manager (Up to 65k)
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.
System Support (25k-50k)
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
System Analyst / Software Developer (30k-65k)
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 (40k-65k)
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 (30k-45k) / Project Manager (Up to 65k)
Requirement:
- Degree holder in Computer Science, IT or related subjects
- 3+ years' expertise in the Business Analysis
- Previous experience as Project Manager and at least 5 years' experience in engineering will be considered for Project Manager role
- 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
System Support (25k-50k)
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
System Analyst / Software Developer (30k-65k)
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