Data Engineer

Data Engineering SpecialistSeattle, WA (Onsite) | Local candidates only as client interview will be in person.Day to Day Job Duties:Perform end-to-end datastore migrations from on-premises DataLake environments to AWS-hosted Lakehouse platforms as part of the migration factory team.Refactor and migrate existing data pipelines, including data extraction logic, transformation processes, and job scheduling.Execute large-scale data transfers while ensuring data integrity, completeness, reliability, and consistency between source and target and modernize legacy SQL and Apache Spark-based processing logic for Snowflake and Apache Iceberg environments.Analyze existing data usage patterns, business requirements, and downstream consumption to support the development and delivery of reusable data products.Design and build data reconciliation and validation frameworks to verify data accuracy during and after with business stakeholders, application teams, data owners, and technical teams to perform validation and obtain migration sign-off.Act as a technical liaison between migration, data engineering, application, infrastructure, and business teams throughout the migration lifecycle.Troubleshoot data pipeline, data transformation, performance, and migration-related issues and implement appropriate technical solutions.Optimize data pipelines and processing workloads to improve performance, scalability, and operational efficiency.Apply core data engineering concepts including Slowly Changing Dimensions (SCD Type 2), schema evolution, partitioning, clustering, normalization and denormalization, natural and surrogate keys, and data quality controls.Work with structured and semi-structured data formats including JSON, Avro, and Parquet.Follow established Software Development Life Cycle (SDLC), source-control, testing, deployment, and Continuous Integration/Continuous Deployment (CI/CD) practices.Adapt to new data technologies, migration tools, engineering standards, and workflows as required by the program.Collaborate effectively with geographically distributed and global delivery teams.Travel: No specific travel requirement has been identified for this position.Degree: Bachelor's degree in Computer Science, Information Technology, Engineering, or a related technical field, or equivalent work experience.