Senior Data Engineering Specialist

Association of American Medical Colleges•Washington DC, DC
•Remote

About The Position

The Senior Data Engineering Specialist works in a data warehouse environment involving data design, database architecture, metadata, and repository creation. The role reviews data loaded into the warehouse for accuracy and develops, maintains, and supports the enterprise data warehouse and corresponding data marts. It evaluates and incorporates subject areas into an enterprise model, troubleshoots and tunes data warehouse applications, researches potential applications, helps establish development standards, and creates or enhances warehouse components. The position may also involve designing, implementing, and maintaining complex databases or analyzing and optimizing business processes through enterprise resource planning systems. The specialist independently applies in-depth professional knowledge to solve complex problems, develop and implement best practices, and lead projects or project steps. The role provides technical guidance to colleagues, represents the team in cross-unit meetings, and serves as a resource for management. The position designs and maintains scalable ETL/ELT pipelines and data architectures, including warehouses and Lakehouse architectures. It implements data quality, validation, monitoring, and testing practices; collaborates with development teams, analysts, product managers, and business stakeholders; and contributes to automation, process improvement, and technical implementation of data projects. The specialist also supports data security and governance requirements and mentors team members through coaching and code reviews. This is a remote-eligible position. Candidates may reside in the contiguous United States, excluding California, Massachusetts, New York, and Oregon.

Requirements

  • Bachelor’s degree in Computer Science, Data Engineering, or a related field.
  • Five to seven years of related work experience; at least five years of progressively responsible experience in data engineering or a closely related field.
  • At least one year of hands-on experience with AWS data services such as AWS Glue, Amazon S3, and Lambda, and related tools.
  • Familiarity with Snowflake or a similar cloud-based data warehousing solution.
  • Experience designing and building modern, scalable data pipelines in production environments.
  • Experience contributing to data projects on cross-functional teams and collaborating with peers and stakeholders to deliver technical solutions.
  • Familiarity with data governance and compliance best practices and the ability to follow established frameworks.
  • Experience with ETL/ELT pipelines in large or complex data systems, ensuring data quality and reliability.
  • Ability to follow technical direction and contribute to ongoing platform and tooling improvements.

Nice To Haves

  • Experience designing and implementing modern, scalable data pipelines.
  • Experience leading technical projects or initiatives in cross-functional teams.
  • Experience mentoring junior engineers or contractors.
  • Experience adhering to data governance and compliance frameworks.
  • Experience contributing to long-term platform or tooling strategy.
  • Experience with large-scale ETL/ELT pipelines across complex data systems.
  • AWS or Snowflake certifications; preferred but not required.

Responsibilities

  • Design, develop, and manage robust, scalable ETL/ELT pipelines that provide accurate, timely, and reliable data flow for downstream analytics and reporting.
  • Build and refine data models, warehouses, and Lakehouse architectures to support efficient data storage, processing, and retrieval in alignment with enterprise data strategies.
  • Review data loaded into the data warehouse for accuracy and implement validation, monitoring, and testing strategies to ensure data quality and integrity.
  • Develop, maintain, and support the enterprise data warehouse and corresponding data marts.
  • Evaluate existing data warehouse subject areas and incorporate them into an enterprise model.
  • Troubleshoot and tune existing data warehouse applications; research new applications and assess their viability for adoption.
  • Create or enhance data warehouse components and assist in establishing development standards.
  • Collaborate with peer development teams, analysts, product managers, and business stakeholders to understand data needs and deliver solutions.
  • Lead the technical implementation of data projects and identify opportunities to automate repetitive operational tasks.
  • Contribute to improvements in pipeline design, monitoring, and alerting, and stay informed about features in cloud and on-premise data platforms.
  • Ensure data solutions comply with internal policies and applicable security and governance controls.
  • Provide technical leadership, coaching, and code reviews for junior engineers and peers.
  • Lead projects or project steps and take accountability for ongoing activities related to projects, programs, or operations.
  • Work independently to create, update, implement, and model best practices; represent the team in meetings with other work units and serve as a resource for management.
  • May design, implement, and maintain complex databases, including their access methods, performance, allocation, validation, organization, security, documentation, and statistical methods.
  • May analyze business processes and systems and automate or optimize processes through a third-party ERP system.

Benefits

  • Medical, dental, and vision coverage
  • Wellness programs and fitness reimbursement
  • Paid time off, holidays, personal days, and sick leave
  • Paid parental leave
  • Short- and long-term disability benefits
  • 403(b) retirement plan with employer contributions
  • Financial planning resources
  • Backup care for children, elders, and pets
  • Resources for families with specialized needs
  • Tuition reimbursement
  • Professional learning and development opportunities
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service