Data Engineer - Snowflake

Job Title Data Engineer

Location - Onsite - Bismarck - North Dakota/ Boise Idaho/Burlington Iowa/Fargo - North Dakota/Grand Forks- North Dakota/Lewiston - Maine/Minot - North Dakota/ Portland - OR/ Renton - Washington/ Spokane Washington/ Salt Lake City UT/ Vancouver - Washington

Experience 7-12 years

As a Data Engineer, you will be a part of an Agile team to build healthcare applications and implement new features while adhering to the best coding development standards.

Responsibilities: -

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

What we're looking for

Educational Qualifications: -

Engineering Degree BE / ME / BTech / M Tech / B.Sc. / M.Sc.

Technical certification in multiple technologies is desirable.

Good to have skills: -

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