BI Developer/analyst

**About us**

HammondCare is a not-for-profit, values-based organisation that is passionate about improving the quality of life for people in need. As one of Australia’s most innovative health and aged care providers, we aim to set the global standard of relationship-based care for people with complex needs. HammondCare provides care primarily through hospitals, residential care homes and home-based care as well as services for dementia support, community palliative care, rehabilitation, positive aging and older persons’ mental health.

**The opportunity**

The role of **_BI Developer/Analyst (Power BI & Microsoft Fabric)_** is responsible for designing, developing, and maintaining interactive dashboards, data models, and analytics solutions that drive business insights and decision-making across HammondCare.

We are seeking a skilled and motivated **BI Developer / Analyst** with 3-5 years of hands-on experience in **Power BI** and working knowledge of **Microsoft Fabric** to join our Data & Analytics team.

**_ This is a permanent role is based in St Leonards, with hybrid working options._**

**What we can offer you**

We care about your wellbeing at HammondCare and as a result offer a wide range of health and lifestyle benefits including:

- NFP salary packaging ($15,900 tax free) plus meals and entertainment benefit (up to $2,650 tax free)
- Additional leave purchase options and 14 weeks paid parental leave
- Flexible working options, including hybrid arrangements
- Discounts on everyday products and services
- Discounted healthcare memberships - access to network of fitness centres and pools for employees and families
- Free independent, confidential counselling services, wellbeing resources and webinars available through our Employee Assistance Program (EAP) for you and your family.
- Health & Wellbeing programmes
- Reward & Recognition programmes
- Referral bonuses
- Career and professional development opportunities

**Duties include**

**_ BI Solution Development_**
- Design and develop scalable, interactive **Power BI reports and dashboards** tailored to business needs.
- Develop **semantic models**, **DAX measures**, and **Power Query (M language)** transformations for efficient data processing.
- Utilize **Microsoft Fabric capabilities** such as **Dataflows Gen2**, **Lakehouses**, **Notebooks**, and **Pipelines** to support modern data architecture.
- Build and maintain **data products** using **OneLake**, ensuring alignment with organisational data governance.

**_Data Analysis and Business Engagement_**
- Collaborate with business stakeholders to gather requirements, translate them into data models, and deliver actionable insights.
- Analyse and interpret trends, patterns, and anomalies in complex datasets to support strategic initiatives.
- Proactively identify data quality issues and work with upstream teams to resolve them.

**Performance Optimisation & Support**
- Optimise **Power BI datasets**, **measures**, and **visuals** for performance and usability.
- Maintain existing reports, dashboards, and ETL processes, ensuring availability and reliability.
- Provide ongoing support, training, and documentation to business users and team members.

**_Data Integration & Fabric Pipelines_**
- Work with various data sources including **SQL Server**, **Dataverse**, **Excel**, **SharePoint**, and **cloud services** (e.g., Azure Data Lake, Microsoft Fabric Lakehouse).
- Design and orchestrate **data pipelines** using Fabric to ingest, transform, and store data.

**Who are you?**
- Commitment to engage and align with HammondCare’s Christian Mission, Motivation and Mission in Action.
- **3-5 years of professional experience** in a Power BI Developer / Analyst role.
- Strong expertise in **Power BI Desktop, Power BI Service, DAX, Power Query (M)**.
- Experience working with **Microsoft Fabric** (Dataflows Gen2, Lakehouse, Notebooks, Pipelines, OneLake).
- Solid understanding of **data warehousing concepts** and **dimensional modeling**.
- Hands-on experience with **SQL** and relational databases (preferably **SQL Server**, **Azure SQL**).
- Strong problem-solving skills and attention to detail.
- Ability to communicate technical concepts clearly to non-technical stakeholders.

**_Preferred Qualifications_**
- Microsoft certifications such as **PL-300 (Power BI Data Analyst Associate)** or **DP-600 (Microsoft Fabric Analytics Engineer)**.
- Experience with **Power Platform (Power Apps, Power Automate)** is desirable.
- Exposure to **data governance** and **security frameworks** (e.g., row-level security, sensitivity labels).
- Experience with **Agile/Scrum methodologies** and tools like **Azure DevOps**, **JIRA**, or **Confluence**.
- Experience working within the Aged Care and Healthcare sector - desirable

**Pre
- Employment Checks**

All short-listed applicants will be asked to consent to a criminal record check and references.
- HammondCare is committed to creating an inclusive workplace that promotes