Data Engineer- (Advance SQL + Snowflake)

Data Engineer- (Advance SQL + Snowflake) Location: 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 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

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 VeeRteq Solutions is an Equal Opportunity Employer