Senior Data Engineer (Wherescape)

Synechron; Auckland; Presencial; NZD 120 000 - 180 000; Tempo integral

Resumo da oferta

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

Qualificações

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

Responsabilidades

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

Conhecimentos

WhereScape RED

WhereScape 3D

SQL

Data warehousing

ETL/ELT

Data modeling

Data migration

Data quality

Stakeholder collaboration

Mentoring

Formação académica

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

Ferramentas

Power BI

Tableau

Qlik

Descrição da oferta de emprego

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our Synechron Labs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,000+, and has 55 offices in 20 countries within key global markets. For more information on the company, please visit our website:www.synechron.com.

We are looking for an experienced Senior Data Engineer with strong expertise in data migration, data warehousing, and WhereScape ETL to lead the design, development, and delivery of enterprise data solutions. This role will be responsible for migrating data from legacy and heterogeneous source systems into modern data warehouse platforms, building scalable ETL/ELT pipelines, and ensuring high data quality, integrity, and performance.

The ideal candidate will have deep technical knowledge of WhereScape RED/3D, strong SQL and data modeling skills, and proven experience delivering complex data migration and transformation initiatives in enterprise environments.

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

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related discipline.
• 5+ years of experience in data engineering, ETL development, or data warehousing roles.
• Strong hands-on experience with WhereScape RED; exposure to WhereScape 3D is highly desirable.
• Proven experience delivering data migration projects involving legacy systems, warehouse modernization, or platform transitions.
• Strong expertise in SQL and relational databases such as SQL Server, Oracle, PostgreSQL, Snowflake, or similar.
• Deep understanding of data warehousing concepts, including dimensional modeling, star schemas, and historical data management.
• 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.

Preferred Qualifications

• Experience with cloud data platforms such as Azure, AWS, or Google Cloud.
• Familiarity with modern analytics and BI tools such as Power BI, Tableau, or Qlik.
• Experience with scripting languages such as Python, PowerShell, or Shell scripting.
• Knowledge of data governance, metadata management, audit controls, and compliance requirements.
• Experience working in Agile/Scrum delivery teams.
• Prior experience in large-scale enterprise transformation or modernization programs.

Key Skills

• WhereScape RED / WhereScape 3D
• Data migration strategy and execution
• ETL/ELT development
• SQL and database development
• Data warehousing and dimensional modeling
• Source-to-target mapping
• Data validation and reconciliation
• Performance tuning and optimization
• Stakeholder collaborationTechnical leadership and mentoring