Data Engineer Consultant (Healthcare)

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

Line of Service Advisory Industry/Sector Not Applicable Specialism Technology Strategy Management Level Associate Job Description & Summary 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.

Education

Education (if blank, degree and/or field of study not specified) Degrees/Field of Study required: Degrees/Field of Study preferred: Certifications (if blank, certifications not specified) Required Skills Optional Skills Accepting Feedback, Accepting Feedback, Active Listening, Analytical Reasoning, Application Software, Business Data Analytics, Business Management, Business Technology, Business Transformation, Communication, Documentation Development, Emotional Regulation, Empathy, Implementation Research, Implementation Support, Implementing Technology, Inclusion, Intellectual Curiosity, Optimism, Performance Assessment, Performance Management Software, Problem Solving, Product Management, Product Operations, Project Delivery {+ 11 more}

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

Yes

Government Clearance Required?

Yes