Sun River Health · 1 month ago
Full Time - Data Engineer - S4CH
United States
Full-time
Remote
Mid Level
$100K/yr - $151K/yrSun River Health is a data-driven healthcare organization focused on modernizing their analytics platform for value-based care. They are seeking an experienced Data Engineer to design, build, and maintain data transformation and analytics pipelines in Snowflake, collaborating with data architects and integration engineers for optimized data management.
Health CareMedicalNon Profit
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
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
Qualification
Required
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
Benefits
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.
Company
Sun River Health
Sun River Health is a nonprofit firm that offers comprehensive healthcare, medical treatment, and programs for community wellness.
Founded in 1975
1001-5000 employees
H1B Sponsorship
Sun River Health has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (2)
2023 (3)
Funding
Current Stage
Late StageLeadership Team
James Sinkoff, MBA, CPA
Deputy Chief Executive Officer & CFO
Wanda V. Mitchell
Vice President of Planning/JEDI Special Avisor to CEO
Recent News
Company data provided by crunchbase