Data Analyst or Engineer - Technology Consulting

EY

Wellington

On-site

NZD 90,000 - 130,000

Full time

9 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Career development
Flexible work arrangements
Benefits package
Competitive salary

Job summary

EY in Wellington is seeking a Senior Consultant to join as a Data Analyst/Engineer. You will help clients understand, improve, and transform data, delivering trusted data and practical business outcomes.

The role covers data analysis, data quality, data migration, and cloud platform delivery, using Snowflake and/or Databricks, with mentorship to junior teammates.

Qualifications

  • Proficient in SQL for profiling, querying, and data validation.
  • Experience building data pipelines and data models for analytics.
  • Knowledge of data quality frameworks and data governance practices.
  • Experience with Snowflake and/or Databricks for cloud data platforms.

Responsibilities

  • Profile source data to assess structure, quality, and migrations.
  • Translate business requirements into source-to-target mappings and models.
  • Build and maintain data pipelines with Snowflake/Databricks.
  • Develop datasets and data products to support analytics and decision making.
  • Mentor junior analysts/engineers and document technical work.

Skills

SQL
Python
Power BI
Data analysis
Data modelling

Education

Bachelor's degree in a related field

Tools

Snowflake
Databricks
dbt
Fivetran

Job description

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 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.

EY | Building a better working world

Our preferred applicant will be required to undertake employment screening by EY or our external third-party provider.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Migration Lead - Ai And Data - Technology Consulting
Data Migration Lead - Ai And Data - Technology Consulting

Ey • Wellington

On-site
NZD 120,000 - 180,000
Senior Manager - Data and Transformation - Technology Consulting
Senior Manager - Data and Transformation - Technology Consulting

EY • Auckland

On-site
NZD 180,000 - 260,000
Senior Consultant - Technology Strategy and Transformation - Technology Consulting
Senior Consultant - Technology Strategy and Transformation - Technology Consulting

EY • Wellington

Hybrid
NZD 120,000 - 180,000
Flexible work arrangements
Wellness incentive
Flex leave (8 weeks per year)
+1
Solution Architect - Snowflake
Solution Architect - Snowflake

EY • Auckland

Hybrid
NZD 180,000 - 240,000
Flexible work arrangements
Wellness incentive
Extended flex leave (8 weeks)
+1
Senior Manager - Data And Transformation - Technology Consulting
Senior Manager - Data And Transformation - Technology Consulting

Womentech Network • Auckland

Hybrid
NZD 180,000 - 230,000
Career development
Flexible work arrangements
Wellness incentive and flex leave
Senior Consultant - People Consulting
Senior Consultant - People Consulting

EY • Auckland

On-site
NZD 100,000 - 140,000
Senior Technology Transformation Delivery Lead
Senior Technology Transformation Delivery Lead

EY • Wellington

On-site
NZD 180,000 - 230,000
Career development
Flexible work arrangements
Comprehensive benefits package
EOI - Senior Consultant or Manager - Workforce Advisory - People Consulting
EOI - Senior Consultant or Manager - Workforce Advisory - People Consulting

EY • Auckland

Hybrid
NZD 120,000 - 180,000
Flexible work arrangements
Career development
Benefits package
Expressions Of Interest - Business Transformation - Business Consulting
Expressions Of Interest - Business Transformation - Business Consulting

EY • Wellington

On-site
NZD 110,000 - 160,000
Flexible work arrangements
Wellness incentive
Flex leave
+2
Senior Manager - Business Transformation - Business Consulting
Senior Manager - Business Transformation - Business Consulting

EY • Wellington

On-site
NZD 180,000 - 250,000
Top locations