Associate Cloud Data Engineer

At ERC Pathlight, we’re on a mission to change lives—and we’re looking for people who feel called to do the same.

As one of the nation’s leading treatment providers for eating disorders and mood, anxiety, and trauma‑related conditions, we bring innovative, evidence‑based, and deeply compassionate care to patients across the country. With multiple locations nationwide and extensive virtual programming, we meet patients exactly where they are and help them move toward lasting recovery.

Founded in 2008 by renowned psychiatrists and psychologists, ERC Pathlight now supports more than 6,000 patients each year. And as the need for world‑class mental health care continues to rise, our commitment is stronger than ever: to expand access, elevate the standard of care, and empower every patient to rebuild their life with dignity and hope.

When you join ERC Pathlight, you become part of a team that shows up every day to make a real difference. You’ll work alongside passionate clinicians, dedicated support staff, and mission‑driven leaders who believe in collaboration, growth, and doing the right thing—always.

Here, your work matters. Your ideas matter.
You matter.

If you’re energized by purpose, motivated by impact, and ready to help transform the future of mental health treatment, you belong here.

Come build hope. Come save lives. Come grow with us.

** This position requires current, unrestricted authorization to work in the United States on a permanent basis. **

What you’ll be doing

The Associate Cloud Data Engineer supports the design and development of scalable data pipelines to ensure reliable, high‑quality data including the development of the Enterprise Data Management and Analytics (EDMA) across ERC Pathlight. Working alongside senior engineers and in collaboration with clinical, operational, and analytics teams, this role helps turn raw data into actionable insights that improve patient care and decision making.

As a key contributor to the Enterprise Data Warehouse (EDW), the Associate Cloud Data Engineer gains hands‑on experience advancing data infrastructure in support of evidence‑based treatment for mood, anxiety, and eating disorders.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Develop foundational knowledge in cloud‑based storage patterns, including Data Warehousing, Data Lakes (ADLS/Blob), Data Marts, and Operational Data Stores, while assisting in the implementation of scalable architectures like Medallion Architecture.
• Assist in designing and deploying end‑to‑end
  ETL/ELT workflows using enterprise tools such as
  Azure Data Factory (ADF), Informatica IICS, and AWS Glue
  to ingest data from diverse sources like Salesforce, REST APIs, and SQL databases.
• Apply modeling principles to build
  conceptual, logical, and physical designs, supporting the creation of schemas optimized for different workloads, such as Star, Snowflake, or Data Vault patterns for analytical environments.
• Work within the modern data stack to transform complex datasets using
  Databricks and Spark
  and learn to integrate data pipelines with the
  Azure AI stack (Azure ML, Synapse ML)to support downstream analytics.
• Contribute to the development of data quality frameworks, including profiling,
  validation, and cleansing, and implementing the Audit, Balance, and Control (ABC) framework to ensure data accuracy and completeness.
• Support the automation of the development lifecycle using
  Git for version control and CI/CD pipelines for automated deployment
  , while leveraging Azure Boards to track deliverables and project milestones.
• Implement security‑by‑design through
  encryption, tokenization, and data masking, ensuring all data pipelines and infrastructure comply with strict regulatory standards such as HIPAA, GDPR, and SOC 2.
• Monitor and troubleshoot cloud infrastructure to improve efficiency by performing cost tuning in ADF, optimizing SQL queries, and managing failure alerts to maintain high system reliability.
• Assist in implementing
  data cataloging and lineage tools such as MS purview, EDC/AXON
  to support
  discoverability and traceability, ensuring that metadata practices meet auditability and compliance requirements.
• Create high‑level design documents and…