Business Intelligence Developer

Lockton; Sydney; Hybrid; AUD 90,000 - 130,000; Full time

Benefits offered by this job

Agile work environment

Mentoring program

Private health insurance

Wellness days

Job summary

Lockton Australia is seeking a Business Intelligence Developer to deliver high-quality BI solutions across the organisation from our Sydney office. You will partner with stakeholders to translate reporting needs into Power BI reports, semantic models using star schema, and scalable datasets.

The role requires SQL, data modelling, and strong communication to drive data-driven decision making. Join an agile/hybrid environment with mentoring, health insurance benefits, and flexible work

Qualifications

• Bachelor’s degree in computer science, IT, data science, or related field.
• 2–4 years' experience in BI, data analytics or Power BI development.
• Strong Power BI skills: semantic modelling, DAX, Power Query, data transformation, RLS, deployment pipelines.
• Understanding of star schema design, facts, dimensions, and data modelling best practices.
• Experience using SQL to analyse, validate, and reconcile data from multiple sources.
• Proven ability to gather requirements, engage stakeholders, and translate business needs into analytics solutions.
• Experience modernising Excel-based reporting into scalable Power BI solutions; exposure to Azure and Databricks is desirable.
• Strong communication and stakeholder management skills; ability to explain technical concepts to non-technical audiences.
• Certifications such as Microsoft Certified: Power BI Data Analyst Associate are advantageous.

Responsibilities

• Partner with business stakeholders to understand reporting requirements and translate needs into analytics.
• Design, develop, and maintain Power BI reports, dashboards, semantic models, and metrics.
• Design and maintain semantic models using star schema with facts and dimensions.
• Analyse data from multiple sources to identify trends and insights for decision-making.
• Transform Excel-based reporting into governed, scalable Power BI solutions.
• Ensure data quality and accuracy through validation and monitoring of outputs.
• Implement and maintain Row-Level Security and secure access to reports.
• Develop and maintain documentation, provide user support, and collaborate with data engineering teams to leverage enterprise platforms (Databricks).

Skills

Power BI development

Semantic modelling

DAX

Stakeholder management

Communication

Education

Bachelor’s degree in Computer Science / IT / Data Science

Tools

Power BI

SQL

Databricks

Azure

Job description

• Join the world’s largest privately owned insurance broker
• Advance your career in technology and insurance by collaborating with talented teams across the globe
• Based primarily based at our Sydney office, with flexibility options available
• Report directly to our Analytics & BI Manager

As a Business Intelligence Developer, you will play a key role in delivering high-quality business intelligence solutions across the organisation. You will work closely with stakeholders to understand reporting requirements, analyse data from multiple sources, design semantic models using star schema principles, and develop intuitive Power BI reports and dashboards that enable data-driven decision-making. The role requires strong analytical skills, experience with SQL and data modelling principles, and the ability to translate business processes and existing reporting solutions into scalable, governed Power BI datasets and reports.

Working at Lockton is an exciting chance to be a part of a vision and growth which leads to results. Our flat structure allows anyone to raise ideas and think creatively; we are all about creating a culture where people feel valued and cared for. In fact, in April 2024, Lockton Australia was certified as a Great Place to Work company for the second year in a row and achieved an outstanding 91% Great Place to Work Statement. If this sounds like an environment you’d enjoy, we have an excellent opportunity for someone to join our team as a Business Intelligence Developer in our Sydney office.

What will you be doing?

• Partner with business stakeholders to understand reporting requirements and translate business needs into impactful analytics and reporting solutions.
• Design, develop, and maintain Power BI reports, dashboards, semantic models, and business metrics, leveraging Power Query, data transformations, parameters, deployment pipelines, and Power BI best practices.
• Design and maintain semantic models using star schema principles, including fact and dimension modelling, to support scalable, trusted, and high-performing reporting solutions.
• Analyse data from multiple sources to identify trends, opportunities, and key business insights that support decision-making.
• Transform and modernise existing Excel-based reporting processes into governed and scalable Power BI solutions.
• Ensure data quality, accuracy, and consistency through validation, reconciliation, testing, and ongoing monitoring of reporting outputs.
• Implement and maintain Row-Level Security (RLS) and support secure, role-appropriate access to business reporting.
• Develop and maintain technical and end-user documentation, provide user support and training, and collaborate with data engineering teams to leverage enterprise data platforms, including Databricks.

You will need the following experience and qualifications:

• Bachelor’s degree in computer science, Information Technology, Data Science, or a related field.
• 2-4 years' experience in Business Intelligence, Data Analytics, or Power BI development.
• Strong Power BI development skills, including semantic modelling, DAX, Power Query, data transformation, Row-Level Security (RLS), and Deployment Pipelines.
• Strong understanding of star schema design, facts, dimensions, and data modelling best practices.
• Experience using SQL to analyse, validate, and reconcile data from multiple sources.
• Proven ability to gather requirements, engage stakeholders, and translate business needs into intuitive reporting and analytics solutions.
• Experience modernising Excel-based reporting into scalable Power BI solutions; exposure to Azure and Databricks is highly desirable.
• Strong communication, documentation, and stakeholder management skills, with the ability to explain technical concepts to non-technical audiences.
• Certifications that set you apart:
• Microsoft Certified: Power BI Data Analyst Associate.
• Any Other Microsoft Data & Analytics certifications will be highly regarded

We offer:

• Join us in an agile/hybrid work environment that promotes flexibility and work-life balance.
• We prioritise your professional growth with training and development opportunities at all levels. Benefit from our 10-week mentoring program for guidance and support to excel in your role.
• Your well-being matters. Enjoy discounted corporate private health insurance, a complimentary flu vaccination program. Our Salary Continuance insurance provides financial protection for you and your family in case of illness or injury.
• Take time for yourself. We offer extra paid summer and winter days to focus on your wellness and recharge.
• We value your contributions and offer competitive remuneration packages. Be recognized for your hard work through our reward and recognition schemes.
• Family comes first. Enjoy paid parental leave and contribute to your community with our paid volunteer leave.
• Your mental well-being is important. Our employee assistance program provides coaching and counselling services.
• Join our inclusive culture. Engage with our Wellness, Diversity, Equity & Inclusion, and CSR Associate Resource Groups to participate in initiatives aligned with your passions and values.

About Lockton

Lockton has grown to become the world’s largest privately owned insurance broker. Certified as a Great Place to Work in Australia and featured on the Top 50 Workplaces for Women, our structure and unique culture empower Associates to make decisions and influence the direction of the business.

With top-tier mentors and a 98% client retention rate in Australia, we employ some of the best and brightest minds in the risk and insurance industry.

The insurance industry isn’t going anywhere. It’s stable. It’s secure. Over 300 Associates help organisations every-day to drive profitability over the long-term and become more resilient.

To learn more about us, please visit global.lockton.com.

Lockton is committed to equal opportunity employment. We value diverse perspectives and contributions from all our associates. We strongly encourage applications from individuals of all backgrounds, ages, religions, including Aboriginal and Torres Strait Islander Peoples, LGBTIQ+ people, individuals with disabilities, women, and those from culturally or linguistically diverse backgrounds.