Über
Full Time - Data Engineer - S4CH
role at
Sun River Health .
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 OpenFlow to build reliable, automated data pipelines.
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 OpenFlow to 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
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.
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.
Collaborate closely with 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:
$1,500
Reports To:
AVP Data and Software Engineering
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.
Essential Duties And Responsibilities
Knowledge of database coding and tables; general database management.
Client management, support, and communicating progress and timelines.
Organizes and/or leads Informatics projects implementing new data warehouse tools and systems.
Train new hires and lead training of new client staff members.
Understand data schema and analyze database performance and accuracy.
Understand ETL tools, OLAP design, and data quality processes.
Knowledge of BI life cycle: planning, design, development, validation, deployment, documentation, and ongoing support.
Working knowledge of electronic medical records software (eCW, NextGen, etc.) and backend storage.
Generate probability modeling and statistics related to healthcare outcomes and financial risks.
Manage lengthy and complicated projects throughout the life cycle and meet deadlines.
Development, maintenance, technical support of various reports and dashboards.
Knowledge of Microsoft SQL: coding, tables, stored procedures, query design.
Fundamental understanding of outpatient healthcare workflows.
Knowledge of relational database concepts and flat/formatted file processing.
Commitment to data validation processes to ensure accurate reporting (internal quality control).
Firm grasp of patient confidentiality and system security practices to prevent HIPAA violations.
Knowledge of IBM Cognos or other reporting software such as SAS, SPSS, and Crystal Reports.
Meet the needs of other Informatics department members 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.
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 grew 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 through a merger with Brightpoint Health, enhancing our services and continuing 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
Medical, Dental and Vision Insurance.
Life and Disability Coverage.
Retirement Savings Plan.
Commuter and Transit Benefits.
Employee Assistance Program (EAP).
Employee Discount Program.
Provider Incentive Compensation Program.
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 [contact email]. Links to relevant projects, GitHub repositories, or example work are encouraged.
Equal Employment Opportunity Sun River Health provides equal employment opportunities to all qualified individuals without regard to race, creed, color, religion, national origin, age, sex, marital status, sexual preference, or non-disqualifying physical or mental handicap or disability in each aspect of the human resources function.
Americans with Disabilities Act Applicants as well as employees who are or become disabled must be able to perform the essential job functions either unaided or with reasonable accommodation. The organization shall determine reasonable accommodation on a case-by-case basis in accordance with applicable law.
Seniority level Mid‑Senior level
Employment type Full‑time
Job function Information Technology
#J-18808-Ljbffr
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klick auf „Jetzt Bewerben”, um deine Bewerbung direkt auf deren Website einzureichen.