Snowflake Data Engineer
Role:
Data Engineer(Snowflake, DBT) Mode : Contract to hire / FulltimeCandidates must reside in or be willing to work from one of the following locations: Bismarck (ND), Fargo (ND), Grand Forks (ND), Minot (ND), Boise (ID), Burlington (IA), Lewiston (ME), Portland (OR), Renton (WA), Spokane (WA), Vancouver (WA), Salt Lake City (UT)4+ years of Advanced SQL scripting and programming
- 3+ years of Designing, building, and maintaining ETL /ELT pipelines
- 4+ years of demonstrating the ability to develop and to diagnose and resolve complex programming and system coordination issues
- 3+ years of experience with healthcare insurance data and systems with knowledge of claims, membership, and provider data (Facets preferred)
- 1+ years of experience with Blue Association / BSI programs, including building data submissions (NDW HIGHLY preferred) “Desirements” (BIG bonus points, please call out)
- Hands-on experience building NDW submissions
- Experience with Facets as a source system
- Experience with Greenplum/PostgreSQL, Snowflake, and/or SQL Server
- Root-cause analysis experience with data quality issues or submission errors (for example, resolving edits or rejects)
- Unix Bash or Korn shell scripting for batch process automation Specific technologies to be used
- SQL (Advanced) in any of these DBMS - Greenplum/PostgreSQL, Oracle, Snowflake, SQL Server – preferred Greenplum/PostgreSQL, Snowflake
- Batch scripting (intermediate) – Bash, Korn Shell, Python