Sr. Snowflake, dbt Data Engineer (Healthcare)

United States of America

Full Time

6 hours ago

No H1B

Key skills

SnowflakeSnowpipeStreamsVirtual WarehousesSnowflake performance tuningSnowflake clusteringSnowflake query optimizationSnowflake data modelingdbt Coredbt Clouddbt incremental modelsdbt snapshotsdbt macrosJinjadbt testingdbt documentationdbt lineagedbt deploymentMatillionMatillion Orchestration JobsMatillion Transformation JobsMatillion schedulingMatillion parameterizationMatillion error handlingMatillion environment promotionSQLSQL complex joinsSQL CTEsSQL window functionsSQL MERGE statementsSQL stored proceduresPythonPython ETL automationPython data validationPython API integrationsPython metadata processingPython pipeline utilitiesAWS S3AWS GlueAWS LambdaAWS IAMAWS CloudWatchGitCI/CDcode reviewsbranching strategiesautomated deployment pipelinesELT architecturedimensional modelingCDCincremental loadingdata reconciliationproduction supportOracleInformaticaEDWHealthcare provider domainEpic ClarityCaboodleCogito analytics platformsAIETLELTAnalyticsdbtAWSLambdaS3IAMCloudWatchGlueGitHub

About this role

Predactica™ is seeking a highly skilled Senior Data Engineer to support enterprise healthcare data modernization initiatives. The ideal candidate will have strong hands-on experience designing, developing, and optimizing cloud-native data platforms.

Responsibilities:

Support enterprise healthcare data modernization initiatives
Designing, developing, and optimizing cloud-native data platforms using Snowflake, dbt, Matillion, SQL, AWS, and Python

Requirements:

5+ years of hands-on experience with Snowflake including Snowpipe, Streams, Tasks, Virtual Warehouses, performance tuning, clustering, query optimization, and data modeling
Strong experience with dbt Core/dbt Cloud including incremental models, snapshots, macros, Jinja, testing, documentation, lineage, and deployment
Hands-on experience developing production data pipelines using Matillion (Orchestration Jobs, Transformation Jobs, scheduling, parameterization, error handling, and environment promotion)
Advanced SQL skills including complex joins, CTEs, window functions, MERGE statements, stored procedures, and query optimization
Strong Python experience for ETL automation, data validation, API integrations, metadata processing, and pipeline utilities
Experience with AWS services such as S3, Glue, Lambda, IAM, CloudWatch, and related cloud-native data services
Experience with Git, CI/CD, code reviews, branching strategies, and automated deployment pipelines
Strong understanding of ELT architecture, dimensional modeling, CDC, incremental loading, data reconciliation, and production support
Experience migrating legacy Oracle/Informatica/EDW environments to Snowflake
Healthcare provider domain experience with patient, provider, claims, clinical, or encounter data
Experience with Epic Clarity, Caboodle, or Cogito analytics platforms
Experience optimizing Snowflake workloads for performance, scalability, and cost
Exposure to AI-assisted development tools such as Snowflake Cortex, GitHub Copilot, or similar