Principal Data Analyst

Location: Perth CBD
Job Type: Contract
Posted: about 1 month ago
Contact: Maria Hecto
Discipline:
Reference: 262736

Principal Data Analyst:

  • 6 months initial contract with possible extension
  • Based in Perth CBD, hybrid work culture
  • Skills: Power BI, SQL, ETL, Data migration

We are seeking a highly skilled Principal Data Analyst to join our client's Data Migration team for the HRMIS program. The successful candidate will play a critical role in maintaining the HRMIS Datamart, ensuring data integrity, and developing robust data solutions.

Responsibilities:

Data Manipulation and Definition:

  • Write and optimize complex SQL queries using Microsoft and Oracle databases.
  • Perform data manipulation language (DML) and data definition language (DDL) operations to support data migration and maintenance tasks.

Data Warehouse and ETL:

  • Utilize strong knowledge of data warehousing concepts and Extract Transform Load (ETL) processes.
  • Develop and maintain data models to support the HRMIS Datamart.

Power BI Development and Management:

  • Develop, manage, and deploy dataflows, semantic models, and reports in Power BI.
  • Write and optimize DAX code for complex calculations and data analysis.
  • Manage Power BI workspaces, including roles and user access.
  • Implement and manage deployment pipelines for Power BI reports and datasets.

Power Apps Development:

  • Develop, test, and manage app solutions using Power Apps to support the HRMIS program.

Data Quality and Integrity:

  • Ensure data accuracy, consistency, and reliability throughout the data migration process.
  • Identify and resolve data quality issues in collaboration with the data migration team.

Stakeholder Collaboration:

  • Work closely with cross-functional teams, including HR, IT, and business analysts, to understand data requirements and deliver solutions.
  • Provide expertise and support to team members on SQL, data warehousing, and Power BI.

Required Skills and Qualifications:

  • Strong proficiency in SQL with experience in Microsoft and Oracle databases.
  • Deep understanding of data warehousing concepts, ETL processes, and data modelling.
  • Managing Power BI workspaces and user access.
  • Implementing deployment pipelines for Power BI reports.
  • Experience with large-scale data migration projects.
  • Excellent problem-solving skills and attention to detail.
  • Strong communication and collaboration skills to work effectively with stakeholders.

How to Apply

If you are interested and possess the right experience, please apply now via the link below.

Contact: Maria Hecto - (08) 9423 1407 - (Job reference: 262736)

Diversity and inclusion are strongly supported at Peoplebank. People of all nationalities, gender identities, and cultural backgrounds, including Aboriginal and Torres Strait Islander Peoples, are encouraged to apply.