Data Engineer - A27006

Activate Interactive Pte Ltd.; Singapore; On-site; SGD 72,000 - 108,000; Full time

Job summary

Activate Interactive Pte Ltd is hiring for a data engineering role to design, develop and deploy data tables, views and marts in data warehouses and data lakes. You will extract, clean and transform data, including web scraping, and build scalable batch and real-time pipelines on cloud platforms.

The role collaborates with Project Managers, Data Architects, Business Analysts and developers in an Agile environment.

Qualifications

• Experience in designing and implementing data warehouses, data lakes and data marts.
• Proficient in data extraction, cleaning, transformation and web scraping.
• Experience building large-scale batch and real-time data pipelines on cloud platforms.

Responsibilities

• Design, develop and deploy data tables, views and marts in data warehouses and data lakes.
• Build and maintain ETL/ELT pipelines using SQL, Python and cloud services.
• Develop backend APIs and integrate with databases to support applications.

Skills

Database design

Cloud platforms

ETL pipelines

Python

SQL

Web scraping

Data governance

REST APIs

Tools

SSIS

AWS DMS

Python

AWS Lambda

ECS

AWS Glue

Spring

Job description

Activate Interactive Pte Ltd (“Activate”) is a leading technology consultancy headquartered in Singapore with a presence in Malaysia and Indonesia. Our clients are empowered with quality, cost-effective, and impactful end-to-end application development, like mobile and web applications, and cloud technology that remove technology roadblocks and increase their business efficiency.

We believe in positively impacting the lives of people around us and the environment we live in through the use of technology. Hence, we are committed to providing a conducive environment for all employees to realise their full potential, who in turn have the opportunity to continuously drive innovation.

We are searching for our next team members to join our growing team.

If you love the idea of being part of a growing company with exciting prospects in mobile and web technologies that create positive impact on people’s lives, then we would love to hear from you.

Co-Development Business Unit is hiring

You will work in Singapore Government Agencies

Internal Code: A27006

This is a fixed term contract role. The engagement is 1 year.

What will you do?

• Design, develop and deploy data tables, views and marts in data warehouses, operational data store, data lake and data virtualization.
• Perform data extraction, cleaning, transformation, and flow. Web scraping may be also a part of the work scope in data extraction.
• Design, build, launch and maintain efficient and reliable large-scale batch and real-time data pipelines with data processing frameworks.
• Integrate and collate data silos in a manner which is both scalable and compliant.
• Collaborate with Project Manager, Data Architect, Business Analysts, Frontend Developers, Designers and Data Analyst to build scalable datadriven products.
• Be responsible for developing backend APIs & working on databases to support the applications.
• Work in an Agile Environment that practices Continuous Integration and Delivery.
• Work closely with fellow developers through pair programming and code review process.
• Proficient in general data cleaning and transformation (e.g. SQL, pandas, R, etc) to ensure data accuracy and consistency.
• Proficient in building ETL pipeline (eg. SQL Server Integration Services (SSIS), AWS Database Migration Services (DMS), Python, AWS Lambda,
• ECS Container task, Eventbridge, AWS Glue, Spring).

What are we looking for?

• Proficient in database design and various databases (e.g. SQL, PostgreSQL, AWS S3, Athena, mongodb, postgres/gis, mysql, sqlite, voltdb, cassandra, etc).
• Experience in cloud technologies such as GPC, GCC (i.e. AWS, Azure, Google Cloud).
• Experience and passion for data engineering in a big data environment using Cloud platforms such as GPC, GCC (i.e. AWS, Azure, Google Cloud).
• Experience with building production-grade data pipelines, ETL/ELT data integration.
• Knowledge about system design, data structure and algorithms.
• Familiar with data modelling, data access, and data storage infrastructure like Data Mart, Data Lake, Data Virtualisation and Data Warehouse for efficient storage and retrieval.
• Familiar with rest api and web requests/protocols in general.
• Familiar with big data frameworks and tools (eg. Hadoop, Spark, Kafka,RabbitMQ).
• Familiar with W3C Document Object Model and customized web scraping (e.g. BeautifulSoup, CasperJS, PhantomJS, Selenium, Nodejs, etc).
• Familiar with data governance policies, access control and security best practices.
• Comfortable in at least one scripting language (eg. SQL,Python).
• Comfortable in both windows and linux development environments.
• Interest in being the bridge between engineering and analytics.

What do we offer in return?

Competitive Compensation:Market competitive salary and variable performance bonus aligned to your skills, impact, and contribution.

Benefits:Outpatient medical, specialist medical coverage and generouscustomisableflexi benefits, or flexi allowance; life and health insurance, thoughtfulperkslike special occasions “red packet” and CNY goodies, etc.

Employee Wellness:Support foryour physical, mental, and overall well-being through year-round initiatives.

Growth & Development:Learningprogrammes, certification support, and a dedicated staff development budget. (We are a “SHRI 2025 Gold winner” in “Learning & Development; Coaching & Mentoring”)

Career Progression:Structured career pathways that enable you to grow along a technical/domain expert track ora leadershiptrack.

Competency Framework:A structured and practical framework to support you to develop, perform, and succeed.

Flexible Work Arrangement:Staff may choose to work flexi-place,flexi-time, and flexi-load based on existing framework

Whyyou'lllove working with us?

If you are looking for opportunities to collaborate with leading industry experts andbesurrounded by highly motivated and talented peers, we welcome you to join us. We provide all employees with equal opportunities to grow and develop with us. Webelieveyour success is our success.

Activate Interactive Singapore is an equal opportunity employer. Employment decisions will be based on merit,qualificationsand abilities. Activate Interactive Pte Ltd does not discriminate in employment opportunities or practiceson the basis ofrace,colour, religion,gender, sexuality, national origin, age, disability, maritalstatusor any other characteristics protected by law.

Protecting your privacy and the security of your data are longstanding top priorities for Activate Interactive Pte Ltd.

Your personal data will be processed for the purposes of managing Activate Interactive PteLtd’srecruitment related activities, which include setting up and conducting interviews and tests for applicants, evaluating and assessing the results, and as is otherwise needed in the recruitment and hiring processes.

Please consult our Privacy Notice (https://www.activate.sg/privacy-policy) toknowmore about how we collect, use, and transfer the personal data of our candidates. Here you can find how you canrequest foraccess,correctionand/or withdrawal of your Personal Data.