Data & Analytics Engineer (1 Year Contract)

MORGAN MCKINLEY PTE. LTD.; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

Morgan McKinley Pte Ltd in Singapore seeks a data engineering professional to design and implement data jobs and reporting solutions meeting analytical needs.

You will refine data collection, build dashboards with SAP BO/Tableau, and work with Python, PySpark, Linux, and ETL tools such as Informatica. Experience with Cloudera AI and related data platforms is highly desirable to support automation and AI-assisted development.

Qualifications

• Strong grasp of waterfall and Agile project methodologies.
• Extensive experience with SQL, data modelling and data analysis.
• Hands-on with Python, PySpark, Linux, and ETL tools like Informatica.
• Experience with BI/reporting tools such as SAP BO and Tableau.
• Familiarity with Hive/Impala and Cloudera Data Platform is preferred.

Responsibilities

• Analyse data needs and document the requirements.
• Refine data collection/consumption by migrating data collection to more efficient channels.
• Plan, design and implement data engineering jobs and reporting solutions to meet analytical needs.
• Develop test plans and scripts for system testing, support user acceptance testing.
• Build reports and dashboards according to user requirements.
• Work with technical teams to ensure smooth deployment and adoption of new solution.
• Ensure the smooth operations and service level of IT solutions.
• Support production issues.
• Apply AI coding tools such as Copilot and Coder AI to support development, testing, and code reviews.
• Use automation to improve development efficiency, including build, test, and deployment activities.
• Leverage AI assistance to improve code quality, covering refactoring, defect resolution, and documentation.
• Demonstrate willingness to adopt new AI and automation tools where relevant to work outcomes.

Skills

SQL

Data modelling

Data analysis

Python

PySpark

Linux

Tableau

Tools

Cloudera AI

Plotly

Informatica

Tableau

Denodo

Hive

Impala

Cloudera Data Platform

Job description

Key Responsibilities

• Analyse data needs and document the requirements.
• Refine data collection/consumption by migrating data collection to more efficient channels.
• Plan, design and implement data engineering jobs and reporting solutions to meet the analytical needs.
• Develop test plan and scripts for system testing, support user acceptance testing.
• Build reports and dashboards according to user requirements
• Work with technical teams to ensure smooth deployment and adoption of new solution.
• Ensure the smooth operations and service level of IT solutions.
• Support production issues
• Apply AI coding tools such as Copilot and Coder AI to support development, testing, and code reviews.
• Use automation to improve development efficiency. This includes build, test, and deployment activities.
• Leverage AI assistance to improve code quality, covering refactoring, defect resolution, and documentation.
• Demonstrate willingness to adopt new AI and automation tools where relevant to work outcomes.

Requirements

• Good understanding and completion of projects using waterfall/Agile methodology.
• Working experience using Cloudera AI (Machine Learning), Plotly and data engineering AI tool stack
• Strong SQL, data modelling and data analysis skills are a must.
• Hands-on experience in big data engineering jobs using Python, Pyspark, Linux, and ETL tools like Informatica.
• Hands-on experience in a reporting or visualization tool like SAP BO and Tableau is must.
• Hands-on experience in DevOps deployment and data virtualisation tools like Denodo will be an advantage.
• Hand-on experience in scripting like python and shell scripts will be an advantage
• Track record in implementing systems using Hive, Impala and Cloudera Data Platform will be preferred.
• Good understanding of analytics and data warehouse implementations.
• Ability to troubleshoot complex issues ranging from system resource to application stack traces.
• Track record in implementing systems with high availability, high performance, high security hosted at various data centres or hybrid cloud environments will be an added advantage.
• Passion for automation, standardization, and best practices.
• AI and automation scope past experience will be an advantage.

Morgan McKinley Talent Solutions

Morgan McKinley Pte Ltd EA Licence No: 11C5502

EAP Registration No: R2196712

EAP Name: Chew Kai-Xinn