Data & AI Consultant

ASI Solutions

Sydney

Hybrid

AUD 120,000 - 170,000

Full time

14 hours ago
Be an early applicant
Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Birthday Leave
Monthly Team Lunches
Tech Product Discounts
Paid Parental Leave
Flexible Working Arrangements
Learning & Development Opportunities
Competitive Salaries
Diversity & Inclusion Committees
Engagement Activities All Year Round
Supportive, Community-Driven Culture

Job summary

ASI Solutions is seeking a Data & AI Consultant to deliver analytics solutions across Microsoft Fabric and Power BI for education, government, and commercial sectors. You will design, build and support end-to-end analytics pipelines, reports, and AI-enabled features with a focus on adoption and business value.

You will engage with stakeholders, translate requirements into data models, and mentor junior team members while contributing reusable assets to the Data & AI practice.

Qualifications

  • Hands-on BI and data solution delivery on the Microsoft stack, with consulting or client-facing experience.
  • Strong Power BI skills: dimensional modelling, DAX, Power Query, design and performance.
  • Practical Fabric experience: Lakehouse/Warehouse, Data Factory pipelines, Dataflows Gen2, semantic models.

Responsibilities

  • Design, build and optimise analytics solutions in Microsoft Fabric (Lakehouse/Warehouse).
  • Build and tune Power BI models and reports with performance in mind.
  • Run workshops, map KPIs, and translate questions into data models and plans.
  • Deliver automation via Power Apps/Power Automate as relevant.
  • Ensure governance, security, and data quality across workspaces and data products.
  • Create documentation, enablement materials, and support pre-sales activities.
  • Mentor junior consultants and contribute reusable assets.
  • Own delivery quality, manage scope and timelines.

Skills

Power BI
SQL
Data modeling
Data warehousing
Stakeholder communication
Consulting experience

Education

Bachelor's degree in CS/IS/Math

Tools

Microsoft Fabric
Power BI Desktop
Azure Data Services
Data Factory
Dataverse
Git

Job description

About ASI Solutions

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 ASI Solutions

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.

Essential Criteria
  • 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
Desirable Criteria
  • 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.
Get your free, confidential resume review.
or drag and drop your file here.
Similar jobs

Similar jobs worth comparing

Data & AI Consultant
Data & AI Consultant

RGIT Australia • Sydney

On-site
AUD 120,000 - 160,000
Birthday Leave
Monthly Team Lunches
Tech Product Discounts
+4
Senior Data Architect
Senior Data Architect

Insight • City of Brisbane

Hybrid
AUD 170,000 - 230,000
Career pathways and development
President’s Club
Volunteer Leave and Work Life Balance
+3
Principal Consultant - AI
Principal Consultant - AI

LAB 3 Pty Ltd • Australia

Hybrid
AUD 180,000 - 240,000
AI Solutions Consultant
AI Solutions Consultant

Clyphor AI • Sydney

On-site
AUD 80,000 - 120,000
Competitive base salary with performance-based bonuses
Extensive travel opportunities across Australia
Health insurance and comprehensive benefits package
Senior Data Architect
Senior Data Architect

Insight Enterprises, Inc. • City of Brisbane

Hybrid
AUD 150,000 - 190,000
Work-From-Anywhere Program
Volunteer Leave
President’s Club
+2
Senior Consultant, Sydney
Senior Consultant, Sydney

Practiv • Council of the City of Sydney

On-site
AUD 90,000 - 120,000
Principal Consultant- AI
Principal Consultant- AI

LAB3 • Sydney

Hybrid
AUD 180,000 - 260,000
Remote/hybrid work
Career development & ongoing learning
Inclusive workplace
+1
Principal Consultant- AI
Principal Consultant- AI

LAB3 • Canberra

Hybrid
AUD 180,000 - 240,000
Senior / Tech Lead AI Engineer
Senior / Tech Lead AI Engineer

Datacom • Sydney

Hybrid
AUD 150,000 - 210,000
Flexible hybrid work options
Parental leave
Employee assistance program
+2
AI Engineering Consultant
AI Engineering Consultant

Practiv • City of Melbourne

Hybrid
AUD 120,000 - 180,000
Hybrid work
Leading technologies exposure
Professional development
+2