About the Role
As a Data Engineer, you will strengthen VillageCare's cloud data foundation by advancing reliable, secure data movement and analytics-ready datasets in our AWS environment. This role exists to ensure stakeholders can trust and use data to support care and operations.
Responsibilities
- Design, build, and support ELT/ETL pipelines and datasets within an AWS Data Lake
- Monitor and tune AWS data lake services; troubleshoot analysis tooling in the cloud environment
- Build Python-based ETL jobs; develop light internal web tools as needed
- Model current and future schemas for structured/unstructured data; align to industry standards
- Provide technical oversight across vendors; partner with IT Security/Network Ops on AWS best practices
- Contribute to integration project scoping and new pipeline/component design
Requirements
- AWS (2+ yrs)
- SQL (5+ yrs)
- Python (2+ yrs)
- Postgres/MySQL (2+ yrs)
- Redshift (2+ yrs)
- Healthcare data experience (2+ yrs)
- Awareness of Provider/Payer/Member domains
- AWS Glue, Spark, Lambda/API Gateway, containers, Git, Jira
- Review overnight pipeline health and AWS service metrics
- Confirm priorities with project partners and vendor teams
- Iterate on a new dataset, validate transformations, or refine a schema
- Field targeted questions from end users, translating business needs into concrete technical decisions
- Document choices so others can follow the logic
- Join a working session with Security and Network Operations to align on cloud requirements
- Update Jira items and push well-tested changes through GitHub
Skills
- AWS
- SQL
- Python
- Postgres
- MySQL
- Redshift
- AWS Glue
- Spark
- Lambda
- API Gateway
- Containers
- Git
- Jira
Location
- Hybrid (Must Reside in NY/NJ/CT)
Work Type
- Hybrid
- Monday - Friday, 9:00am - 5:00pm
Experience Level
- 2+ years AWS
- 5+ years SQL
- 2+ years Python
- 2+ years Postgres/MySQL
- 2+ years Redshift
- 2+ years Healthcare data experience
Education Level
- Bachelors Degree in technical field (Computer Science, Management Information Systems, Statistics or analytics)
- Masters preferred
Salary/Compensations
- $118,135.58 - $132,902.53
About the Company
- VillageCare is a community-based, not-for-profit organization serving people with chronic care needs, as well as seniors and individuals in need of continuing care and managed care services.
- Our mission is to promote healing, better health and well-being to the fullest extent possible.
- Our care is offered through a comprehensive array of community and residential programs, as well as managed care.
- VillageCare has delivered quality health care services to individuals residing within New York City for over 45 years.
