Overview
Line of Service
Advisory
Industry/Sector
Not Applicable
Specialism
Technology Strategy
Management Level
Senior Associate
Job Description & Summary
We believe that challenges are best solved together. That’s why, when you join us, you become part of a diverse and global community of problem-solvers. You’ll find an unexpected mix of people who bring their unique expertise to build trust in society and tackle important issues. Here, we welcome and encourage you to lead with value and inspiration, question and challenge assumptions, as well as embrace new opportunities to deliver quality outcomes in exciting and unexpected ways, all with the support of technology.
At PwC South East Asia Consulting, we help businesses to work smarter and grow faster. We partner with our clients to build effective organisations, innovate and grow, reduce costs, manage risk and regulation and, leverage talent. Our aim is to support businesses in designing, managing and executing lasting beneficial change.
PwC’s South East Asia Consulting practice provides a comprehensive range of professional services and experience to deliver large scale, cross territory transformation projects, wherever our clients need us to be – from strategy through to execution.
Responsibilities
- 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
- Diploma / 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 with Azure Data Factory, AWS GLUE, SSIS and SSAS.
- 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 (Azure/AWS) 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 (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, Analytical Thinking, Application Software, Business Data Analytics, Business Management, Business Technology, Business Transformation, Communication, Creativity, Documentation Development, Embracing Change, Emotional Regulation, Empathy, Implementation Research, Implementation Support, Implementing Technology, Inclusion, Intellectual Curiosity, Learning Agility, Optimism, Performance Assessment, Performance Management Software {+ 16 more}
Desired Languages (If blank, desired languages not specified)
Travel Requirements
Not Specified
Available for Work Visa Sponsorship?
Yes
Government Clearance Required?
Yes
Job Posting End Date
Job ID: 620623WD
About PwC Singapore
At PwC, our purpose is to build trust in society and solve important problems - this is at the core of everything we do from the value we provide to our clients and society to the decisions we make as a corporate.
Our services started with audit and assurance over a century ago. As times change and the issues faced by businesses and individuals evolved, we have developed specialised capabilities in tax, advisory and consulting to help you address emerging new challenges across focus areas like digital transformation, cyber security and privacy, data, sustainability, mergers and acquisitions, and more.
In Singapore, we have more than 3,500 partners and staff to help resolve complex issues and identify opportunities for public, private and government organisations to progress. As part of the PwC network of more than 284,000 people in 155 countries, we are among the leading professional services networks in the world focusing on helping organisations and individuals create the value they are looking for.