Ernst and Young

Data Analyst or Engineer - Technology Consulting

Ernst and Young
Apply
14 days ago
Wellington, New ZealandSenior

Responsibilities

  • Analyse and profile source data for migration, reporting, and analytics.
  • Translate business requirements into source-to-target mappings, transformation rules, data models, and acceptance criteria.
  • Implement data quality rules, automated validation checks, monitoring, reporting, and remediation processes.
  • Investigate data quality issues and work with stakeholders to improve data 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.
  • Develop curated datasets, data products, and analytical outputs.
  • Apply version control, automated testing, documentation, and deployment practices.
  • Communicate findings, delivery progress, and data risks to technical and non-technical stakeholders.
  • Provide technical guidance and mentorship to junior analysts and engineers.

Requirements

  • Experience with data analysis and profiling, including SQL-based investigation of complex datasets.
  • Hands-on data engineering experience with Snowflake and/or Databricks; experience with both is advantageous.
  • Experience implementing data quality frameworks, automated validation, monitoring, and remediation processes.
  • Experience delivering data migrations, including source assessment, mapping, cleansing, transformation, testing, and reconciliation.
  • Experience designing ETL/ELT pipelines and data models, including relational, dimensional, and curated analytical datasets.
  • Proficiency with SQL and experience using Python for data processing, automation, or validation.
  • Ability to work with business stakeholders and explain technical findings in practical business terms.
  • Experience producing technical documentation such as mappings, data definitions, test evidence, and operational handover materials.
  • Experience with dbt, Fivetran, Coalesce, or comparable integration and transformation tools is advantageous.
  • Experience developing dashboards, reports, or semantic models using Power BI or similar tools is advantageous.
  • Familiarity with data governance, metadata management, data lineage, and data catalogues.
  • Experience with Snowflake Horizon Catalog and/or Databricks Unity Catalog is advantageous.
  • Experience with Microsoft Azure, AWS, or Google Cloud is advantageous.
  • Familiarity with Git, CI/CD, orchestration, automated data testing, migration rehearsals, cutover planning, and post-migration validation is advantageous.
  • The role values aptitude, attitude, and willingness to learn even where candidates do not meet every listed criterion.

Benefits

  • Flexible work arrangements and a hybrid Wellington office-based work arrangement.
  • Yearly wellness incentive.
  • Access to up to 8 additional weeks of flex leave per year.
  • Family-friendly policies including up to 26 weeks of gender-neutral paid parental leave.
  • Career development focused on future-ready skills and global experiences.
  • Inclusive and equitable recruitment experience with confidential workplace adjustments and support available.

Tech Stack

AWSAzureDatabricksdbtGitGoogle CloudPythonSnowflakeSQL

Categories

Data Engineering
Ernst and Young

About Ernst and Young

10,000+ employees

Ernst & Young (EY) provides audit/assurance, tax, consulting, strategy and transactions services to enterprises, financial institutions, and public‑sector clients. Structured as a global network of partner‑owned member firms, it sells professional services on a fee basis, including a dedicated Financial Services Organization for banking, insurance, and capital markets. Headquartered in London, EY was formed in 1989 from the merger of Ernst & Whinney and Arthur Young, and operates in 150+ countries.

Contact me