Data Analyst & Engineer - #1116996

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