Data Engineer (Healthcare)

PRICEWATERHOUSECOOPERS CONSULTING (SINGAPORE) PTE. LTD.; Singapore; On-site; SGD 85,000 - 130,000; Full time

Benefits offered by this job

Data-driven projects

Job summary

PwC Singapore Consulting is seeking an experienced ETL Developer to shape data integration and analytics solutions. You will develop ETL strategies, map analytics requirements to data models, and collaborate with client teams to deliver robust data pipelines.

The role emphasizes hands-on Databricks and SQL expertise, along with exposure to cloud environments and dashboard design. A strong consulting background and stakeholder interaction are a plus.

Qualifications

• Bachelor’s degree or foreign equivalent in information systems, CS, engineering or related field.
• 3–5 years of development experience on Databricks and Microsoft Fabric.
• Strong command of SQL and ability to write Stored Procedures, SSIS, T-SQL from scratch.
• Analytical mindset with strong attention to detail.
• Ability to work independently and meet tight timelines without continuous supervision.
• Knowledge of testing concepts and test automation tools such as Selenium is advantageous.
• Experience using cloud platforms and configuration.
• Experience in Python, C#, PowerShell.
• Nice to have data visualization/dashboard design experience.
• Past consulting background and stakeholder collaboration experience desirable.
• Team leadership experience considered for Team Lead role.

Responsibilities

• Develop ETL strategy and ETL logic.
• Analyse analytics use-case requirements to determine data mapping.
• Develop data models from conceptual to physical with the data team.
• Lead discussions with customer project teams to define ETL outputs.
• Create unit test scripts, system integration test scripts, and UAT scripts.
• QA ETL outputs produced by others in the team.
• Optimize ETL logic that has been developed.
• Test and validate data from UAT, perform ETL code fixes and regression testing.

Skills

Databricks

SQL

Python

C#

PowerShell

T-SQL

Selenium

Cloud platforms

Data visualization

Education

Bachelor’s degree in information systems, CS, engineering or related field

Tools

Databricks

Microsoft Fabric

SSIS

T-SQL

Stored Procedures

Job description

At PwC, we help clients build trust and reinvent so they can turn complexity into competitive advantage. We’re a tech-forward, people-empowered network with more than 370,000 people in 149 countries. Across audit and assurance, tax and legal, deals and consulting we help clients build, accelerate and sustain momentum. Find out more at www.pwc.com.

About The Team

PwC Southeast Asia Consulting's vision is to create meaningful relationships with our clients by powering the next generation digital enterprise.

Our practice spans the whole range of clients’ digital capabilities, ranging from strategy to execution. We help solve complex boardroom problems, and work with the team to not only solve problems of today but get them ready for new opportunities for tomorrow, creating the pathway of how technology can enable business visions.

About the Role

• Develop ETL strategy and ETL logic.

• Conduct analysing work on requirements of analytics use case to determine the data mapping required.
• Develop data model from conceptual to logical and physical or to support the leader to design the data model.
• Drive conversation with customer project team members to get the output required for us to develop the ETL.
• Develop unit test scripts, system integration test scripts, user acceptance test scripts.
• Conduct QA on ETL result done by other data engineers in the team.
• Conduct optimization of ETL logic that had been developed.
• Responsible for testing and validating data from UAT
• Responsible to do fix on the ETL code and regression testing.

About You

• Bachelor’s degree in information systems, Computer Science, Engineering, or a related field or foreign equivalent from a recognized university.
• Databricks
• At least 3 to 5 years of development experience on Databricks, Microsoft Fabric
• Must possess a strong command of SQL and be able to write Stored Procedures, SSIS, T-SQL from scratch
• Must have strong analytical skills and have strong attention to detail.
• Be able to work independently and ensure strict timelines are met without continuous technical supervision
• Knowledge of TDD and various concepts of testing and test automation tools e.g., Selenium is advantageous.
• Experience in using cloud platform and configuration
• Experience in programming with Python, C#, PowerShell
• Good to have experience in designing and building data visualization dashboards.
• Past consulting background and experience in working with business and technical stakeholders will be desirable
• Candidates with team management experience will be considered for Team Lead role