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.