Staff Cloud Data Engineer

Osram (Malaysia) Sdn Bhd; Kedah; On-site; MYR 120,000 - 180,000; Full time

Job summary

ams OSRAM Malaysia invites a skilled Data Engineer to work with global teams on cloud data warehouse solutions. You will implement scalable data pipelines, apply SQL/Python transformations, and ensure data security while collaborating with data scientists and analysts.

The role requires 5+ years in cloud data warehousing, hands-on with Snowflake/Databricks, data vault 2.0 or star schema, and strong SQL/ETL expertise. English communication with international stakeholders is essential.

Qualifications

• Bachelor’s degree in Computer Science or related field.
• Minimum 5 years of related working experience with cloud data warehouse technologies.
• Hands-on experience in data warehouse modelling (Data Vault 2.0 and/or Star Schema).
• Strong understanding of relational databases (SQL) and ETL frameworks.
• Experience with data visualization tools such as PowerBI and data integration using modern ETL tools.

Responsibilities

• Work closely with data scientists and analysts to translate data requirements into technical specs.
• Design and implement cloud-based data solutions aligned with business needs.
• Develop scalable data pipelines from multiple source systems.
• Apply business rules and transformations using SQL or Python.
• Ensure data security with object and row level access controls.

Skills

Snowflake

Databricks

SQL

Python

Data Modeling

dbt

Apache Airflow

PowerBI

Data Vault 2.0

Star Schema

SCRUM

English Communication

Education

Bachelor’s degree in Computer Science or related field

Tools

Apache NiFi

Theobald Universal Xtract

Azure Data Factory

dbt

Apache Airflow

PowerBI

Job description

• Work closely with data scientists, business analysts and other stakeholders to understand their data requirements and translate them into technical specifications and data models.
• Collaborate with data architects to design and implement cloud-based data solutions that align with business needs.
• Facilitate internal knowledge sharing to ensure team members are informed about the latest best practices.
• Implement scalable and robust data pipelines from various source systems.
• Apply business rules and transformations using SQL or Python.
• Secure data models applying object and row level security.
• Develop and document best practices and ensure they are effectively implemented across the team.
• Analyze and address issues related to data integrity, data design and both functional and technical aspects of the Cloud Data Warehouse.
• Perform cost and performance-based optimization of data transfer processes.
• Continuously monitor and improve the efficiency and performance of data pipelines.
• Bachelor’s degree and above in Computer Science, Software Engineering or similar.
• Minimum 5 years of related working experience with cloud data warehouse technologies, preferably Snowflake and/or Databricks.
• Hands-on experience in data warehouse modelling preferably with data vault 2.0 and/or star schema.
• Good understanding of agile methodologies like SCRUM.
• Problem-solving attitude and excellent communication skills.
• In-depth understanding of relational databases (SQL) and ETL (Extract, transform, load) frameworks. Experienced in data staging with SQL and Python, data visualization with tools such as PowerBI, data integration using Apache NiFi, Theobald Universal Xtract, and Azure Data Factory, as well as orchestrating data pipelines with dbt and Apache Airflow.
• Excellent organizational skills with the ability to communicate project goals and objectives, project status and deliverables with senior executives. Participate with the management team in developing a vision and strategic plan to guide the organization.
• Experience working in international teams.
• Fluent in English for communicating with global teams and stakeholders.

ams OSRAM is an Equal Employment Opportunity Employer. Diversity, equity and inclusion is strongly established in our corporate culture and we firmly believe it makes us more successful as a company. All qualified applications will receive consideration for employment regardless of ethnic, national or social origin, gender, gender identity, sexual orientation, color, religion, age, physical and mental abilities.

About ams OSRAM

The ams OSRAM Group is a global leader in innovative light and sensor solutions.

With more than 110 years of industry experience, we combine engineering excellence and global manufacturing with a passion for cutting-edge innovation enabling transformative advancements in the automotive, industrial, medical, and consumer industries.

“Sense the power of light” – our success is based on the deep understanding of the potential of light and distinct portfolio of emitter and sensor technologies. Around 19,700 employees worldwide drive innovations alongside societal megatrends.

About ams OSRAM

The ams OSRAM Group is a global leader in innovative light and sensor solutions.

With more than 110 years of industry experience, we combine engineering excellence and global manufacturing with a passion for cutting-edge innovation enabling transformative advancements in the automotive, industrial, medical, and consumer industries.

“Sense the power of light” – our success is based on the deep understanding of the potential of light and distinct portfolio of emitter and sensor technologies. Around 19,700 employees worldwide drive innovations alongside societal megatrends.