Solutions 4 Community Health (S4CH) is 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 direct experience with modern ELT tools, data modeling, and cloud-based platforms — and brings a mindset of automation, testing, and documentation to every project. You will 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,940.07 to $126,175.08
- Sign-on bonus: $1,500 (conditions apply)
Essential Duties & 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 translating 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. Knowledge of database coding and tables as well as general database management
- Understanding 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 employees 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 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
- 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
S4CH offers competitive compensation and a comprehensive benefits package, including:
- Comprehensive medical, dental and vision insurance
- Life and disability coverage
- Retirement savings plan
- Commuter and transit benefits
- Employee assistance program (EAP) with access to confidential support and resources for personal and work-related issues
- Employee discount program for various products and services
- Provider incentive compensation program for quality and productivity
- Provider professional license, certification, and DEA fee reimbursement
- Opportunities for career advancement and professional development
About Solutions 4 Community Health (S4CH)
S4CH is a management services organization helping community health centers and other safety-net providers operate with greater clarity, efficiency, and impact. We bring strategy, operations, and technology together into a single platform to help teams spend less time navigating systems and more time improving care.
S4CH came out of the community health center world and knows what it takes to lead, grow, and sustain a mission-driven organization with limited resources. S4CH is led by a Board of Directors and a senior leadership team with a proven record of building and scaling community health infrastructure. Collectively, our leadership has guided the growth of a community health center system into one of the largest FQHC networks in the United States and brings a firsthand understanding of the challenges and opportunities community health centers face every day.
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 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.
Email application to [email protected].
Pay: $100,940.07 - $126,175.08 per year
Benefits:
- 401(k)
- Dental insurance
- Employee assistance program
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Parental leave
- Referral program
- Retirement plan
- Tuition reimbursement
- Vision insurance
Work Location: Remote
