Position Title: Data Engineer II Salary Range: $92,000-$105,800 Department: Information Technology Reports to: Data Engineering Manager 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 II 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. ● Design and develop secure, high performance, API’s to support data requests. ● Establish patterns for automation of forecasts, scoring, and support of ML/AI implementations. ● Establish patterns for publishing and distributing data sets. ● Establish 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:

● Extensive 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. ● 1+ years of data engineering experience developing and maintaining high availability systems.

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.