Data Engineer Consultant - ETL, Databricks & Modeling

PwC South Africa; Singapore; On-site; Confidential; Full time

Job summary

PwC Southeast Asia Consulting is seeking an Associate to develop ETL strategies and logic, design data models, and drive data mapping with client teams. You will build unit and integration tests, QA ETL outputs, and optimize ETL code while ensuring timely delivery of analytics solutions.

The role requires strong SQL skills, Databricks and Microsoft Fabric experience, and programming in Python, C#, and PowerShell.

Qualifications

• Bachelor’s degree in information systems, computer science, engineering or foreign equivalent.
• Strong SQL and data engineering experience.
• Experience with Databricks and Microsoft Fabric.
• Programming experience with Python, C#, PowerShell; knowledge of testing tools like Selenium.

Responsibilities

• Develop ETL strategy and ETL logic.
• Develop data models from conceptual to physical to support data architecture.
• Lead data mapping discussions with client project teams to define outputs.
• Create unit, system integration, and user acceptance test scripts and perform QA on ETL results.
• Optimize ETL logic and fix code; perform regression testing.

Skills

SQL

Analytical reasoning

Attention to detail

Independence

Team leadership potential

Education

Bachelor's degree in Information Systems

Bachelor's degree in Computer Science

Engineering

Tools

Databricks

Microsoft Fabric

SSIS

T-SQL

Python

C#

PowerShell

Selenium

Job description

PwC Southeast Asia Consulting is seeking an Associate to develop ETL strategies and logic, design data models, and drive data mapping with client teams. You will build unit and integration tests, QA ETL outputs, and optimize ETL code while ensuring timely delivery of analytics solutions.

The role requires strong SQL skills, Databricks and Microsoft Fabric experience, and programming in Python, C#, and PowerShell.