Assistant Manager, Data Engineer

• 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.