Senior Data Engineer

Silver Hill Hospital; New Canaan (CT); On-site; USD 110,000 - 150,000; Full time

Job summary

An established industry player in mental health care is seeking a Senior Data Engineer to architect and optimize data infrastructure. This role involves ensuring seamless data flow from various sources, supporting clinical operations, and enhancing marketing initiatives. You will design scalable ETL/ELT pipelines, manage data warehouses, and ensure compliance with data governance standards. The ideal candidate will have a strong background in cloud data platforms, particularly Google BigQuery, along with experience in the mental health sector. Join a dynamic team and make a significant impact on patient engagement and operational efficiency.

Qualifications

• 5+ years of experience in Data Engineering with a focus on healthcare datasets.
• Deep expertise in data infrastructure tools and cloud platforms.

Responsibilities

• Design and maintain scalable ETL/ELT pipelines for mental health data.
• Ensure high performance of BigQuery environments through optimization.

Skills

SQL

Python

Google BigQuery

ETL/ELT pipelines

Data governance

Data visualization tools

Collaboration skills

Education

Bachelor’s degree in Computer Science

Master’s degree in Data Engineering

Tools

Fivetran

Spark

dbt

Airflow

Salesforce

HubSpot

Google Analytics

Job description

Join to apply for the Senior Data Engineer role at Silver Hill Hospital

5 days ago Be among the first 25 applicants

Join to apply for the Senior Data Engineer role at Silver Hill Hospital

Get AI-powered advice on this job and more exclusive features.

The Senior Data Engineer architects and optimizes data infrastructure to support both clinical operations and marketing initiatives, ensuring seamless data flow from EHRs, patient records, and digital marketing platforms. This position enables personalized patient engagement, compliance reporting, and ROI analysis for outreach campaigns. This position requires deep expertise in Google Big Query, ETL/ELT pipelines, and data warehousing, coupled with experience in the Mental Health Hospital sector and familiarity with marketing systems (CDPs, CRMs, campaign analytics). The Senior Data Engineer reports to the Director of IT.

Duties/Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines in Google BigQuery for mental health data, including EHRs, claims, and IoT sources.
• Architect and manage data warehouses using dimensional modeling techniques (star schema, data vault).
• Ensure high performance of BigQuery environments through query optimization, partitioning, and cost control strategies.
• Ingest and integrate data from Meditech, Health Cloud, HL7/FHIR streams, and digital marketing platforms (Salesforce, HubSpot, Google Analytics).
• Develop real-time data pipelines using technologies like Kafka, Spark, Fivetran, and Supermetrics.
• Implement and maintain strict data governance practices ensuring HIPAA, GDPR, and 42 CFR Part 2 compliance.
• Maintain data lineage, metadata management, and audit trails across systems involving PHI.
• Integrate CRM/CDP data with clinical systems to enable targeted patient outreach and personalization.
• Support marketing attribution models (multi-touch, MMM) and campaign ROI tracking.
• Analyze marketing and operational data to derive insights on patient acquisition costs, lifetime value, and engagement.
• Collaborate cross-functionally with IT, clinical teams, and marketing stakeholders to align data strategies with organizational goals.
  
  

Required Skills/Abilities

• Must have the ability to function optimally in a stressful environment, and the ability to remain calm in emotionally charged situations..
• Proficient in Microsoft Office applications.
• Strong proficiency in SQL, Python, and data infrastructure tools (BigQuery, Fivetran, Spark, dbt, Airflow).
• Experience with CDPs, CRMs, and marketing analytics platforms.
• Knowledge of data security standards including HIPAA, GDPR, and CCPA.
• Familiarity with data visualization tools like Looker or Tableau.
• Excellent communication and collaboration skills, especially across interdisciplinary teams.
  
  

Education And Experience

• Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or a related field.
• Minimum of 5 years of experience in Data Engineering, with a strong focus on cloud data platforms and healthcare datasets.
• Experience working in or with mental health or behavioral healthcare organizations is strongly preferred.
  
  

Physical Requirements

• Ability to move light objects weighing less than 20 pounds for short distances.
• Ability to sit at a desk and walk around for different periods of time.
• Ability to occasionally work beyond regular business hours or on weekends to resolve critical issues, as needed.
  
  

All qualified candidates will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national or ethnic origin, age, disability, veteran status or any other characteristic protected by law.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Mental Health Care

Referrals increase your chances of interviewing at Silver Hill Hospital by 2x

Sign in to set job alerts for “Senior Data Engineer” roles.

Azure Cloud Data Architect - Purchase NY, Morristown NJ, Charlotte NC (Hybrid)

Bridgeport, CT $119,400.84-$199,001.41 7 months ago

Azure Cloud Data Architect - Purchase NY, Morristown NJ, Charlotte NC (Hybrid)

Port Washington, NY $91,000.00-$172,000.00 1 day ago

Stamford, CT $131,175.00-$218,625.00 1 week ago

Tech Consulting - Cybersecurity - SIEM/SOAR Engineering - Senior

Tech Consulting - Cybersecurity - SIEM/SOAR Engineering - Senior

Purchase, NY $100,000.00-$167,500.00 1 week ago

White Plains, NY $93,600.00-$163,800.00 1 week ago

Rye, NY $125,000.00-$135,000.00 1 week ago

Greenwich, CT $25,000.00-$175,000.00 2 weeks ago

Rye, NY $125,000.00-$135,000.00 2 months ago

Senior Associate, Data Insights Engineer

Stamford, CT $140,000.00-$160,000.00 3 weeks ago

Senior Data Science Workbench Analyst (Engineer) - Databricks or Snowflake

Fairfield County, CT $130,000.00-$150,000.00 1 day ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.