Data Analyst

Strato Solutions Sdn Bhd; Petaling Jaya; On-site; MYR 90,000 - 130,000; Full time

Job summary

Strato Solutions Sdn Bhd in Malaysia is seeking a Data Engineer to design and build scalable data pipelines that ingest data from APIs, databases and files. You will cleanse, transform and enrich data using ETL/ELT processes and design data models for data warehouses and analytical platforms.

You will collaborate with analytics, data science and backend teams to ensure data quality, governance and efficient storage solutions across data lakes and warehouses.

Qualifications

• 2-5 years of experience in data engineering or related roles.
• Experience building end-to-end data pipelines using ETL/ELT tools and programming languages.
• Hands-on experience with SQL and relational & NoSQL databases.
• Experience with cloud platforms (AWS, Azure or GCP).
• Experience with big data, data warehouse or data lake solutions.
• Experience with orchestration tools and workflow scheduling.
• Bachelor's degree in Computer Science, Information Technology, Data Science, Engineering or related field.
• Strong foundation in data structures, algorithms and programming.
• Good understanding of databases, SQL and data warehousing concepts.
• Knowledge of data engineering principles, architectures and best practices.

Responsibilities

• Design and build scalable pipelines to ingest data from multiple sources (APIs, databases, files, streaming, logs, etc.).
• Cleanse, transform and enrich data using ETL/ELT processes to ensure accuracy, consistency and business readiness.
• Design efficient data models and schemas for data warehouses, data lakes and analytical platforms.
• Design, implement and optimize storage solutions including data lakes, warehouse and databases.
• Implement validation, quality checks, metadata management and data governance best practices.
• Schedule, monitor and automate data workflows using orchestration tools for reliability and performance.
• Tune pipelines, queries and data architectures for performance, scalability and cost-efficiency.
• Implement logging, monitoring, alerting and recovery strategies to ensure data reliability.
• Work closely with data analytics, data scientists, backend developers and business stakeholders.

Skills

ETL/ELT pipelines

SQL databases

NoSQL databases

Relational databases

Cloud platforms

Big data

Data modeling

Orchestration tools

Data governance

Programming languages

Education

Bachelor's degree in Computer Science/IT/Data Science/Engineering

Job description

Location: Sunway Nexis, Kota Damansara
Contract Duration: 12 Months (Renewable)
Notice period: Immediately or within short notice
About the role

You will design and build scalable pipelines to ingest data from multiple sources, cleanse and transform data using ETL/ELT processes, and design efficient data models for data warehouses and analytical platforms.

Key responsibilities

Design and build scalable pipelines to ingest data from multiple sources (APIs, databases, files, streaming, logs, etc.)

Cleanse, transform and enrich data using ETL/ELT processes to ensure accuracy, consistency and business readiness

Design efficient data models and schemas for data warehouses, data lakes and analytical platforms

Design, implement and optimize storage solutions including data lakes, warehouse and databases

Implement validation, quality checks, metadata management and data governance best practices

Schedule, monitor and automate data workflows using orchestration tools for reliability and performance

Tune pipelines, queries and data architectures for performance, scalability and cost-efficiency

Implement logging, monitoring, alerting and recovery strategies to ensure data reliability

Work closely with data analytics, data scientists, backend developers and business stakeholders

About you

Minimum 2-5 years of experience in data engineering or related roles

Experience building end-to-end data pipelines using ETL/ELT tools and programming languages

Hands-on experience with SQL and relational & NoSQL databases

Experience with cloud platforms (AWS, Azure or GCP)

Experience with big data, data warehouse or data lake solutions

Experience with orchestration tools and workflow scheduling

Bachelor's degree in Computer Science, Information Technology, Data Science, Engineering or related field

Strong foundation in data structure, algorithms and programming

Good understanding of databases, SQL and data warehousing concepts

Knowledge of data engineering principles, architectures and best practices

Unlock job insights

Hirer responsiveness Salary match Number of applicants

Your application will include the following questions:

• Which of the following statements best describes your right to work in Malaysia?
• Which of the following types of qualifications do you have?
• How many years' experience do you have as a data analyst?
• How many years' experience do you have using SQL queries?
• Which of the following programming languages are you experienced in?
• Have you worked in a role which requires a sound understanding of business intelligence (BI) best practices?

Strato Solutions Sdn Bhd is an MSC status Malaysian technology and business consulting with satellite offices in Jakarta and London.

As Industry 4.0 and Digital Economy enablers, our team consists of professional, highly specialized engineers and IT professionals who use the most advanced technologies to provide meaningful solutions to our clients.

Our business is to connect you to the people, technology and solutions that you need, moving forward. We focus on the verdant field of Oil and Gas, Energy, Utilities, Telecommunications and Public Sector.

Since its inception in 2013, Strato Solutions has successfully delivered works to its client in excess of RM230Mill in contract value. Strato Solutions has recorded strong and comprehensive performance track record with client profiles in both the Government and private sectors in Malaysia including major organizations such as TNB, PETRONAS, EPF, SIRIM, SAPURA OMV, JMG, MINDEF and others.

Our Core Business:

1.Business Consulting

3.Technical Recruitment & Augmentation

4.System Integration (SI) Services

5.Learning, Training and Development

Strato Solutions Sdn Bhd is an MSC status Malaysian technology and business consulting with satellite offices in Jakarta and London.

As Industry 4.0 and Digital Economy enablers, our team consists of professional, highly specialized engineers and IT professionals who use the most advanced technologies to provide meaningful solutions to our clients.

Our business is to connect you to the people, technology and solutions that you need, moving forward. We focus on the verdant field of Oil and Gas, Energy, Utilities, Telecommunications and Public Sector.

Since its inception in 2013, Strato Solutions has successfully delivered works to its client in excess of RM230Mill in contract value. Strato Solutions has recorded strong and comprehensive performance track record with client profiles in both the Government and private sectors in Malaysia including major organizations such as TNB, PETRONAS, EPF, SIRIM, SAPURA OMV, JMG, MINDEF and others.