Associate I, Data Engineer

Air Selangor; Kuala Lumpur; On-site; MYR 70,000 - 90,000; Full time

Job summary

A leading utility company in Kuala Lumpur is seeking a Data Engineer to assist in developing data architectures and optimizing data flows. The ideal candidate should have experience in SQL, Azure technologies, and data modeling, with strong analytical skills and a degree in Data Science or related fields. This role includes collaboration with cross-functional teams to drive business efficiency and performance.

Qualifications

• 2 - 4 years of working experience in database architecting and modeling.
• Preferably attended Big Data Analytics short-term courses or obtained certification.
• Knowledge of database architecture, data modeling, and ETL methodologies.

Responsibilities

• Assist in the development of data and data pipeline architecture.
• Construct, test, and maintain data architectures.
• Collaborate with different units to support data collection and integration.

Skills

SQL

Azure Cloud Environment

Data Warehouse modeling

Power BI

Machine Learning

Education

Degree in Mathematics / Computer Science / Data Science

Tools

Hadoop

Python

SAS

Tableau

Job description

JOB SUMMARY

Assist in the development of data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. To work on optimal data delivery architecture that is consistent throughout ongoing projects for the organization.

ROLES & RESPONSIBILITIES

• Construct, test and maintain architectures such as databases and large-scale processing systems of data.

• Build processes supporting data transformation, data structures, metadata, dependency and workload management using SQL and Azure ‘Big Data’ technologies.

• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.

• Create and maintain optimal data pipeline architecture and analytics infrastructure that enables almost every other function within the data scopes.

• Identify, design, and implement internal process improvements such as automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability etc.

• Build data lake and data tools for analytics and data science team members that assist them in building and optimizing our solution into an innovative industry leader.

• Work with stakeholders to identify the business requirements and the expected outcome especially on improving efficiency, productivity and monetization using various data science methodology.

• Work with vendors/consultants on various analytics projects and apply the best practice for internal usage.

• Collaborate with different units in the Data Analytics Centre and other departments to support data collection, integration and retention requirements.

PERSON SPECIFICATION

• Degree in the area of Mathematics / Computer Science / Data Science.

• 2 - 4 years working experience of relevant database architecting, preparation, design and modelling.

• Preferably to have attended Big Data Analytics short-term courses or have obtained certification in Data Science.

• Knowledge of various technological decision making for the business's future data, analysis, and reporting needs.

• Advanced working SQL knowledge and experience working with relational databases.

• Data Warehouse modelling (star schema, data vault).

• Experience in Power BI, SSAS and DAX languages.

• Knowledge in Azure Cloud Environment (setup and configuration), Azure Data Factory and DevOps will be added advantage.

• Knowledge of database architecture, data modeling, data warehousing, ETL methodologies and computer engineering.

• Experience with SQL/Phyton/SAS/Tableau/R/SPSS/Adobe or other Machine Learning programming languages.

• Experience with Hadoop/Hybrid/Cloud and other data storage tools.

• Involved in the development of data marts, data lakes and databases.

• Proficient in Machine Learning and Artificial Intelligence.