E

Ernst & Young

Global professional services: consulting, assurance, tax

Data Analyst or Engineer - Technology Consulting

Data Management +1Posted on Nov 9
Full-timeWellington, New ZealandNo salary listed

About the Job

Requirements

  • Experience in data analysis and profiling, using SQL to investigate complex datasets, identify patterns, and diagnose data issues.
  • Hands-on data engineering experience using Snowflake and/or Databricks.
  • Experience implementing practical data quality frameworks, including defining quality rules and thresholds, building automated validation checks, and establishing monitoring and remediation processes.
  • Experience delivering data migrations, including source-system assessment, source-to-target mapping, data cleansing, transformation, migration testing, and reconciliation.
  • Experience designing and building ETL/ELT pipelines to integrate data from multiple sources.
  • Knowledge of data modelling, including relational models, dimensional models, and curated analytical datasets.
  • Ability to write efficient SQL and use Python for data processing, automation, or validation.
  • Experience working with business stakeholders to define requirements, interpret data, and explain technical findings in practical business terms.
  • Ability to produce clear technical documentation, including mappings, data definitions, test evidence, and operational handover material.

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.

Desired Qualifications

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

About the Company

Ernst & Young

Global professional services: consulting, assurance, tax

EY (Ernst & Young) provides professional services at a global scale, offering consulting, assurance, tax, and transaction advisory services. It serves clients across industries such as technology, media, real estate, hospitality, and construction. Instead of selling a single product, EY works with clients through tailored engagements where cross-disciplinary teams analyze challenges, design strategies, perform audits, help with tax planning, and assist with mergers or divestitures. What sets EY apart is its worldwide reach and integrated service model, industry-specific expertise, and focus on responsible business practices like sustainability, cybersecurity, and workforce flexibility. EY’s goal is to help organizations improve performance, manage risk, and achieve sustainable growth while building a better working world.

Company size
5,001-10,000
Company stage
Not listed
Total funding
Not listed
Headquarters
Boston, MA
Founded
1991

Recently Posted Jobs

Explore more opportunities at Ernst & Young

See more jobs