Synectics for Management Decisions, Inc · 3 weeks ago
Senior Data Engineer - AWS Lakehouse
Washington D.C., DC, USA, 20233
Full-time
Hybrid
Mid, Senior Level
3+ years expSynectics for Management Decisions, Inc is seeking a Senior Data Engineer to help shape a modern, cloud-native data platform. The role involves designing and building scalable ETL/ELT pipelines and ensuring data quality across a large government agency's AWS-based Lakehouse project.
Health CareInformation TechnologySoftware
Responsibilities
Design and build scalable ETL/ELT pipelines from Oracle and other source systems into an AWS Lakehouse
Implement row-level updates using Apache Iceberg MERGE and UPDATE patterns
Own the lifecycle of Iceberg tables, including partitioning, schema evolution, compaction, and snapshot management
Develop batch and incremental ingestion workflows, including full extracts and CDC-based pipelines
Create and maintain processing and data marts that support editing, imputation, and data dissemination
Optimize query and catalog performance across Glue Catalog, Athena, EMR, and Spark
Ensure strong data quality, lineage, and governance across the platform
Collaborate closely with the Principal Data Architect to operationalize designs and continuously improve the platform
Qualification
Required
3–7 years of hands-on data engineering experience
Strong experience building on AWS, including S3, Glue, EMR, Athena, Lambda, and Step Functions
Deep, practical experience with Apache Iceberg, including: Partitioning, compaction, and schema evolution; Row-level operations (MERGE INTO, updates, deletes); Snapshot and table version management
Advanced SQL skills and strong experience with Spark (PySpark or Scala)
Must be AWS Certified
Proven ability to build and operate pipelines for large-scale (multi-TB) datasets
Solid understanding of batch, incremental, and CDC ingestion patterns
Experience implementing data quality checks and governance best practices
Solid communication skills. Able to work well with teams as well as independently
Preferred
Experience migrating from Oracle or other RDBMS platforms to cloud-native data architectures
Exposure to other Lakehouse formats such as Delta Lake or Apache Hudi
Familiarity with AI/ML-assisted data cleaning or imputation techniques
Experience working with government systems and architectures
Benefits
Health and Wellness Benefits
401k w/Company Matching
Professional Development Financial Support
PTO
Parental Leave
Company paid Basic Term Life and Short and Long Term Disability Coverages
Company
Synectics for Management Decisions, Inc
Synectics for Management Decisions is an information technology company specializing in software development and health IT solutions.
51-200 employees
H1B Sponsorship
Synectics for Management Decisions, Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (5)
2024 (4)
2023 (4)
2022 (1)
2021 (3)
2020 (4)
Funding
Current Stage
Growth StageLeadership Team
Ana Hirsbrunner
Chief Executive Officer
Roya Khodabakhshi
Chief Financial Officer
Company data provided by crunchbase