Lead BI Developer (Power BI, SQL & Data Modelling)

Aurec; Sydney; Hybrid; AUD 120.000 - 150.000; Vollzeit

Zusammenfassung

Aurec is seeking a hands-on BI and analytics specialist to own the workforce analytics environment. You will combine Power BI, SQL, and data modelling to turn complex HR data into actionable insights that influence decisions on headcount, retention, remuneration and recruitment.

This role is non-management, with technical leadership and collaboration with executives in a large Australian organisation operating in a flexible hybrid setup.

Qualifikationen

• 5+ years' experience delivering BI/analytics in complex data environments.
• Strong Power BI, DAX, semantic modelling, and performance tuning.
• Hands-on SQL Server development and data integration skills.
• Experience with workforce or HR analytics is a plus.
• Ability to translate technical results into business outcomes.

Aufgaben

• Design enterprise Power BI dashboards and semantic models.
• Develop and optimize SQL Server queries, views and stored procedures.
• Transform datasets with Power Query and M for reliable insights.
• Collaborate with senior stakeholders to define requirements and present insights.
• Establish standards and contribute to governance and mentoring.

Kenntnisse

Analytical thinking

Stakeholder communication

Mentoring peers

Tools

Power BI

DAX

Power Query

M

SQL Server

Stored procedures

Data modelling

Azure data services

Jobbeschreibung

Build the data products that influence enterprise-wide decisions!

We are working on an opportunity for a hands‑on BI and analytics specialist who's ready to take technical ownership of a major organisation's workforce insights function.

This isn't a traditional people‑management role. It's an opportunity to combine advanced Power BI, SQL and data modelling with genuine technical leadership and direct exposure to senior executives.

You'll own the end-to-end workforce analytics environment, turning complex data into insights that shape decisions around headcount, retention, remuneration, recruitment and strategic workforce planning.

Why this role stands out:

• Set the technical direction, own architecture and mentor other analysts while remaining hands‑on with SQL, DAX, Power Query and Power BI.
• Your work reaches the executive level. Partner with senior leaders to turn business challenges into insights that influence real workforce decisions.
• Complex data, enterprise scale. Work across HRIS, payroll and data warehouse environments, bringing disparate datasets together into trusted, scalable reporting solutions.
• Own the full analytics lifecycle. From SQL Server views and stored procedures through to semantic models, advanced DAX and executive dashboards.
• Room to innovate. Help improve data quality, automate reporting and explore Microsoft Fabric and Azure data services.

What you'll be doing:

• Designing and building enterprise Power BI dashboards, semantic models and complex DAX measures.
• Developing and optimising SQL Server queries, views, stored procedures and data integration processes.
• Using Power Query and M to transform complex datasets into reliable, decision-ready information.
• Working directly with senior stakeholders to define requirements and communicate insights in clear, commercially relevant terms.
• Establishing technical standards, improving reporting governance and mentoring fellow analysts.

What we are looking for:

• 5+ years' experience delivering BI, reporting or analytics solutions in complex data environments.
• Strong hands‑on expertise in Power BI, advanced DAX, semantic modelling and performance optimisation.
• Solid SQL Server skills, including stored procedures, views and query optimisation.
• Advanced Power Query / M and experience building robust data pipelines.
• The ability to translate technical analysis into meaningful business outcomes.
• Experience with workforce or HR analytics is beneficial, but strong enterprise BI experience and the ability to handle sensitive data are equally relevant.

You’ll join a large Australian organisation undergoing ongoing transformation, with a flexible hybrid working environment, modern data technologies and the opportunity to make a tangible impact beyond the reporting function.