Position Title: Data Engineer I

Salary Range: $80,000-$92,000

Department: Information Technology

Reports to: Manager, Data Engineering

Location: Remote

Schedule: (Overnight and Weekend)

Formerly the Mental Health Association of New York City (MHA-NYC), Vibrant Emotional Health's groundbreaking solutions have delivered high quality services and support, when, where and how people need it for over 50 years. Through our state-of-the-art technology-enabled services, community wellness programs, and advocacy and education work, we are building a society in which emotional wellness can be a reality for everyone.

Position Summary:

The Data Engineer I is responsible for the development of data pipelines, the orchestration and planning of data transformations and the development and support of data automations. This role interfaces with the Analytics and Research team around the design of data points, measures, and the implementation of models; with Data Governance roles around the alignment of policy and definitions with their implementation; and with Dev Ops, Security and Software Development teams around the broader organization's use of data infrastructure. This role focuses on providing weekend and overnight support to key stakeholders.

Duties/Responsibilities:

• Develop patterns for data ingestion using Fivetran, AWS Lambda, and related technologies.
• Orchestrate data transformations using DBT, database functions, materialized views and similar patterns.
• Write tests, integrity checks, conduct performance monitoring and tuning of data systems.
• Write anomaly detection routines to support alerting and monitoring.
• Implement patterns for publishing and distributing data sets.
• Implement and maintain archiving and retention schedules.
• Ensure data systems conform with data governance and data security best practices.
• Support automated reporting functions.
• Deploy and support reporting platform.

Required Skills/Abilities:

• Experience building and supporting data infrastructure.
• Direct experience working with Snowflake, DBT and Fivetran.
• Strong experience with AWS services such as Data Migration Services, RDS, Lambda, API Gateway, S3, etc.
• Expert knowledge of SQL / PSQL.
• Ability to code in Python and R (additional languages a +)
• Strong track record of managing high availability systems.
• Initiative to solve complex problems; takes an outside in perspective to identify innovative solutions.
• We value candidates who have demonstrated commitment to the goal of working with people to achieve mental and emotional wellbeing with dignity and respect.

Required Qualifications:

• Bachelors' or Masters' Degree in an analytics or engineering focused discipline or equivalent experience and knowledge.

Excellent comprehensive benefits, including medical, dental, vision, supplemental income insurance, pre-tax transit/parking, pre-tax FSA for medical and dependent care, and 401K available. 4 weeks' vacation, plum benefits, etc.

Studies have shown that women and people of color are less likely to apply for jobs unless they believe they are able to perform every task in the job description. We are most interested in finding the best candidate for the job, and that candidate may be one who come from a less traditional background. Vibrant will consider any equivalent combination of knowledge, skills, education and experience to meet minimum qualifications. If you are interested in applying, we encourage you to think broadly about your background and skill set for the role.

Vibrant Emotional Health is an equal opportunity employer. Applicants are considered for positions without regard to veteran status, uniformed service member status, race, creed, color, religion, gender, gender identity, sex, sexual orientation, citizenship status, national origin, marital status, age, physical or mental disability, genetic information, caregiver status or any other category protected by applicable federal, state or local laws.