Senior Business Intelligence Developer

Bolton Clarke; Sydney; Hybrid; AUD 130,000 - 165,000; Full time

Benefits offered by this job

Salary packaging benefits

Private health insurance

Gym discounts

Employee assistance program

Job summary

Bolton Clarke Group is seeking a Senior Business Intelligence Developer to join the Group Information & Analytics team on a 12-month fixed-term basis. The role focuses on Power BI reporting across care, corporate and operational services, translating business needs into robust data models and clear visualisations.

The position can be based in Brisbane, Sydney or Melbourne with a hybrid pattern of generally one to two office days per week.

Qualifications

• Strong hands-on experience developing, testing, and maintaining Power BI reports and dashboards.
• Ability to design dimensional data models using star schemas.
• Advanced skills in DAX and M/Power Query with practical T-SQL experience.
• Ability to translate business requirements into accurate and maintainable reporting solutions.

Responsibilities

• Develop, test, document and maintain Power BI reports and dashboards that meet business needs and Bolton Clarke standards.
• Work with business analysts to interpret requirements and translate them into effective technical reporting solutions.
• Design mature conceptual, logical and physical data models using dimensional modelling and star schema principles.
• Build reporting logic and transformations using DAX, M/Power Query and T-SQL.
• Partner with data engineers to define upstream data warehouse, database and integration requirements.
• Create and execute test plans, validate report outcomes and provide clear handover to operational users.
• Support and coach users and self-service Power BI developers while contributing to team knowledge sharing and continuous improvement.

Skills

Power BI

DAX

M/Power Query

T-SQL

Education

Bachelor’s degree in Data Science

PL-300 Certification

Power BI Certification

Tools

Power BI

SQL Server

Azure

Job description

Bolton Clarke Group one of Australia’s largest independent, not-for-profit providers of home care, retirement living and residential aged care, operating nationally and internationally.Bolton Clarke Residential group now has 87 Aged Care Homes across QLD, NSW, VIC, SA & WA, with the inclusion of the Allity, McKenzie & Acacia Living Group.

About the position

As a Senior Business Intelligence Developer, you will join Bolton Clarke’s Group Information & Analytics team on a 12-month fixed-term basis to develop high-quality Power BI reporting solutions that support decision-making across our care, corporate and operational services. Working alongside business analysts, data engineers and stakeholders, you will translate business requirements into robust data models, reporting logic and clear, meaningful visualisations. The role can be based in Brisbane, Sydney or Melbourne, with a hybrid working model of generally one to two days per week in the office.

This is a hands-on technical role focused primarily on Power BI report development across the full solution lifecycle, including:

• Power BI report development, data visualisation and testing
• Dimensional data modelling, including star schema design
• DAX, M/Power Query and T-SQL development
• Technical interpretation of business and reporting requirements
• Collaboration with business analysts, data engineers and operational stakeholders
• Documentation, operational handover and support for self-service Power BI users

Key Activities:

• Develop, test, document and maintain Power BI reports and dashboards that meet business needs and Bolton Clarke standards
• Work with business analysts to interpret requirements and translate them into effective technical reporting solutions
• Design mature conceptual, logical and physical data models using dimensional modelling and star schema principles
• Build reporting logic and transformations using DAX, M/Power Query and T-SQL
• Partner with data engineers to define upstream data warehouse, database and integration requirements
• Create and execute test plans, validate report outcomes and provide clear handover to operational users
• Support and coach users and self-service Power BI developers while contributing to team knowledge sharing and continuous improvement

Skills and experience:

• Strong hands-on experience developing, testing, documenting and maintaining Power BI reports and dashboards
• Demonstrated capability in dimensional data modelling, star schemas and relational database principles
• Advanced skills in DAX and M/Power Query, with practical T-SQL experience
• Ability to translate business requirements into accurate, intuitive and maintainable reporting solutions
• Strong analytical, conceptual and problem-solving skills with a focus on quality and best practice
• Effective communication and stakeholder engagement skills, with the ability to work collaboratively across technical and operational teams
• Health or aged care sector experience will be well regarded but is not essential

Qualifications:

• Bachelor’s degree in Data Science, Computer Science, Information Systems or a related field, or equivalent professional experience
• Current PL-300 Microsoft Power BI Data Analyst certification
• Relevant industry certification in Power BI data modelling, DAX or M/Power Query is highly regarded

Why Work For Bolton Clarke:

Excellent work/life balance with shifts that suit your personal needs

• A caring team environment with strong clinical and allied health support
• Career progression and development opportunities
• Generous salary packaging and not-for-profit tax benefits – claim up to $18,550 tax free
• Private health insurance and gym discounts
• An Employee Assistance Program for staff and family

Our commitment to diversity: At Bolton Clarke we expect our staff to respect and value differences in age, disability, race, nationality, ethnicity, sexual orientation, gender identity, intersex status and family or marital status.

Appointment to this position and ongoing employment is subject to your commitment to supporting diversity and inclusion.