Senior Data Engineer

INNOVATIQ ENGINEERING PTE. LTD.; Singapore; On-site; SGD 70,000 - 120,000; Full time

Job summary

INNOVATIQ ENGINEERING PTE. LTD. is seeking a data engineering professional to analyze data needs and design end-to-end data pipelines and dashboards. You will migrate data collection to efficient channels and implement scalable reporting solutions.

You will use Python, PySpark and SQL to build ETL processes, work with Cloudera/Data Platform, and deploy solutions with DevOps practices. Familiarity with AI tools like Copilot and Coder AI is beneficial.

Qualifications

• Experience delivering projects using waterfall or Agile methodologies.
• Strong SQL, data modeling and data analysis skills are required.
• Hands-on experience in big data engineering with Python, PySpark, Linux and ETL tools like Informatica.
• Hands-on experience in reporting/visualization tools like SAP BO and Tableau.
• DevOps deployment and data virtualization tools like Denodo are a plus.
• Scripting in Python and shell scripts is advantageous.
• Experience with Hive, Impala and Cloudera Data Platform preferred.
• Understanding of analytics and data warehouse implementations.
• Ability to troubleshoot complex issues from system resources to application traces.
• Experience with high availability, performance, and security across data centers or hybrid clouds.
• Passion for automation, standardization and best practices.
• Experience with AI and automation tools is advantageous.

Responsibilities

• Analyse data needs and document requirements.
• Refine data collection by migrating to efficient channels.
• Plan, design and implement data engineering jobs and reporting solutions.
• Develop test plans and scripts for system testing and UAT.
• Build reports and dashboards per user requirements.
• Collaborate with IT teams for deployment and adoption of new solutions.
• Ensure smooth operations and service levels of IT solutions.
• Support production issues.
• Apply AI coding tools to support development, testing and reviews.
• Use automation to improve build, test and deployment.
• Leverage AI to improve code quality, refactoring, defect resolution and documentation.
• Demonstrate willingness to adopt new AI/automation tools where relevant.

Skills

SQL

Data modeling

Data analysis

Python

PySpark

Linux

ETL tools

Tableau

Cloudera Data Platform

Hive/Impala

Plotly

AI coding tools

Tools

Informatica

SAP BO

Tableau

Denodo

Hive

Impala

Cloudera Data Platform

Job description

Key Responsibilities

• Analyse the Authority’s 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 the Authority’s 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. This covers refactoring, defect resolution, and documentation.


• Demonstrate willingness to adopt new AI and automation tools where relevant to work outcomes.

What we are looking for

• 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.