Data Engineer Consultant (Healthcare)

About the role

PwC Southeast Asia Consulting is looking for a Data Engineer Consultant within its advisory practice, which covers the full range of clients' digital capabilities from strategy to execution. The consultant develops ETL strategy and logic, designs data models and tests and optimises ETL, supporting healthcare clients.

Key responsibilities

• Develop ETL strategy and ETL logic
• Analyse analytics use-case requirements to determine the data mapping needed
• Develop data models from conceptual to logical and physical, or support the leader in designing them
• Drive conversations with the customer project team to obtain the outputs needed for ETL development
• Write unit test, system integration test and user acceptance test scripts
• Conduct QA on ETL results produced by other data engineers and optimise existing ETL logic
• Test and validate data from UAT, fix ETL code and run regression testing

Required profile

• Bachelor's degree in information systems, computer science, engineering or a related field, or foreign equivalent
• 3 to 5 years of development experience on Databricks and Microsoft Fabric
• Strong analytical skills, attention to detail and ability to work independently to strict deadlines
• Cloud platform and configuration experience; knowledge of TDD and test automation tools such as Selenium is advantageous
• Consulting background and experience with business and technical stakeholders desirable; team management experience considered for a Team Lead role

Required skills

• Databricks and Microsoft Fabric
• SQL, stored procedures, SSIS and T-SQL
• Python, C# and PowerShell
• Testing and test automation concepts