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 ****, 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.
Solid 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.
We do not accept speculative CVs from recruitment agencies and will not be liable for any fees associated with unsolicited submissions.
#J-*****-Ljbffr

📌 Business Intelligence Developer (New South Wales)
🏢 Lockton
📍 New South Wales