Job Description
About MIP
n
MIP is an established Australian data and analytics consultancy. We help organisations achieve better outcomes from their data through analytics, business intelligence, data engineering, automation, cloud platforms and artificial intelligence.
n
Our consultants work across a broad range of industries and technologies, including Microsoft Power BI, Tableau, Alteryx, Snowflake, Databricks, Microsoft Fabric, AWS and Azure.
n
We are looking for an Associate Consultant with at least one year of relevant commercial experience and foundational capabilities across data engineering, analytics and data visualisation.
n
About the role
n
As an Associate Consultant, you will work alongside experienced MIP consultants to design, develop and deliver data and analytics solutions for our clients.
n
The role will involve a combination of data engineering, data preparation, analysis, reporting and visualisation. You will help develop reliable data pipelines, data models, dashboards and analytical solutions that address real business needs.
n
You will also work directly with clients to understand requirements, communicate progress and translate business problems into practical and sustainable solutions.
n
This role is suited to an early-career consultant who wants to broaden their technical capabilities while developing robust client-facing and consulting skills.
n
Key responsibilities
n
Your responsibilities will include:
n
n
Working with clients and senior consultants to understand business, reporting and data requirements.
n
Extracting, cleansing, transforming and integrating data from multiple systems and sources.
n
Developing and maintaining ETL or ELT data pipelines.
n
Writing and optimising SQL queries.
n
Supporting the development of cloud-based data platforms and data warehouse solutions.
n
Developing data models that support reporting, analytics and business decision-making.
n
Building dashboards,



reports and data visualisations using Power BI, Tableau or similar tools.
n
Automating repeatable data preparation, validation and reporting processes.
n
Performing data quality checks, reconciliation and testing.
n
Troubleshooting data issues and identifying their underlying causes.
n
Documenting requirements, data sources, transformation logic, technical processes and delivered solutions.
n
Participating in client meetings, workshops, demonstrations and project updates.
n
Communicating progress, risks, issues and dependencies clearly to project leads and stakeholders.
n
Supporting solution deployment, user acceptance testing, training and handover.
n
Contributing to internal knowledge-sharing, innovation and continuous-improvement activities.
n
n
About you
n
You enjoy solving problems, working with data and learning new technologies. You are comfortable taking ownership of assigned tasks while collaborating with clients and more experienced consultants.
n
You will have:
n
n
At least one year of relevant commercial experience in consulting, data engineering, data analytics, business intelligence or a related technology role.
n
Practical experience preparing, transforming and integrating data from multiple sources.
n
Working knowledge of SQL and relational databases.
n
Experience developing or supporting ETL or ELT data pipelines.
n
An understanding of data modelling, data warehousing and data quality principles.
n
Experience with at least one analytics or visualisation platform,



such as Power BI or Tableau.
n
Strong analytical and problem-solving skills.
n
Good written and verbal communication skills.
n
The ability to explain technical information clearly to technical and non-technical stakeholders.
n
Strong attention to detail and a commitment to delivering accurate, high-quality work.
n
The ability to manage priorities and work effectively as part of a project team.
n
A willingness to ask questions, seek feedback and take ownership of your professional development.
n
n
Experience in any of the following would be advantageous:
n
n
Microsoft Fabric, Snowflake or Databricks.
n
Python or another data-focused programming language.
n
Alteryx or similar data automation tools.
n
Data orchestration and pipeline technologies.
n
APIs, JSON, flat files and other data integration methods.
n
Git or another source-control platform.
n
Dimensional modelling and data warehouse design.
n
Cloud-based analytics and modern data platform projects.
n
n
Candidates are not expected to have experience across every technology. We are looking for strong foundations, relevant commercial experience and the ability to learn quickly.
n
What we offer
n
At MIP, you will have the opportunity to:
n
n
Work on real data engineering, analytics and business intelligence projects.
n
Gain exposure to clients across a range of industries.
n
Learn from experienced consultants and technical specialists.
n
Build experience across leading cloud, analytics and data platform technologies.
n
Receive coaching, mentoring and professional development.
n
Develop both technical expertise and client-facing consulting skills.
n
Work within a collaborative environment where knowledge-sharing is encouraged.
n
Build a long-term consulting career within an established Australian data and analytics consultancy.
n

📌 Associate Consultant (New South Wales)
🏢 MIP
📍 New South Wales