Data Analytics Associate: SQL, Power BI & ETL Focus
Posted Updated
Description
PwC Singapore is seeking a Business Analyst to support data-driven decision making by building reliable data models, ensuring data quality, and delivering analytics through dashboards and automated workflows. The role collaborates with Business and IT teams to model data in the core SQL database, maintain the data dictionary, and connect to source databases.
You will develop BI dashboards with PowerBI and perform ETL using Python, SQL, or R, contributing to accurate management reporting and
Model and maintain objects in the organisation’s core SQL database to support reliable reporting and analytics Maintain the data dictionary Document, monitor, and troubleshoot data connections between source systems and the core SQL database Develop and maintain exception reports to identify, investigate, and resolve data quality issues in the database and source systems Automate information retrieval from external sources to reduce manual effort and improve system reliability Develop business intelligence dashboards using PowerBI Perform ETL using Python or SQL Bachelor's degree in computer science, data science, or a related field. 1-2 years of experience with SQL and Python. Experience with data modelling and data dictionary management. Experience with ETL tools such as Python, SQL or R. Experience with business intelligence tools such as PowerBI. Strong analytical and problem-solving skills. Excellent written and verbal communication skills.Skills
Sign in to read and join the discussion.