Description
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. The AAMC strives to make a positive impact not only in your career, but in your life. We offer a comprehensive benefits package which features: • Significant employer 403(b) contribution • Public transportation subsidy • Generous paid time off program • Tuition reimbursement • Wellness program that includes: discounted gym membership, onsite yoga and sponsored sports teams Why us, Why now? As a Data Engineer, you will help ensure the satisfaction of our users by analyzing and translating business and technical requirements into cloud-first data engineering solutions to achieve organizational objectives. This position will use an Agile methodology within the AWS environment to design, code, and test relational and non-relational databases, data integrations, interfaces, and transformations. This will involve applying practical knowledge of RESTful APIs, AWS Lambda, AWS CFT, scripting languages such as PL/pgSQL, SnowSQL, and Python, integration tools such as AWS DMS, AWS AppFlow, and AWS Glue, and data management technologies such as Oracle, Postgres, Dynamo, and Snowflake How will you make an impact? Design, develop, and maintain data pipelines Responsible for collaboratively designing and implementing ETL and data curation solutions for OLAP applications. Ensures database optimization, data integrity, consistency, security, and privacy. Design, develop, and maintain RESTful APIs Responsible for collaboratively designing and implementing APIs for internal and external access to operational and analytic data. Design and implement data management and storage solutions Create data management solutions for relational (Oracle, Postgres, Snowflake), and non-relational (Dynamo, S3) datastores. Create data models, process flows, monitoring and health check validations, recovery plans, rollback plans, DR solutions, etc. Apply cloud-first best practices to all data engineering activities and ensure the proper use of CFTs and CI/CD pipelines. Define and set up the required monitoring and transition it to data support teams. Employ an automated and innovative-first mentality for all tasks. Participate in upgrades to systems in production, as well as performance and load testing efforts Work with the operations team to upgrade outdated applications, systems, and servers. Participate in the planning for future upgrades and maintenance. Participate in performance and load testing efforts. What will you bring to the role? Required Qualifications: Bachelor’s Degree in Computer Science, Information Systems, or a related field, or equivalent work experience. 3-5 years of related work experience in Data Engineering Strong understanding of AWS, AWS Glue, AWS DMS, and RDBMS. Proficiency in development languages such as Java, Python, and SQL. Experience developing RESTful APIs. Excellent problem-solving and analytical skills. Excellent communication skills, both written and verbal Preferred Qualifications: Experience with Snowflake, Erwin, AWS Appflow, AWS Lambda, AWS CFT, AWS S3. Proficiency with Spark and R Remote Work Eligibility This position is eligible for remote work in the contiguous US Compensation Grade Range and Mid-Point Grade Range:$85,000.00 - $157,800.00/ Grade Mid-Point:$121,400.00 The above annual compensation range and mid-point are general guidelines. For candidates who meet the criteria, the AAMC's compensation philosophy is to target the midpoint of the salary range. Multiple factors are taken into consideration to arrive at the final hourly rate/annual salary to be offered to the selected candidate. Factors 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 Association of American Medical Colleges (AAMC) is an Equal Opportunity/Affirmative Action Employer. The AAMC is committed to the policy of an equal employment opportunity 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. 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. The AAMC’s (Association of American Medical Colleges) 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. The AAMC is a nonprofit association dedicated to improving the health of people everywhere through medical education, health care, medical research, and community collaborations. Its members are all 159 U.S. medical schools accredited by the Liaison Committee on Medical Education; 13 accredited Canadian medical schools; nearly 500 academic health systems and teaching hospitals, including Department of Veterans Affairs medical centers; and more than 70 academic societies. 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 201,000 full-time faculty members, 97,000 medical students, 158,000 resident physicians, and 60,000 graduate students and postdoctoral researchers in the biomedical sciences. Following a 2022 merger, the Alliance of Academic Health Centers International broadened participation in the AAMC by 70 international academic health centers throughout five regional offices across the globe. Learn more at aamc.org.
