
Data Analyst or Engineer - Technology Consulting
Ernst and Young14 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.
About Ernst and Young
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.