Business Intelligence Analyst

TL Consulting Group; Parramatta; On-site; AUD 120,000 - 170,000; Full time

Job summary

TL Consulting Group in Sydney is seeking a Business Intelligence Analyst to provide the MD and CEO with timely, accurate real-time insights. Working within the BI & PO function, you will transform raw transactional data into dependable answers via SQL querying and ad-hoc reporting.

You will validate logic, document data definitions, and collaborate with engineering to lift reporting maturity. This is a Sydney-based, onsite role requiring five days in the office.

Qualifications

• Very strong SQL experience with hands-on expertise.
• Proven ability to write and untangle complex joins.
• Experience working with transactional data.

Responsibilities

• 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.
• Write, optimise and maintain complex SQL queries across transactional data.
• Validate SQL code and reconcile data discrepancies to source.
• Consolidate and document business logic and data context for consistent reporting.
• Move ad-hoc reports into the Databricks reporting suite and lift reporting maturity.

Skills

SQL

Complex joins

Transactional data

Databricks

Power BI

Tools

Databricks

Power BI

Job description

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 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.

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.