Senior Data Engineering Specialist

Who We Are:

The Association of American Medical Colleges is a not-for-profit association dedicated to transforming health care by supporting the entire spectrum of medical education, medical research, and patient care conducted by our member institutions. We are dedicated to the communities we serve and steadfast in our goal to improve the health of all.

At the AAMC, we are committed to supporting our employees with a comprehensive and competitive benefits package designed to promote well-being, professional development, and work-life balance.

• Hybrid Work – Primarily remote roles with the ability to work across the U.S.

• Comprehensive Health & Wellness – Medical, dental, and vision coverage; wellness programs; and fitness reimbursement

• Generous Time Away – Paid time off, holidays, personal days, sick leave, paid parental leave and short‑ and long‑term disability benefits.

• Retirement & Financial Well-Being – 403(b) retirement plan with generous employer contributions and financial planning resources

• Family & Care Support – Backup care for children, elders, and pets, plus resources for families with specialized needs
• Learning & Purpose: Tuition reimbursement, professional learning and development opportunities and the chance to advance a meaningful mission.

Additional information can be found on our website.

Why us, why now?

Works in a data warehouse environment which includes data design, database architecture, metadata and/or repository creation. Reviews data loaded into the data warehouse for accuracy. Responsible for the development, maintenance, and support of an enterprise data warehouse system and corresponding data marts. Evaluates existing subject areas stored in the data warehouse. Incorporates existing subject areas into an enterprise model. Troubleshoots and tunes existing data warehouse applications. Conducts research into new data warehouse applications and determines viability for adoption. Assists in establishing development standards. Creates new or enhanced components of the data warehouse. May design, implement, and maintain complex databases with respect to JCL, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods. May analyze organization business processes and systems (financial, logistical, human resources, etc.) and automate/optimize processes through a third party enterprise resource planning system (ERP - e.g. SAP, PeopleSoft, Oracle). Works independently to create, update, implement and model best practices. Leads projects or project steps of varying size and has accountability for ongoing activities related to projects, programs and/or operations. Applies in-depth professional level knowledge to independently solve a full range of complex problems and offers sensible solutions. Acts as a resource for colleagues with less experience. Represents team in meetings with other work units. Serves as a reliable resource for management.

How you will make an impact?

Design and Maintain Scalable Data Pipelines:

• Architect, develop, and manage robust and scalable ETL/ELT data pipelines to ensure accurate, timely, and reliable data flow across systems, enabling effective downstream data utilization, analytics and reporting.

Develop and Optimize Data Architecture:

• Build and refine data models, warehouses, and Lakehouse architectures to support efficient data storage, processing, and retrieval, aligning with enterprise data strategies.

Ensure Data Quality and Integrity:

• Implement validation frameworks, monitoring, and testing strategies to ensure data consistency, completeness, and reliability across all stages of the data lifecycle.

Collaborate with Cross-Functional Teams:

• Partner with peer development teams, analysts, product managers, and business stakeholders to understand data needs and deliver solutions that support decision-making and innovation.

Lead Technical Implementation of Data Projects:

• Identify opportunities to automate repetitive operational tasks to improve efficiency, while staying informed of new features in cloud and on-premise data platforms such as Snowflake, AWS Glue, and Airflow.
• Suggest and contribute to process improvements in pipeline design, monitoring, and alerting, and actively participate in training and cross-skilling opportunities to strengthen technical expertise.

Manage Data Security and Compliance:

• Ensure data solutions comply with internal policies, adhering to security and governance controls where necessary.

Mentor and Guide Team Members:

• Provide technical leadership, coaching, and code reviews for junior engineers and peers to promote skill development and uphold engineering best practices.

What you will bring to the role

Required Qualifications:

Minimum Education: Bachelor’s degree in Computer Science, Data Engineering, or related field.

Minimum Experience of Related Work: 5 - 7 years of related work experience

• A minimum of five (5) years of progressively responsible experience in data engineering or a closely related field is required to independently perform the essential duties of this position.
• Minimum of 1 year hands-on experience working with AWS data services such as AWS Glue, Amazon S3, Lambda, and other related tools, as well as familiarity with Snowflake or similar cloud-based data warehousing solutions.
• Experience designing and building modern, scalable data pipelines in production environments.
• Experience contributing as part of cross-functional teams on data projects, collaborating with peers and stakeholders to deliver technical solutions.
• Familiarity with data governance and compliance best practices, with the ability to follow established frameworks.
• Experience working on ETL/ELT pipelines within large or complex data systems, ensuring data quality and reliability.
• Demonstrated ability to follow technical direction and contribute to ongoing platform and tooling improvements.

Preferred Experience:

• Designing and implementing modern, scalable data pipelines
• Leading technical projects or initiatives in cross-functional teams
• Mentoring junior engineers or contractors
• Adhering to data governance and compliance frameworks
• Contributing to long-term platform or tooling strategy
• Experience with large-scale ETL/ELT pipelines across complex data systems

Certifications: AWS/Snowflake certifications are preferred but not required.

Remote Work Eligibility

Compensation Grade Range

Multiple factors are taken into consideration to arrive at the final hourly rate/annual salary to be offered to the selected candidate. Factors may include, but are not limited to, the scope and responsibilities of the role, the selected candidate’s work experience, education and training, as well as internal equity, market, and business considerations.

If a bachelor’s degree is required, related work experience may be substituted in some positions. One year of college course work at an accredited institution is equivalent to one year of related work experience.

The AAMC is an Equal Opportunity Employer. The AAMC is committed to an Equal Employment Opportunity policy in recruitment, hiring, career advancement, and all other personnel practices. The AAMC will not discriminate on the basis of race, color, sex, national origin, religion, age, marital status, personal appearance, sexual orientation, gender identity or expression, family responsibilities, matriculation, political affiliation, genetic information, disability, past or current military service, or any other legally protected characteristic. The AAMC is committed to the full inclusion of all qualified individuals. As part of this commitment, the AAMC will ensure that people with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, perform essential job functions, and/or receive other benefits and privileges of employment, please contact the talent acquisition team.

Please attach a resume as part of the application process. It is important that files DO NOT include periods ( . ) within the file name.

BROWSER REQUIREMENTS: Applications must be submitted using Chrome, Mozilla Firefox, Safari, or Microsoft Edge.

About Us

The AAMC’s strong sense of community and professionalism fosters an environment that supports the career and personal goals of its staff. Through development opportunities, employee support and activity groups, and other resources, employees can work in an environment where innovation and new ideas are encouraged.

Established in 1876, the AAMC is a nonprofit association dedicated to improving the health of people everywhere through medical education, clinical care, biomedical research, and community collaborations. Its members are all 165 U.S. medical schools accredited by the Liaison Committee on Medical Education; 11 Canadian medical schools accredited by the Committee on Accreditation of Canadian Medical Schools; more than 400 academic health systems and teaching hospitals; and more than 70 academic societies. The AAMC also collaborates with the Department of Veterans Affairs (VA) and VA medical centers through their academic affiliations with AAMC-member institutions. Through these institutions and organizations, the AAMC leads and serves America’s medical schools, academic health systems and teaching hospitals, and the millions of individuals across academic medicine, including more than 220,000 full-time faculty members, 100,000 medical students, 167,000 resident physicians, and 60,000 graduate students and postdoctoral researchers in the biomedical sciences. Through the Alliance of Academic Health Centers International, AAMC membership reaches more than 60 international academic health centers throughout five regional offices across the globe.