Engineer, Business Analytics Data

SCHOTT

Seberang Perai

On-site

MYR 90,000 - 150,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Canteen

Exclusive employee benefits/discounts

Flexible working hours

Free Parking

Job summary

SCHOTT is seeking a Data Engineer to design and maintain scalable data pipelines using Microsoft Fabric, ETL/ELT processes, and notebooks. You will shape data architecture, model lakehouse and warehouse structures, and integrate data from ERP/CRM/MES for reporting and analytics.

You will collaborate with Process Analysts, IT, and Smart Manufacturing Engineers to deliver governed datasets, ensure data quality, and support self-service analytics across global teams. Hybrid work arrangement offered.

Qualifications

Bachelor's or Master's degree in Data Engineering, Computer Science, Information Systems, or related discipline.
3–7 years of experience in data engineering, data architecture, or cloud-based data platform development.
Strong hands-on experience with Microsoft Fabric.
Experience designing and managing Lakehouse and Data Warehouse architectures.
Proficiency in ETL/ELT development using Microsoft Fabric Data Factory, Dataflows, and Notebooks.
Experience integrating data from ERP, CRM, MES, and other enterprise systems.
Knowledge of SQL, data modeling, data governance, and cloud-based data platforms.
Experience with data quality, monitoring, and pipeline optimization.

Responsibilities

Design, build, and maintain scalable data pipelines for ingesting and transforming data from multiple source systems.
Develop ETL/ELT processes using Microsoft Fabric Data Factory, Notebooks, and Dataflows.
Design and maintain data architecture within Microsoft Fabric, including lakehouse and warehouse structures.
Integrate data from ERP, MES, CRM, and other operational databases; build connectors and ingestion pipelines.
Implement data validation, monitoring, and error-handling mechanisms.
Collaborate with Process Analysts, IT, and Smart Manufacturing Engineers to provide structured datasets for reporting and dashboards.
Monitor performance and optimize pipelines, storage, and compute usage; contribute to governance and metadata management.

Skills

Analytical thinking

Problem solving

Communication

Stakeholder management

Team collaboration

Education

Bachelor's or Master's Degree in Data Engineering, Computer Science, Information Systems

Tools

Microsoft Fabric

Data Factory

Dataflows

Notebooks

Lakehouse architecture

Data Warehouse

SQL

Job description

Your Contribution

1. Data Pipeline Development

Design, build, and maintain scalable data pipelines for ingesting and transforming data from multiple source systems (e.g., ERP, CRM, manufacturing systems). Develop ETL/ELT processes using Microsoft Fabric Data Factory, Notebooks, and Dataflows. Ensure efficient data movement, transformation, and orchestration. Identify opportunities to automate data workflows and improve pipeline efficiency.

2. Data Architecture & Modeling

Design and maintain the data architecture within Microsoft Fabric / selected data platform, including lakehouse and warehouse structures. Implement scalable data models optimized for reporting and analytics. Define best practices for data structure, partitioning, and performance optimization.

3. Data Integration

Integrate data from enterprise systems such as ERP, MES, CRM, and other operational databases. Build connectors and ingestion pipelines for structured and semi-structured data. Support real-time or near real-time data integration where required under consideration of cost-benefit optimization.

4. Data Quality & Reliability

Implement data validation, monitoring, and error-handling mechanisms. Ensure high levels of data accuracy, completeness, and consistency across the data platform. Troubleshoot and resolve data pipeline failures or performance issues.

5. Communication

Work closely with Process Analysts, IT and Smart Manufacturing Engineers to provide well-structured datasets for reporting and dashboards. Translate business and reporting requirements into scalable data models. Enable self-service analytics through curated and governed datasets under alignment of BU Advanced Optics Data Strategy. Align project requirements with Corporate IT, global Business Process Owners and other global functions to ensure conformity to global governance and reporting standards. Maintain a good and professional relationship with internal customers and stakeholders.

6. Platform Optimization & Governance

Monitor performance and optimize pipelines, storage, and compute usage within Microsoft Fabric / selected data platform. Implement governance standards for data security, access control, and metadata management. Contribute to the overall data architecture strategy. Evaluate new data engineering tools and features. Support the evolution of the company’s enterprise data platform.

Your Profile

Education

Bachelor's or Master's Degree in Data Engineering, Computer Science, Information Systems, or a related discipline.

Experience

3–7 years of experience in data engineering, data architecture, or cloud-based data platform development.

Technical Competencies

Strong hands‑on experience with Microsoft Fabric.
Experience designing and managing Lakehouse and Data Warehouse architectures.
Proficiency in ETL/ELT development using Microsoft Fabric Data Factory, Dataflows, and Notebooks.
Experience integrating data from ERP, CRM, MES, and other enterprise systems.
Knowledge of SQL, data modeling, data governance, and cloud-based data platforms.
Experience with data quality, monitoring, and pipeline optimization.

Soft Skills

Strong analytical and problem solving skills.
Excellent communication and interpersonal skills.
Ability to collaborate effectively with cross‑functional and global teams.
Strong stakeholder management and customer oriented mindset.
Excellent command of written and spoken English.

Your Benefits

SCHOTT’s openness to promote your further development is just as great as our additional benefits. Ranging from active health management via flexible working hours and hybrid work all the way to corporate pension plans: everything geared to suit your goals and needs. Discover a special corporate culture where everyone has the opportunity to develop their entire potential.

At SCHOTT, you can expect a unique corporate culture where we emphasize equity, diversity, and inclusion. We know: motivated and committed employees are the precondition for the success of our company.