T&T Senior Analyst - Engineering - Data Engineer - SG

Deloitte SEA; Singapore; On-site; SGD 60,000 - 100,000; Full time

Job summary

Deloitte SEA is seeking a data engineer to design, build and operate data pipelines, warehouses and lakes in a modern cloud environment.

You will work with data architects, analysts and developers to deliver scalable data-driven products while ensuring data quality and governance in a collaborative, Agile setting.

Qualifications

• 2–3 years of relevant working experience as a data engineer.
• Proficient in data cleaning and transformation (SQL, pandas, R).
• Experience building ETL pipelines (SSIS, DMS, Python, AWS services).
• Proficient in databases (SQL, PostgreSQL, AWS S3, Athena, MongoDB, MySQL).
• Experience with cloud technologies (AWS, Azure, Google Cloud).
• Experience with production-grade data pipelines in a big data environment.
• Knowledge of data modelling, data access, and Data Warehouse concepts.
• Familiar with REST APIs and web scraping tools.

Responsibilities

• Design, develop and deploy data tables, views and marts in data warehouses and data lakes.
• Perform data extraction, cleaning and transformation; web scraping may be part of scope.
• Build and maintain large-scale batch and real-time data pipelines.
• Integrate data silos in scalable and compliant ways.
• Collaborate with cross-functional teams to build data-driven products.
• Develop backend APIs and work on databases to support applications.
• Embrace Agile CI/CD practices and code reviews.

Skills

Data engineering

SQL

Python

ETL pipelines

Cloud platforms

Big data tools

Web scraping

Tools

SSIS

AWS DMS

AWS Lambda

ECS

AWS Glue

Spring

BeautifulSoup

Selenium

Hadoop

Spark

Kafka

CasperJS

PhantomJS

Job description

Are you ready to unleash your potential?

At Deloitte, our purpose is to make an impact that matters for our clients, our people, and the communities we serve.

We believe we have a responsibility to be a force for good, and WorldImpact is our portfolio of initiatives focused on making a tangible impact on society’s biggest challenges and creating a better future. We strive to advise clients on how to deliver purpose-led growth and embed more equitable, inclusive as well as sustainable business practices.

Hence, we seek talented individuals driven to excel and innovate, working together to achieve our shared goals.

We are committed to creating positive work experiences that foster a culture of respect and inclusion, where diverse perspectives are celebrated, and everyone is recognised for their contributions.

Ready to unleash your potential with us? Join the winning team now!

Work you'll 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.

Your role as a leader:

• Demonstrate a strong commitment to personal learning and development.
• Understand how our daily work contributes to the priorities of the team and business.
• Understand the set expectations and demonstrate accountability in keeping personal performance on track.
• Actively focus on developing effective communications and relationship-building skills with stakeholders, clients and team.
• Demonstrate an appreciation for working with others.
• Understand what is fundamental to Deloitte's success as a business.
• Demonstrate integrity and an awareness of strengths, differences, and personal impact.
• Develop their understanding of Deloitte and offer a fresh perspective.

Requirements:

• Has 2-3 years of relevant working experience as a data engineer.
• 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 customised 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.

Due to volume of applications, we regret that only shortlisted candidates will be notified.