Job Title

Level: ConsultantLocation: Sydney, Australia (flexible/hybrid)As a Consultant at MIP, you''re a handson data and analytics professional who can own a workstream, work directly with clients, and help guide Associate Consultants. You''ll deliver modern data and analytics solutions, data pipelines, models, dashboards and semantic layers, on platforms like Fabric, Databricks, Snowflake and our partner BI tools. You''re expected to translate requirements into technical designs, deliver quality outcomes with limited supervision, and contribute to our delivery standards and reusable assets.Key responsibilitiesDesign and build data and analytics solutions under guidance from a Senior / Lead, including:Data integration and pipelines (SQL, dbt, Fabric, Snowflake, Databricks, Alteryx or similar).Analyticsready data models (dimensional/star schemas, semantic models, medallion patterns).BI & visualisation solutions (Power BI, Tableau) including RLS, drillthrough and KPI layers.Own endtoend delivery of a smalltomedium workstream (e.g. a subject area, set of dashboards, or pipeline) including design, build, test, documentation and handover.Proactively identify data quality issues or design gaps and propose options to resolve them.Support productionisation (deployments, monitoring, defect resolution) in line with MIP standards.Participate actively in client workshops, standups, demos and retros, not just as a notetaker.Clarify and refine requirements with business stakeholders, turning them into user stories and tasks.Explain design decisions and tradeoffs in plain language to nontechnical stakeholders.Build trust with client counterparts through clear expectations, proactive status updates and "no surprises".Ways of working, quality & governanceWork within agreed delivery methods (Agile / Scrum / Kanban / hybrid) and help run ceremonies (standups, reviews, retros) for your workstream.Follow and contribute to MIP''s development, testing and documentation standards.Ensure solutions are secure, performant and maintainable, and align to agreed architectures.Contribute to effort estimates for your own work and provide input into broader project estimates.Provide daytoday guidance to Associates (pairing, code reviews, explaining requirements).Share knowledge with the team (internal showandtells, docs, accelerators, patterns).Flag delivery risks early and work with Seniors/Leads to address them.Demonstrate MIP''s values and help maintain a healthy, inclusive team culture.Skills & experience must haveTechnical25 years'' experience in data & analytics, BI or data engineering (consulting preferred but not essential).Strong practical SQL and experience with relational databases.Power BI and/or Tableau at a solid practitioner level, able to design, build, publish and iterate dashboards used by real stakeholders (incl. measures, RLS, drillthrough, usability).Alteryx experience building, scheduling and supporting workflows for ETL/ELT or analytics.At least one modern data platform / framework in production, for example:Microsoft FabricDatabricksSnowflakedbt (cloud or core with a cloud data warehouse behind it)Demonstrated experience delivering at least one of:Data pipelines / ETL / ELT in a production or nearproduction environment;Analyticsready data models for reporting (e.g. star schemas, semantic models, curated gold tables).Can break down ambiguous requirements into concrete tasks and plan your own work.Strong written and verbal communication, able to switch between technical and business audiences.Proven ability to work in a delivery team, manage priorities, and meet agreed deadlines.Comfortable working directly with customers, including constructively pushing back when something won''t work.BackgroundPrior experience in a clientfacing role (consulting, vendor, or internal business partner) is highly regarded.Nice to haveGitbased workflows and basic CI/CD (GitHub / Azure DevOps).Exposure to one or more of:Advanced analytics / ML,Graph databases and visualisation,Data observability / FinOps tooling.Experience mentoring juniors or leading a small workstream.What you''ll get in return:Work with marquee Australian clients on modern stacks (Snowflake, Fabric, Databricks).Real ownership with support from senior architects and practice leads.Flexible hybrid work and a supportive culture. #J-18808-Ljbffr