Principal Data Analyst

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 (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.