Senior Business Intelligence Analyst

TL Consulting Group; Sydney; Presencial; AUD 120.000 - 150.000; Jornada completa

Descripción de la vacante

TL Consulting Group in Sydney is seeking a Senior Business Intelligence Analyst to translate transactional data into real-time insights for the MD and CEO, using SQL querying and ad-hoc reporting.

The role sits in the BI & PO function and collaborates with the TL team to validate logic, consolidate business rules, and drive a scalable reporting platform.

This Sydney-based, permanent position requires five days onsite and Australian work rights; no agencies, visa specifics apply.

Formación

• Very strong SQL—hands-on expertise, not just familiarity.
• Proven experience writing and untangling complex joins and multi-table queries.
• Solid experience working with transactional data.
• Ability to validate SQL code and judge whether logic and outputs are correct.
• Strength in consolidating business logic and data context.

Responsabilidades

• Respond to ad-hoc data and reporting requests from the MD, CEO and senior stakeholders.
• Provide real-time and near-real-time insights to support executive decision-making.
• Deliver dependable BAU reporting support as the day-to-day backbone of the role.
• Where possible, re-build ad-hoc reports into the Databricks reporting suite to improve scalability.

Conocimientos

SQL

Complex joins

Transactional data

Validate SQL

Data context

Stakeholder management

Databricks

Power BI

Productionised reporting

Engineering collaboration

Herramientas

Databricks

Power BI

Descripción del empleo

At TL Consulting, we simplify modern complexity with advanced, sustainable engineering. As a proudly Australian-owned consultancy with over 15 years of experience, we empower businesses to innovate and achieve measurable outcomes through scalable, cloud-native solutions. Our 50+ consultants operate across key sectors including banking, financial services & insurance (BFSI), government, retail, education, and entertainment. This cross-industry expertise allows us to deliver customer-centric solutions that combine deep technical capability with a clear understanding of each client’s strategic vision. Our approach leverages proven, scalable blueprints tailored to your business direction - enabling accelerated outcomes, maximized ROI, and sustainable long-term adoption.

We maintain strategic partnerships with organizations that share our vision for a cloud-native future. Through our collaborations with Microsoft, GitHub, and Databricks, we ensure our capabilities stay aligned with evolving best practices. These partnerships also provide access to innovation programs, co-funding opportunities, and dedicated support - helping us accelerate time-to-value for our clients.

About the role

The Senior Business Intelligence Analyst exists to give the MD and CEO timely, accurate, real-time insight into the business. Sitting within the BI & PO function and embedded alongside the TL team, the role turns raw transactional data into trustworthy answers primarily through SQL querying and ad-hoc reporting.

A defining feature of this role is that it operates against the database in its current state. Success depends not just on writing queries, but on validating SQL logic, untangling and consolidating business rules, and building a reliable, shared understanding of what the data means to drive insights and decision making.

The core responsibility is business-as-usual (BAU) reporting support and business insights; over time, there is a strong opportunity to mature this work into a modern reporting platform.

Key responsibilities

Reporting & insights

• Respond to ad-hoc data and reporting requests from the MD, CEO and senior stakeholders, often under time pressure.
• Provide real-time and near-real-time insights to support executive decision-making.
• Deliver dependable BAU reporting support as the day-to-day backbone of the role.

SQL & data analysis

• Write, optimise and maintain complex SQL queries, including advanced and multi-table joins, against transactional data.
• Validate and quality-check SQL code (your own and others') to ensure outputs are accurate and defensible.
• Investigate data discrepancies and reconcile conflicting figures back to source.

Business logic & data context

• Consolidate and document business logic, definitions and data context so reporting is consistent and repeatable.
• Build and maintain a single, shared understanding of how key metrics are calculated.
• Act as a trusted reference point for "what the numbers mean" across the business.

Platform improvement

• Where possible, re-build ad-hoc reports into the Databricks reporting suite to reduce manual effort and improve scalability.
• Contribute to lifting reporting maturity over time, moving away from one-off queries toward sustainable, productionised reporting.

Selection criteria

• Very strong SQL - demonstrated, hands-on expertise, not just familiarity.
• Proven experience writing and untangling complex joins and multi-table queries.
• Solid experience working with transactional data.
• Ability to validate SQL code and judge whether logic and outputs are correct.
• Strength in consolidating business logic and data context - translating messy, real-world data into clear, consistent reporting.
• Comfort working with a database in an imperfect state, and the resourcefulness to deliver reliable results regardless.
• Strong stakeholder skills, including the confidence and clarity to support executive-level (MD / CEO) requests directly.
• Experience with Databricks and modern reporting/BI tooling (i.e., Power BI).
• Track record of converting ad-hoc reports into productionised, reusable reporting.
• Experience working alongside technical / engineering teams.

This is a Sydney-based, permanent opportunity, with an onsite requirement of 5 days per week in the office.

No agencies please. Candidates must have valid visa with full work rights in Australia. Visas will not be transferred or sponsored.

TL Consulting Group understands the importance of fostering a diverse and inclusive workplace. We are committed to ensuring that everyone, no matter their gender, identity, sexual orientation, race, ethnicity, religion, disability, or age, has equal access to opportunities. We warmly welcome applications from all individuals, including Aboriginal and Torres Strait Islander peoples, members of the LGBTQI+ community, and individuals with disabilities.