About Us

We’re a data-driven healthcare organization modernizing our analytics platform to power value-based care. Our team is transitioning from SQL Server to Snowflake as our cloud data warehouse and implementing dbt, Python, and OpenFlowto build reliable, automated data pipelines.

You’ll join a collaborative, high-skill data team that values maintainability, clarity, and thoughtful design — working alongside engineers who specialize in automation, SQL Server administration, and data architecture.

Position Overview

We’re seeking an experienced Data Engineer with strong SQL, dbt, and Python skills to design, build, and maintain our data transformation and analytics pipelines in Snowflake.
The ideal candidate has hands-on experience with modern ELT tools, data modeling, and cloud-based platforms — and brings a mindset of automation, testing, and documentation to every project. You’ll collaborate closely with our data architects and integration engineers to ensure data from OpenFlow pipelines is transformed into trusted, analytics-ready models for reporting and advanced analytics.

Job Type: Full-Time

Location: Remote

Salary: 100,000 - 151,000

Sign On Bonus: $1500

Reports To : AVP Data and Software Engineering

Essential Duties and Responsibilities:

Knowledge of database coding and tables; as well as general database management
Understanding of client management, support, and communicating progress and timelines accordingly
Organizes and/or leads Informatics projects in the implementation/use of new data warehouse tools and systems
Ability to train new hires; as well as lead in training of new client staff members
Understanding data schema and the analysis of database performance and accuracy
Understanding of ETL tools, OLAP design, and data quality processes
Knowledge of Business Intelligence life cycle: planning, design, development, validation, deployment, documentation, and ongoing support
Working knowledge of electronic medical records software (eCW, Nextgen, etc) and the backend storage of that data
Ability to generate effective probability modeling and statistics as it pertains to healthcare outcomes and financial risks
Ability to manage sometimes lengthy and complicated projects from throughout the life cycle and meet the deadlines associated with these projects
Development, maintenance, technical support of various reports and dashboards
Knowledge of Microsoft® SQL including coding language, creation of tables, stored procedures, and query design
Fundamental understanding of outpatient healthcare workflows
Knowledge of relational database concepts and flat/formatted file processing.
Possesses strong commitment to data validation processes in order to ensure accuracy of reporting (internal quality control)
Possesses a firm grasp of patient confidentiality and system security practices to prevent HIPAA and other security violations.
Knowledge of IBM Cognos® or other database reporting software such as SAS, SPSS, and Crystal Reports Ability to meet the needs of other members of the Informatics department to maximize efficiency and minimize complexity of end-user products

Requirements:

Education: Bachelor's Degree
Proven experience as a dbt Developer or in a similar Data Engineer role.
Expert-level SQL skills — capable of writing, tuning, and debugging complex queries across large datasets.
Strong experience with Snowflake or comparable data warehouse technologies (BigQuery, Redshift, etc.).
Proficiency in Python for scripting, automation, or data manipulation.
Solid understanding of data warehousing concepts , modeling, and ELT workflows.
Familiarity with Git or other version control systems.
Experience working with cloud-based platforms such as AWS, GCP, or Azure.

Preferred:

Experience working with OpenFlow or similar orchestration/ETL systems (Airflow, SSIS, etc.).
Familiarity with healthcare or clinical data models .
Experience with Snowflake Cortex , or other LLM platforms. Exposure to CI/CD pipelines or Infrastructure as Code concepts.

Key Responsibilities

Advanced SQL Development: Write and optimize complex SQL queries and dbt models for data transformation and analysis within Snowflake.
DBT Model Development: Build, test, and maintain dbt models that convert raw data into actionable insights.
ETL/ELT Pipeline Management: Design and manage efficient pipelines using dbt, OpenFlow, and Python to process and deliver data across systems.
SQL Performance Tuning: Optimize query performance, clustering, and cost efficiency in Snowflake
Data Quality Assurance: Ensure that transformed data meets accuracy and consistency standards through dbt testing and validation frameworks.
Collaboration: Work closely with data engineers, analysts, and architecture leads to translate data requirements into scalable transformations
Data Documentation: Maintain clear documentation for dbt models, data flows, and dependencies for ongoing visibility and reuse
Version Control: Manage dbt and Python projects in Git, following clean, modular, and testable development practices Automation Support: Partner with automation engineers to enhance data ingestion and transformation workflows through OpenFlow.

About Sun River Health

Sun River Health has a rich history of providing quality, affordable health care to communities in need. Founded in the early 1970s by four African American women in Peekskill, New York, the organization was established to address the lack of accessible health services in their community. With the help of a small federal grant, the first Sun River Health site opened its doors in 1975. Over the years, Sun River Health has grown into a comprehensive Federally Qualified Health Center (FQHC) system with over 45 locations, serving more than 250,000 patients across the Hudson Valley, New York City and Long Island. Our exceptional primary care practitioners, specialists and support staff are dedicated to delivering high-quality care to all individuals, regardless of their ability to pay. In December 2018, Sun River Health expanded its reach by merging with Brightpoint Health, an FQHC network offering integrated medical, behavioral and social support services in New York City. This merger allowed us to enhance our services and continue our mission under the unified name of Sun River Health.

Our Culture

At Sun River Health, we believe in fostering a culture of wellness, inclusivity and recognition. Our Workforce Wellness Program promotes staff wellness through ongoing challenges and activities, encouraging participation and rewarding engagement. We celebrate our staff's dedication and person-centered spirit through the Planetree Recognition Awards, which honor innovation, leadership and community spirit. We are committed to creating a supportive and collaborative work environment where all team members can thrive. Our values of respect, integrity and excellence guide our interactions with patients and colleagues alike, ensuring that everyone receives the care and support they deserve.

Benefits

At Sun River Health, we are committed to building a personal relationship with our team and supporting you in every way we can. We offer competitive compensation and a comprehensive benefits package for you and your family, including:

Medical, Dental and Vision Insurance: Comprehensive health coverage to ensure you and your family stay healthy.
Life and Disability Coverage: Financial protection for you and your loved ones in case of unforeseen circumstances.
Retirement Savings Plan: Plan for your future with our retirement savings options.
Commuter and Transit Benefits: Assistance with your daily commute to make your journey to work easier.
Employee Assistance Program (EAP): Access to confidential support and resources for personal and work-related issues.
Employee Discount Program: Enjoy discounts on various products and services as a valued member of our team.
Provider Incentive Compensation Program: Quality & Productivity. Professional License, Certification and DEA Fees Reimbursement.

Why Join Us

Play a key role in building a modern Snowflake-based data ecosystem from the ground up.
Collaborate with a small, highly skilled data team that values autonomy and craftsmanship.
Work daily with SQL, dbt, Python, and OpenFlow in a production environment.
Contribute to meaningful healthcare improvement through better data. Enjoy flexible work arrangements and ongoing professional development.

How to Apply

Please send your résumé and a brief note about your experience with SQL , dbt , and Python to .…
Links to relevant projects, GitHub repositories, or example work are encouraged.

Join us at Sun River Health and be part of an award-winning network of care that has been serving our communities since 1975. We are always looking for skilled and dedicated professionals to join our team and help us continue our mission of providing quality health care to all.

Sun River Health

Latest Jobs

Full Time - Data Engineer - S4CH