Associate Consultant

Location: Sydney or MelbourneEmployment type: Full-timeCompany: MIP Australia – The Data CompanyAbout MIPMIP 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.Our consultants work across a broad range of industries and technologies, including Microsoft Power BI, Tableau, Alteryx, Snowflake, Databricks, Microsoft Fabric, AWS and Azure.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.About the roleAs an Associate Consultant, you will work alongside experienced MIP consultants to design, develop and deliver data and analytics solutions for our clients.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.You will also work directly with clients to understand requirements, communicate progress and translate business problems into practical and sustainable solutions.This role is suited to an early-career consultant who wants to broaden their technical capabilities while developing strong client-facing and consulting skills.Key responsibilitiesYour responsibilities will include:Working with clients and senior consultants to understand business, reporting and data requirements.Extracting, cleansing, transforming and integrating data from multiple systems and sources.Developing and maintaining ETL or ELT data pipelines.Writing and optimising SQL queries.Supporting the development of cloud-based data platforms and data warehouse solutions.Developing data models that support reporting, analytics and business decision-making.Building dashboards, reports and data visualisations using Power BI, Tableau or similar tools.Automating repeatable data preparation, validation and reporting processes.Performing data quality checks, reconciliation and testing.Troubleshooting data issues and identifying their underlying causes.Documenting requirements, data sources, transformation logic, technical processes and delivered solutions.Participating in client meetings, workshops, demonstrations and project updates.Communicating progress, risks, issues and dependencies clearly to project leads and stakeholders.Supporting solution deployment, user acceptance testing, training and handover.Contributing to internal knowledge-sharing, innovation and continuous-improvement activities.About youYou 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.You will have:At least one year of relevant commercial experience in consulting, data engineering, data analytics, business intelligence or a related technology role.Practical experience preparing, transforming and integrating data from multiple sources.Working knowledge of SQL and relational databases.Experience developing or supporting ETL or ELT data pipelines.An understanding of data modelling, data warehousing and data quality principles.Experience with at least one analytics or visualisation platform, such as Power BI or Tableau.Strong analytical and problem-solving skills.Good written and verbal communication skills.The ability to explain technical information clearly to technical and non-technical stakeholders.Strong attention to detail and a commitment to delivering accurate, high-quality work.The ability to manage priorities and work effectively as part of a project team.A willingness to ask questions, seek feedback and take ownership of your professional development.Australian working rights.Desirable experienceExperience in any of the following would be advantageous:Microsoft Fabric, Snowflake or Databricks.Microsoft Azure or AWS data services.Python or another data-focused programming language.Alteryx or similar data automation tools.Data orchestration and pipeline technologies.APIs, JSON, flat files and other data integration methods.Git or another source-control platform.Dimensional modelling and data warehouse design.Cloud-based analytics and modern data platform projects.Consulting or client-facing project delivery.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.What we offerAt MIP, you will have the opportunity to:Work on real data engineering, analytics and business intelligence projects.Gain exposure to clients across a range of industries.Learn from experienced consultants and technical specialists.Build experience across leading cloud, analytics and data platform technologies.Receive coaching, mentoring and professional development.Develop both technical expertise and client-facing consulting skills.Work within a collaborative environment where knowledge-sharing is encouraged.Build a long-term consulting career within an established Australian data and analytics consultancy.How to applyPlease submit your résumé:Your relevant consulting, data engineering and analytics experience.The technologies, data platforms or projects you have worked with.Example of a business or data problem you helped solve.MIP is committed to building a diverse and inclusive workplace. We welcome applications from candidates with different backgrounds, experiences and perspectives.