FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Expertise in Snowflake SQL transformations, data engineering, and dimensional modeling is essential, along with a strong focus on data quality, auditability, and error handling in healthcare data environments.
Highest-signal resume keywords
Advanced Snowflake SQLDimensional Modeling ImplementationData Quality ChecksSource-To-Target MappingsHealthcare Payer/Provider Experience
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Snowflake SQLLayered TransformationsQuery TuningSCD Type 2Audit/Control LoggingError HandlingIncremental ProcessingTesting and DeploymentComplex Business RulesReconciliation
Soft Skills
TroubleshootingTechnical DocumentationClient Demonstrations
Tools & Technologies
Git
Industry Keywords
Data EngineeringData WarehousingAnalytics EngineeringHealthcareMember IdentityMPI
Tech Stack
Tools & technologiesSnowflakeSQL
About the role
Key responsibilities & impact- Build and optimize Snowflake SQL transformations across staging, curated and conformed layers
- Implement tables, views and transformation logic from approved models and source-to-target mappings
- Develop restartable, testable and supportable processing with auditability and error handling
- Implement patient/member matching logic, crosswalks and exceptions for duplicate, unmatched or conflicting records
- Build SCD Type 2 history, member-month outputs and current-state models
- Implement payer attribution across payer/plan, provider networks, PCPs and clinics and preserve monthly history
- Reconcile modeled attribution to source rosters and retain discrepancies and unassigned members
- Automate row-count, null, datatype, referential-integrity and schema-drift checks
- Build audit, balance and control logging, metrics, alerting and reconciliation evidence
- Troubleshoot defects, maintain technical documentation and participate in reviews, planning and client demonstrations
Requirements
What you’ll need- 7+ years in data engineering, data warehousing or analytics engineering with strong recent Snowflake delivery
- Advanced Snowflake SQL, layered transformations, query tuning and production troubleshooting
- Strong dimensional modeling implementation, including facts, dimensions, surrogate keys and SCD Type 2
- Experience with source-to-target mappings, complex business rules, incremental processing and reconciliation
- Hands-on data-quality checks, audit/control logging, error handling, Git, testing and deployment
- Healthcare payer/provider, MPI or member identity experience preferred