Assistant Manager, Data Engineer

Sime Darby Property; Selangor; On-site; MYR 120,000 - 190,000; Full time

Job summary

Sime Darby Property is seeking a data analytics professional to support analytics and digital transformation initiatives in Malaysia. The role emphasizes Snowflake-based data warehousing, ELT/ETL pipelines, and scalable data structures to feed BI dashboards and analytics across the business.

You will design, develop, and maintain Snowflake environments, implement Talend Studio pipelines, collaborate with BI teams, ensure data quality, and support governance and security across the data platform.

Qualifications

• Bachelor's or Master's degree in IT, Information Systems, CS, Statistics or equivalent.
• Snowflake certifications (e.g. SnowPro Core/Advanced) desirable.
• Proficient in relational databases and OLAP concepts.
• Microsoft Azure or cloud-related certifications preferred.
• Experience with ETL/ELT and data warehousing concepts.

Responsibilities

• Assist in delivering analytics solutions including Snowflake Data Warehouse and BI dashboards.
• Design, develop, and maintain Snowflake data models, secure views, stages, and data sharing mechanisms.
• Develop ELT/ETL jobs using Talend Studio ensuring data quality and performance.
• Identify and resolve technical problems related to Talend, data pipelines, and Snowflake performance.
• Establish SOPs for Snowflake, Talend, data engineering, security and governance.
• Collaborate with business users to translate intelligence needs into Snowflake-based analytics.

Skills

Data warehousing concepts

ETL/ELT development

Governance & security

BI/dashboarding

Data integration

Analytical storytelling

Education

Bachelor's degree in IT/CS/IS

Master's degree in IT/CS/IS

Snowflake Certifications

Microsoft Azure certifications

ETL/Data Warehousing certifications

Tools

Snowflake

Talend Studio

Azure Databricks

Azure Data Factory

Azure Synapse

Qlik

Job description

• Assist the Team Lead (Analytics) to ensure Analytics and Digital Transformation solutions are delivered in a timely and reliable manner, leveraging modern cloud-based SaaS data platforms such as Snowflake and enterprise-grade data integration tools.

Data Warehousing & Data Integration

• Execute tasks to analyse business requirements, conduct research, and implement enterprise data warehouse solutions using Snowflake as the core SaaS data platform.
• Design, test, and develop scalable data warehouse data structures and ELT/ETL pipelines to ingest data from various source systems into Snowflake and downstream semantic / analytics models.
• Develop and maintain data transformation pipelines using Talend / Talend Studio, Python and other related tools, integrated with Snowflake and other cloud platforms.
• Provide support to project team members and external vendors by offering subject matter expertise in Snowflake-based data warehousing and Talend-driven data integration and transformation.
• Maintain and support existing and future Data Warehouse solutions, including Snowflake environments (schemas, roles, virtual warehouses, and cost-efficient usage).
• Assist in the evaluation of new data, analytics, and integration solutions where applicable.
• Assist in understanding the datasets to be consumed by dashboards, including data structure, granularity, business definitions, and suitability for analytical and reporting use.
• Work closely with BI teams to ensure datasets prepared in Snowflake meet dashboard consumption and performance requirements.

Job Responsibilities

Data Warehouse & Analytics

• Participate in the full development lifecycle including system design, development, testing, and production implementation of analytics solutions (System Integration, Snowflake Data Warehouse, BI Dashboards).
• Assist in the design, development, and maintenance of Snowflake data models, secure views, stages, and data sharing mechanisms.
• Design and develop ELT/ETL jobs using Talend Studio, ensuring data quality, reliability, and performance.
• Identify, research, and resolve easy to medium technical problems related to Talend jobs, data pipelines, Snowflake performance, and analytics consumption.
• Assist in establishing standard operating procedures, policies, and best practices covering Snowflake, Talend, data engineering, security, and governance.
• Work closely with business users to identify departmental intelligence needs and translate them into Snowflake-based analytical data solutions.

Competencies – Governance, Risk & Integrity

• Understand the Group and BU/OU governance structure and processes.
• Understand applicable laws, rules, regulations, and internal policies (COBC, GPA, and related procedures).
• Apply basic risk management principles within the area of operations.
• Maintain compliance, guide others where required and raise concerns appropriately.
• Enterprise Data Warehouse & SaaS Data Platform: Snowflake
• Data Integration & Transformation Tools:
• Talend Studio

Professional Experience

• Experience with Data Warehousing concepts.
• Experience with developing ETL solutions using Azure Databricks / Azure Data Factory / Azure Synapse.
• Experience with Data Warehouse modelling.
• Experience with Qlik dashboarding / ETL is an additional advantage.
• Interest / exposure to the property industry.

Education/Professional Qualifications

• Bachelor's or Master's degree in IT, Information Systems, Computer Science, Statistics, Business Information Technology, or equivalent work experience
• Professional qualification in Information Systems Engineering, Data Engineering, Business Intelligence and/or Data Warehousing is desirable.
• Proficient / experienced in relational database and OLAP concepts.
• Snowflake Certifications (e.g. SnowPro Core / Advanced).
• Microsoft Data Engineering certifications.
• ETL / Data Warehousing related certifications.
• Other relevant Microsoft Azure or cloud-related certifications.