Data Engineer

DescriptionActivate 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 for Data Engineer You will work in Singapore Government Agencies Internal Code: A26141 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 data-driven 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. RequirementsWhat are we looking for? • 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). • 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. BenefitsWhat 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 generous customisable flexi benefits, or flexi allowance; life and health insurance, thoughtful perks like special occasions “red packet” and CNY goodies, etc. • Employee Wellness Support for your physical, mental, and overall well-being through year-round initiatives. • Growth & Development Learning programmes, 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 or a leadership track. • 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 Why you'll love working with us? If you are looking for opportunities to collaborate with leading industry experts and be surrounded 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. We believe your success is our success. Activate Interactive Singapore is an equal opportunity employer. Employment decisions will be based on merit, qualifications and abilities. Activate Interactive Pte Ltd does not discriminate in employment opportunities or practices on the basis of race, colour, religion, gender, sexuality, national origin, age, disability, marital status or 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 Pte Ltd’s recruitment 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) to know more about how we collect, use, and transfer the personal data of our candidates. Here you can find how you can request for access, correction and/or withdrawal of your Personal Data.