Senior Data Engineer: WhereScape ETL & Data Migration Lead

Synechron; Auckland; On-site; NZD 120,000 - 180,000; Full time

Job summary

Synechron in Auckland seeks an experienced Senior Data Engineer to lead data migration, warehousing, and WhereScape ETL initiatives. You will design scalable ETL/ELT pipelines, migrate legacy data into modern data warehouses, and ensure data quality and performance across large-scale loads.

The role requires deep SQL, data modeling, and collaboration with architects, DBAs, and business stakeholders. You will mentor junior engineers and help set best practices for governance and release

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering or related discipline.
• 5+ years of experience in data engineering, ETL development, or data warehousing.
• Strong hands-on experience with WhereScape RED; exposure to WhereScape 3D is highly desirable.
• Proven experience delivering data migration projects involving legacy systems or warehouse modernization.
• Strong SQL and relational database knowledge (SQL Server, Oracle, PostgreSQL, Snowflake).
• Deep understanding of data warehousing concepts including dimensional modeling and star schemas.
• Experience with data profiling, cleansing, transformation, reconciliation, and validation.
• Strong knowledge of ETL/ELT architecture, batch processing, and data integration best practices.
• Ability to work with complex data structures and high-volume datasets.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Lead end-to-end data migration projects, including source analysis, data mapping, transformation, validation, reconciliation, and cutover support.
• Design, develop, and maintain ETL/ELT pipelines using WhereScape RED and related tools.
• Build and enhance enterprise data warehouse and data mart solutions to support reporting, analytics, and business intelligence.
• Analyze legacy source systems and define migration strategies for structured and semi-structured data.
• Work closely with business stakeholders, architects, DBAs, analysts, and developers to gather requirements and translate them into scalable technical solutions.
• Develop and maintain source-to-target mappings, transformation rules, and migration documentation.
• Ensure data quality, completeness, consistency, and reconciliation throughout migration and integration processes.
• Optimize ETL jobs, SQL queries, and database performance for large-scale data loads and ongoing operations.
• Support testing activities including unit testing, system integration testing, UAT, and production validation.
• Troubleshoot and resolve data integration, migration, and performance issues.
• Establish and promote best practices for ETL development, migration governance, release management, and operational support.
• Mentor junior data engineers and provide technical leadership across the data engineering team.

Skills

WhereScape RED

WhereScape 3D

SQL

Data warehousing

ETL/ELT

Data modeling

Data migration

Data quality

Stakeholder collaboration

Mentoring

Education

Bachelor’s degree in Computer Science, Information Systems, Engineering

Tools

Power BI

Tableau

Qlik

Job description

Synechron in Auckland seeks an experienced Senior Data Engineer to lead data migration, warehousing, and WhereScape ETL initiatives. You will design scalable ETL/ELT pipelines, migrate legacy data into modern data warehouses, and ensure data quality and performance across large-scale loads.

The role requires deep SQL, data modeling, and collaboration with architects, DBAs, and business stakeholders. You will mentor junior engineers and help set best practices for governance and release