.jpeg)
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.
What We Do
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.
The AAMC serves a vital purpose as the nation’s voice for America’s medical schools and teaching hospitals. These institutions play a crucial role in our nation’s health care by training the next generation of doctors, discovering new medical knowledge, and providing superior clinical care. The work of the AAMC and its employees leads and serves our member institutions and constituents.
