People Analytics BI Analyst | Power BI & SQL

APM Communities; Perth; Hybrid; AUD 110,000 - 150,000; Full time

Benefits offered by this job

Flexible / hybrid working arrangements

Additional annual leave

Private health discounts

Job summary

APM is seeking a People Business Intelligence Analyst to join the People Analytics team. You will design, build, and maintain Power BI dashboards and semantic models, while developing scalable data structures and ETL processes to support global workforce insights.

Ideal candidates bring 5+ years in data analytics or BI, strong Power BI/DAX skills, SQL and data warehousing experience, and a knack for translating requirements into actionable insights.

Qualifications

• 5+ years of experience in data analytics or BI
• Strong Power BI capability with DAX and data modelling
• Experience with ETL, SQL, and data warehousing
• Advanced Power Query and Excel skills across large datasets
• Translate business requirements into meaningful reporting and analytics
• Strong data visualisation and stakeholder engagement skills
• Focus on data quality, validation, governance and continuous improvement

Responsibilities

• Design, build, and maintain P&C Power BI dashboards, reports, and semantic models
• Develop and optimise SQL queries, DAX measures, and Power Query transformations
• Identify data gaps and partner with Digital to create fit-for-purpose data models
• Build and maintain ETL processes and people data warehouse architecture
• Develop automated tools and processes to enhance reporting efficiency
• Support interpretation of data and reporting requirements for People & Culture and business
• Maintain data quality, governance, security, and reporting standards
• Support UAT, report validation, and ongoing enhancements

Skills

Power BI

DAX

SQL

Data modelling

ETL processes

Stakeholder engagement

Excel

Data governance

Tools

Power Query

Power Automate

SharePoint

Microsoft Lists

Job description

APM is seeking a People Business Intelligence Analyst to join the People Analytics team. You will design, build, and maintain Power BI dashboards and semantic models, while developing scalable data structures and ETL processes to support global workforce insights.

Ideal candidates bring 5+ years in data analytics or BI, strong Power BI/DAX skills, SQL and data warehousing experience, and a knack for translating requirements into actionable insights.