Data and Reporting Analyst

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

As a Data and Reporting Analyst, you’ll play a key role in Lockton’s data transformation journey. You’ll engage with business stakeholders to understand their needs and turn them into powerful insights, designing scalable data models, building robust ETL pipelines, and creating dynamic Power BI dashboards that deliver a single source of truth. By ensuring data quality, supporting self-service analytics, and sharing knowledge, you’ll build a strong data-driven culture while staying ahead of emerging trends in analytics and visualisation.

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. If this sounds like an environment you’d enjoy, we have an excellent opportunity for someone to join our team as a Data and Reporting Analyst in our Sydney office.

What will you be doing?

• Lead stakeholder workshops to gather requirements and delivery analytics solutions that align with business needs.
• Design and optimise data architecture by enhancing and maintaining the central data model for scalability and consistency across global teams.
• Drive data-driven decisions by creating powerful reporting and dashboards in Power BI that establish a single source of truth and enable self-service analytics.
• Define, implement, and test Row-Level Security (RLS) in Power BI, ensuring secure, role-appropriate access to reports.
• Build and maintain ETL structures and semantic layers in Power BI to support comprehensive analytics and integrate data from multiple sources.
• Ensure data quality and governance, delivering accurate, reliable, and secure analytics outputs.
• Monitor and analyse performance by tracking key initiatives, analysing trends, and identifying growth opportunities across the business.
• Provide training and technical support for Power BI, SQL, and data integration issues when required, ensuring smooth operations.
• Empower teams through training and guidance, enabling effective use of reporting tools and self-service analytics.
• Maintain thorough documentation for data models, ETL processes, and reporting solutions.
• Stay ahead of the curve by continuously learning and applying best practices in data visualisation, analytics, and SQL development.

You will need the following experience and qualifications:

• A bachelor’s degree in computer science, Information Technology, Data Science, or a related field.
• 3–5 years of experience in data analysis and business intelligence, with proven ability to engage stakeholders and deliver insights.
• Solid understanding of the insurance industry – this is essential to hit the ground running.
• Advanced skills in Power BI (including DAX, Power Query, Semantic Model, RLS, Data Flows, and Deployment Pipelines).
• Strong technical foundation in SQL, Python, and data governance.
• Hands-on experience in cloud environments, especially Azure, plus experience with ETL tools and processes (bonus points if you’ve worked with Azure Databricks).
• Certifications that set you apart:
• Microsoft Certified: Power BI Data Analyst Associate (required).
• Microsoft Certified: Azure Data Engineer Associate (preferred).
• Excellent communication skills – you can translate complex technical concepts into clear, actionable insights for non-technical stakeholders.
• A growth mindset, high attention to detail, and a passion for continuous learning and staying ahead of industry trends.

About Lockton

Lockton has grown to become the world’s largest privately owned insurance broker. At Lockton, we believe in empowering our people and fostering a culture of connection, innovation, and growth. You’ll be part of a collaborative team that values your voice and supports your professional development.

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.

We offer:

• A strong focus on training and development opportunities at all levels and a 10-week mentoring program.
• Discounted corporate private health insurance and a free flu vaccination program.
• Salary Continuance insurance to protect you and your family in the event you suffer an illness or injury.
• Extra paid Summer and Winter day to focus on your wellness.
• Paid parental leave and volunteer leave.
• Opportunities to give back to the communities in which we work and live.
• Access to an employee assistance program for coaching and counselling.
• The opportunity to get involved or participate in initiatives organised by our Wellness, Diversity, Equity, & Inclusion, Young Professionals and Corporate Social Responsibility Associate Resource Groups.

How to apply:

If you think you’d be a great fit, please click “apply” with a CV and detailed cover letter indicating why this job posting caught your attention and how your skills and experience are a fit for this role.

Lockton is an equal opportunity employer. We strongly encourage applications from people of all backgrounds, ages, religions, including Aboriginal and Torres Strait Islander Peoples, LGBTIQ+ people, those with a disability, women and people with a cultural or linguistically diverse background.

**We do not accept speculative CVs from recruitment agencies and will not be liable for any fees associated with unsolicited submissions.**