Data & AI Consultant

RGIT Australia; Sydney; On-site; AUD 120,000 - 160,000; Full time

Benefits offered by this job

Birthday Leave

Monthly Team Lunches

Tech Product Discounts

Paid Parental Leave

Flexible Working Arrangements

Learning & Development Opportunities

Competitive Salaries

Job summary

ASI Solutions is seeking a Data & AI Consultant to design, build and support analytics solutions across Microsoft Fabric and Power BI for clients in education, government, and commercial sectors. You will shape data models, dashboards, and automation while working with Copilot, Azure OpenAI, and governance best practices.

You will run discovery workshops, map KPIs to requirements, and mentor junior consultants, delivering high-value analytics services and enabling customer success.

Qualifications

• Extensive hands-on experience delivering BI and data solutions on the Microsoft stack.
• Strong Power BI skills with dimensional modelling and DAX.
• Experience with Fabric, Lakehouse/Warehouse, Data Factory pipelines, and semantic models.

Responsibilities

• Design and build end-to-end analytics solutions in Microsoft Fabric (Lakehouse/Warehouse, pipelines, notebooks).
• Build and tune Power BI models and reports with security and performance in mind.
• Lead workshops, map KPIs, and translate questions into data models and delivery plans.
• Mentor junior consultants and contribute reusable assets to the practice.

Skills

Power BI

SQL

Azure

Power Apps

Power Automate

Dataverse

GitHub

Fabric Analytics

Education

Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)

PL-300 / DP-700 / PL-600 or AZ-900/DP-900

Tools

Microsoft Fabric

OneLake

Data Factory

Git integration

Job description

ASI Solutions is an Australian-owned technology partner focused on making lives easier through agile, reliable technology at scale. For nearly 40 years, ASI has supported education, government, and commercial organisations as technology environments have grown more complex and more critical to performance. Our approach is practical and outcomes-led. We take the time to understand what matters to each organisation before designing and delivering right-sized, de-risked solutions across managed services, cloud, security, data and AI, and digital skills. With national capability and local delivery teams, ASI helps customers move forward with clarity and confidence.

About the Role

We have an e opportunity for a Data & AI Consultant to join our growing Data & AI practice. In this role, success looks like solutions that get adopted, not shelved: reports that are actually used, business stakeholders who trust the numbers because you explained them clearly, and delivery patterns that lift the whole team. You'll design, build and support analytics solutions across Microsoft Fabric and Power BI for customers in education, government and commercial sectors — with exposure to Copilot, Azure OpenAI and agent-based solutions as we extend into Generative AI.

Responsibilities

• Design, build and optimise end-to-end analytics solutions in Microsoft Fabric, including Lakehouse and Warehouse design, Data Factory pipelines, Dataflows Gen2, notebooks and the medallion (bronze/silver/gold) pattern
• Build and tune Power BI semantic models and reports, including star schema modelling, DAX, Power Query (M), incremental refresh, row-level security and performance tuning
• Run discovery workshops and stakeholder interviews, mapping business processes and KPIs into requirements the business can sign off on
• Turn ambiguous business questions into a defensible data model, metric definitions and delivery plan
• Deliver supporting automation using Power Apps, Power Automate and Dataverse where relevant
• Apply governance and security good practice across workspaces, source control, access models and data quality controls
• Produce clear solution documentation, handover material and customer enablement/training
• Support pre-sales activity, including scoping, effort estimation and demonstrations
• Mentor junior consultants and contribute reusable assets back into the practice
• Own delivery quality on your engagements, managing scope, timeline and stakeholder communication

A Bit About You

You measure your own success by whether your solutions get used. You're analytically sharp, but it's your soft skills that set you apart — you can sit with a business stakeholder, understand what they actually need, and explain a technical trade-off in language that builds confidence rather than confusion. You take ownership from discovery through to handover, you're not afraid to challenge a requirement constructively, and you're always looking for a better way to solve the problem.

• Extensive, hands-on experience delivering business intelligence and data solutions on the Microsoft stack, including time in a consulting or customer-facing delivery role
• Strong, demonstrable Power BI skills, including dimensional/star schema modelling, advanced DAX, Power Query (M), report design and performance optimisation
• Practical delivery experience with Microsoft Fabric, including Lakehouse/Warehouse, OneLake, Data Factory pipelines, Dataflows Gen2, Direct Lake and semantic model deployment
• Strong SQL skills and a solid grasp of data warehousing and modelling fundamentals
• Strong analytical ability — confident interrogating messy data and reasoning from a business question to the right solution
• Genuine business analyst capability, including requirements elicitation, KPI mapping, stakeholder management and workshop facilitation
• Excellent written and verbal communication, with the confidence to present to and defend solutions with stakeholders up to executive level
• Ability to work independently and as part of a team, managing competing priorities across multiple customers
• Australian work rights, and willingness to undergo relevant background/probity checks (including a Working with Children Check where required)
• Able to demonstrate your work through sample reports, semantic models, a public portfolio, or a walkthrough of solutions you've personally delivered
• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
• Strong Power Apps experience (canvas and model-driven apps, Dataverse modelling, solution-based ALM)
• Strong Power Automate experience (cloud flows, connectors, approvals, process automation)
• Experience with Fabric or Power BI governance at scale — tenant settings, capacity management, deployment pipelines and Git integration
• Experience running enablement sessions for customer business users
• Additional certifications such as PL-300, DP-700, PL-600 or AZ-900/DP-900
• Exposure to Copilot in Power BI/Fabric, Azure OpenAI or agent-based solutions
• Python or PySpark for notebook-based transformation in Fabric
• Experience with Azure data services and Azure DevOps/GitHub for source control and CI/CD
• Experience with agile delivery methods such as Scrum or Kanban
• Industry experience in education, government or not-for-profit sectors

Why work with us?

Birthday Leave – Celebrate your special day with a paid day off. Monthly Team Lunches – Connect, unwind, and enjoy great food with your colleagues. Tech Product Discounts – Access exclusive savings on a wide range of technology products. Paid Parental Leave – Support for growing families with dedicated leave options. Flexible Working Arrangements – Balance work and life with hybrid options and flexibility. Learning & Development Opportunities – Grow your skills through training, certifications, and career progression pathways. Competitive Salaries – Be rewarded with remuneration that reflects your experience and contribution. Diversity & Inclusion Committees – Be part of creating a workplace where everyone feels valued, supported, and included. Engagement Activities All Year Round – Enjoy social events, wellbeing initiatives, and team-building activities that strengthen our community. Supportive, Community-Driven Culture – We're not just a team — we're a connected, people-focused community making a meaningful impact.

Company Overview

ASI Solutions is an Australian technology partner with a clear purpose: making lives easier through agile, reliable technology at scale. We help organisations cut through complexity, make confident technology decisions, and implement right-sized solutions that deliver real outcomes today and into the future.