Senior Data Analyst - Power BI & Data Quality
Posted Updated
Description
NSW Treasury is seeking a Senior Data Analyst to design, develop and maintain Power BI dashboards for performance management across Treasury. You will analyze complex data from multiple systems, establish data quality, and support self-service analytics through documentation and training.
You will collaborate with business units to translate needs into analytics products, define data requirements, and ensure a single source of truth through robust data contracts and governance.
Lead data discovery and profiling across complex internal and external datasets to understand their structure, content, quality, lineage, relationships, constraints, sensitivity and fitness for purpose. Work with business and technical stakeholders to identify required data, clarify its business meaning, define the intended use and translate business outcomes into detailed data requirements and agreed data contracts. Develop and maintain source-to-target mappings, data dictionaries, field definitions, data contracts, transformation rules, join logic, filtering rules, matching logic and other implementation-ready data specifications. Analyse data using SQL and relevant analytics tools to identify duplicates, outliers, nulls, invalid values, inconsistent formats, referential issues and other data quality concerns. Define practical options for cleansing, standardising, transforming, matching, de-duplicating and reconciling data, including exception handling, rejected records, historical data, initial loads, incremental loads and refresh processes. Collaborate with data engineers and developers to translate approved mappings, data contracts and business rules into implementable ingestion, integration, migration and transformation logic, while maintaining clear end-to-end traceability. Support the design and delivery of data pipelines, bulk ingestion processes, system integrations, migrations and data refreshes across cloud and on-premises environments by clarifying requirements, resolving data questions and reviewing technical outcomes. Develop or prepare reusable datasets, SQL queries, analytical code, scripts, notebooks and supporting artefacts that enable profiling, transformation, reconciliation, testing and controlled implementation. Validate source and target data against approved mappings and data contracts, reconcile counts and key measures, investigate failed or incomplete loads, and support resolution of defects, exceptions and production data issues. Work with testers and business representatives to develop test scenarios, expected results and traceability from approved data requirements and mapping rules. Produce clear analysis, dashboards, reports, visualisations and written advice for both technical and non-technical audiences where required by the program or project. Identify and communicate data risks, assumptions, dependencies, limitations and gaps early, and provide evidence-based options and recommendations to delivery teams and senior stakeholders. Apply relevant data governance, privacy, security, records management and information handling requirements throughout analytical and delivery activities. Contribute to continuous improvement of data standards, documentation, reusable methods, quality controls and ways of working across data and digital delivery teams. Experience designing ETL/ELT processes for data movement and transformation. Experience exploring and analysing structured and non-structured data for ingestion into data transformation processes. Azure Cloud technology experience working with Engineering, Storage and Analytics services. Working with multi-disciplinary teams using an Agile methodology. Experience working with Infrastructure as Code delivery (Terraform). Experience working with Data Lakes. Flexible work Flex time Learning opportunities Wellbeing programs Parental leaveSkills
Sign in to read and join the discussion.