Principal Data Analyst:6 months initial contract with possible extensionBased in Perth CBD, hybrid work cultureSkills: Power BI, SQL, ETL, Data migrationWe 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 ApplyIf 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.#J-18808-Ljbffr
