The Data Engineer for Solutions 4 Community Health (S4CH) designs, builds, and maintains data transformation and analytics pipelines in Snowflake, leveraging SQL, dbt, and Python. This remote, full-time role focuses on delivering scalable data solutions.
Responsibilities
- Develop and optimize advanced SQL queries and dbt models to transform and analyze data inside Snowflake
- Design, test, and sustain dbt models that translate raw data into actionable insights
- Design and oversee ETL and ELT pipelines using dbt, OpenFlow, and Python to process data across systems
- Enhance query performance, clustering, and cost efficiency within Snowflake
- Maintain data quality through dbt tests and validation frameworks to ensure accuracy and consistency
- Collaborate with data engineers, analysts, and architecture leads to translate requirements into scalable data transformations
- Document dbt models, data flows, and dependencies to support visibility and reuse
- Manage dbt and Python projects in Git with clean, modular, and testable development practices
- Collaborate with automation engineers to improve data ingestion and transformation workflows via OpenFlow
- Demonstrates knowledge of database coding and table design, along with general database management
- Understand client management processes and communicate progress and timelines accordingly
- Organize or lead informatics projects implementing or utilizing new data warehouse tools and systems
- Ability to train new staff and lead client staff training initiatives
- Understand data schema and analyze database performance and accuracy
- Understand ETL tools, OLAP design, and data quality processes
- Familiarity with the business intelligence life cycle including planning, design, development, validation, deployment, documentation, and ongoing support
- Working knowledge of electronic medical records software such as eCW or NextGen and their backend data storage
- Ability to generate probability modeling and statistics related to healthcare outcomes and financial risk
- Manage lengthy and complex projects through all life cycle stages and meet deadlines
- Develop, maintain, and provide technical support for reports and dashboards
- Knowledge of Microsoft SQL including table creation, stored procedures, and query design
- Fundamental understanding of outpatient healthcare workflows
- Knowledge of relational database concepts and flat or formatted file processing
- Strong commitment to data validation to ensure reporting accuracy
- Solid understanding of patient confidentiality and system security practices to prevent HIPAA violations
- Experience with IBM Cognos or other reporting tools such as SAS, SPSS, Crystal Reports
- Ability to support other Informatics team members to maximize efficiency and minimize end-user product complexity
Requirements
- 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
Technologies
- SQL
- dbt
- Python
- Snowflake
- OpenFlow
- Git
- AWS
- GCP
- Azure
- BigQuery
- Redshift
- Airflow
- SSIS
- IBM Cognos
- SAS
- SPSS
- Crystal Reports
- Microsoft SQL
- eCW
- NextGen
- Snowflake Cortex
Benefits
- Comprehensive medical, dental and vision insurance
- Life and disability coverage
- Retirement savings plan
- Commuter and transit benefits
- Employee assistance program with confidential support and resources
- Employee discount program for various products and services
- Provider incentive compensation program for quality and productivity
- License, certification, and DEA fee reimbursement
- Career advancement and professional development opportunities
- 401(k)
- Dental insurance
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Parental leave
- Referral program
- Retirement plan
- Tution reimbursement
- Vision insurance
About Solutions 4 Community Health (S4CH)
S4CH is a management services organization that helps community health centers and other safety-net providers operate with greater clarity, efficiency, and impact. We bring strategy, operations, and technology together on a single platform to help teams spend less time navigating systems and more time enhancing care.
S4CH originated from the community health center sector and understands what it takes to lead, grow, and sustain a mission-driven organization with limited resources. Our leadership team has guided the growth of a large FQHC network and brings firsthand experience of the challenges in this space.
Equal Employment Opportunity
S4CH provides equal employment opportunities to all qualified individuals without regard to race, creed, color, religion, national origin, age, sex, marital status, sexual orientation, or non-dis
