Data Analyst or Engineer - Technology Consulting

At EY, we’re all in to shape your future with confidence. We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. Join EY and help to build a better working world. Nāu te rourou, nāku te rourou, ka ora ai te iwi With your contribution and my contribution, together we will thrive. Hei Oranga Iwi | The opportunity We are seeking a skilled Senior Consultant to join our team as a Data Analyst / Engineer. In this role, you will help clients understand, improve, and transform their data, combining analytical skills with hands-on engineering to deliver trusted data and practical business outcomes. You will work across data analysis, data quality, data migration, and cloud data platform delivery. This includes profiling source data, translating business requirements into data models and transformation rules, implementing data quality frameworks, and building reliable data pipelines using Snowflake and/or Databricks. Working alongside business and technical teams, you will help clients migrate data from legacy systems, resolve data quality issues, and develop data products and insights that support better decision-making. You will also provide technical guidance and mentorship to junior team members. In line with client requirements, this role is based in our Te Whanganui-a-Tara (Wellington) office. Ko Tō Rourou | Your key responsibilities Analyse and profile source data to understand its structure, quality, relationships, and suitability for migration, reporting, and analytics. Work with business stakeholders to capture data requirements and translate them into source-to-target mappings, transformation rules, data models, and acceptance criteria. Implement data quality frameworks, including quality dimensions, business rules, automated checks, monitoring, reporting, and issue remediation processes. Investigate data quality issues, identify root causes, and work with business and technical teams to improve data at source and throughout its lifecycle. Deliver data migration activities, including extraction, cleansing, transformation, loading, reconciliation, testing, and cutover support. Design, build, and maintain scalable data ingestion and transformation pipelines using Snowflake and/or Databricks and supporting tools. Develop curated datasets, data products, and analytical outputs that meet business needs. Apply sound engineering practices, including version control, automated testing, documentation, and deployment processes. Communicate findings, delivery progress, and data risks clearly to technical and non-technical stakeholders. Provide technical guidance and mentorship to junior analysts and engineers. Ngā Pūkenga | Skills and attributes for success Ideally, you’ll also have the skills and attributes below but don’t worry if you don’t tick all the boxes. We’re interested in your aptitude, attitude and willingness to learn. Data analysis and profiling, using SQL to investigate complex datasets, identify patterns, and diagnose data issues. Hands-on data engineering using Snowflake and/or Databricks. Experience with either platform is welcome; experience with both is advantageous. Implementing data quality frameworks in practice, including defining quality rules and thresholds, building automated validation checks, and establishing monitoring and remediation processes. Delivering data migrations, including source-system assessment, source-to-target mapping, data cleansing, transformation, migration testing, and reconciliation. Designing and building ETL/ELT pipelines to integrate data from multiple sources. Data modelling, including relational models, dimensional models, and curated analytical datasets. Writing efficient SQL and using Python for data processing, automation, or validation. Working with business stakeholders to define requirements, interpret data, and explain technical findings in practical business terms. Producing clear technical documentation, including mappings, data definitions, test evidence, and operational handover material. Experience with tools such as dbt, Fivetran, Coalesce, or comparable integration and transformation tools. Experience developing dashboards, reports, or semantic models using Power BI or similar tools. Familiarity with data governance, metadata management, data lineage, and data catalogues. Experience with Snowflake Horizon Catalog and/or Databricks Unity Catalog. Experience with cloud platforms such as Microsoft Azure, AWS, or Google Cloud. Familiarity with Git, CI/CD, orchestration, and automated data testing. Experience supporting migration rehearsals, cutover planning, and post-migration validation. Ko Taku Rourou | What we offer you At EY, we’ll fuel you and your extraordinary talents in a diverse and inclusive culture of globally connected teams. Career development: At EY, your career is yours to shape! We’ll develop you with future-focused skills and equip you with world-class experiences www.ey.com/nz/careerdevelopment Flexible work arrangements: Our flexible work policies empower you to balance your professional and personal life, fostering a culture of trust and autonomy. A comprehensive benefits package: From a yearly wellness incentive, to access to additional 8 weeks of flex leave per year, and family-friendly policies, including up to 26 weeks of gender-neutral paid parental leave, we cater to your diverse needs to help you thrive both personally and professionally www.ey.com/nz/benefits Salary: We offer a competitive salary which is open to negotiation pending on skills and experience. Inclusiveness is core to who we are and how we work together, driving value for our people and for our business. We encourage applications from people of all ages, nationalities, abilities, cultures, sexual orientations, and gender identities and are committed to providing an equitable and barrier free recruitment experience for all. We encourage you to share any support and adjustments you need to be your best and participate equitably in our recruitment process. We understand sharing your needs with us can be daunting, so if you have questions before or during your application, we welcome you to get in touch at contactrecruitment@au.ey.com or +64 9 300 7044 (option 2). Anything you tell us will be kept completely confidential. He rourou kai kei ō ringa hei tākoha? Tēnā haria mai! Are you ready to shape your future with confidence? Apply today #LI-Hybrid EY | Building a better working world Our preferred applicant will be required to undertake employment screening by EY or our external third-party provider. © 2026 Ernst & Young New Zealand. A member firm of Ernst & Young Global Limited. All Rights Reserved.