Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Synechron

Senior Data Engineer (Wherescape)

Posted Updated

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

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

Skills

What Senior Data Engineering jobs ask for — and how much of it you have →
Apply

See also

Data Engineering jobs by country — openings, pay and top skills →