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…