Data Analyst Or Engineer

Data Analyst or Engineer
- Technology Consulting

Location:
Wellington Other locations: Primary Location Only Requisition ID: 1758789 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. 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. 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 shapeWe’ll develop you with future‑focused skills and e