Hospital for Special Surgery is looking to solve the problem of designing, implementing, and automating data flows on premise and in the cloud, and to work with partners and vendors on data integration projects.
Requirements
- 3 years of experience with written ETL code in python and SQL.
- 1 year of experience with Utilizing AWS data engineer services including S3, Athena, Glue, Lambda, Kinesis, Lake Formation, Step Function, IAM, CloudWatch, CloudFormation and SageMaker.
- 1 year of experience with Big Data Technology Spark, Hadoop Hive and HDFS.
- 1 year of experience with Clinical Data Warehouse Caboodle and Caboodle Data Model.
- AWS Certified Solutions Architect.
- Experience with data integration projects.
- Experience with data modeling and data warehousing.
Responsibilities
- Design, implement, and automate data flows on premise and in the cloud.
- Work with partners and vendors on data integration projects.
- Design and create data models for new or existing data sources, including clinical data, operation data, patient reported outcome data, digital data, external claim data and other data.
- Assist in the administration and architecture of the analytics Data Lake in the cloud.
- Assist in the resolution of production issues and their root cause analysis.
- Design, implement, secure and QA cost efficient technical solutions in AWS.
- Deploy solutions in production using analytics and info security DevOps pipeline using the AWS Services Service Catalog.
Other
- Master’s degree in Computer Science, Business Analytics, and Information Systems or a related field.
- 3 years of experience in the job offered or a related occupation.
- Must be eligible for additional benefits consistent with the role.
- Must be willing to work in a fast-paced environment and prioritize tasks effectively.
- Must have excellent communication and interpersonal skills.
