Data Engineering Specialist

Association of American Medical Colleges
paid time off, tuition reimbursement, 403(b), remote work
United States, D.C., Washington
655 K St Nw Ste 100 (Show on map)
Jan 08, 2025
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, orMicrosoft Edge.