Data Analyst & Engineer

Knight Auto Precision Engineering Pte Ltd; Singapore; On-site; SGD 55,000 - 75,000; Full time

Job summary

A leading company in precision engineering is seeking a skilled data analyst and engineer to enhance data reporting and governance. The role involves creating dashboards and integrating complex data systems to support various business functions. Ideal candidates will possess a bachelor's degree in data science and over three years of relevant experience in a similar role, with proficiency in Power BI and SQL.

Qualifications

• 3+ years of experience in data analysis and engineering roles, preferably in manufacturing or finance.
• Experience with business intelligence tools like Power BI is essential.
• Strong background in SQL, data modeling, and ETL processes.

Responsibilities

• Collaborate with business functions to define reporting and visualization requirements.
• Develop dashboards and reports using business intelligence tools.
• Design data pipelines for real-time visibility.

Skills

Data Analysis

Reporting

SQL

DAX

Python

Analytical Skills

Education

Bachelor’s degree in data science or related field

Tools

Power BI

Oracle NetSuite

Databricks

Job description

Key Responsibilities:

1.Data Analysis & Reporting

• Collaborate with business functions to define reporting and visualization requirements

• Develop and maintain dashboards and reports using business intelligence tools

• Work with business functions (Sales, Design, Operations, Logistics, and Finance) to ensure data accuracy and consistency

• Perform root cause analysis of data discrepancies and recommend corrective actions

2.Data Engineering & Integration:

• Design and implement data pipelines to extract, transform, and load data from various sources to enable real-time visibility and decision-making

• Optimize data models to support efficient reporting and analysis

• Integrate data from Microsoft 365, HR systems, and other business applications such as SolidWorks (CAD) and the Manufacturing Execution System (MES)

• Automate data cleansing and validation processes to improve overall data quality

3.Data Governance & Quality

• Establish data standards, governance frameworks, and best practices for data management

• Identify data quality issues and implement solutions to enhance reliability

• Support audits and compliance activities by providing accurate datasets and reports

4.Oracle NetSuite Operations:

• Be part of the team to support NetSuite ERP operations, including liaising with external vendors to resolve user-reported issues

• Assist in developing and maintaining SuiteQL queries for reporting and analytics

Job and Education Qualifications:

• Bachelor’s degree in data science, Computer Science, Information Systems or related field

• 3+ years of experience in data analysis and engineering roles, preferably in manufacturing or finance

• Experience with business intelligence tools (e.g. Power BI) is essential

• Strong background in SQL, data modeling and ETL processes

• Prior experience in NetSuite Analytics is advantageous

• Hands-on experience with Oracle products, especially for financial reporting and visualization

• Strong Knowledge of ERP data structures, particularly financial modules

Technical Skills:

• Proficient in Power BI, including DAX, Power Query (M), and data model optimization for performance

• Strong SQL skills (e.g., T-SQL, SuiteQL) for ERP and financial data analysis

• Experience in data wrangling and transformation using Python or R for automation and preprocessing

• Familiarity with APIs (REST/SOAP), JSON/XML data structures, and integrating with ERP or SaaS applications

• Experience with Databricks and Microsoft Fabric for advanced analytics and scalable data processing

• Understanding financial processes and accounting principles is highly desirable

Soft Skills:

• Strong analytical and problem-solving skills, with the ability to approach challenges from a technical perspective

• Resourceful and self-driven, with the ability to independently analyze complex problems, break them down into manageable parts, and implement effective solutions

• Excellent communication and collaboration abilities, capable of working effectively across functions (finance, design, manufacturing, IT, and supply chain)

• Meticulous in ensuring data accuracy, with a continuous drive to improve data-related processes and workflows

• Ability to manage multiple priorities in a fast-paced environment