Senior Data Engineer with DBT and SQL

Dice is the leading career destination for tech experts at every stage of their careers. Our client, E-Solutions, Inc., is seeking a Senior Data Engineer to be part of an Agile team building healthcare applications and implementing new features while adhering to best coding standards.

Responsibilities:

• Data profiling to identify primary keys and issues with the data
• ETL to bring data onto the client's Data Platform, de-duplicate data, create or update dimensional data structures, and produce use case-specific output
• Unit testing, functional testing, and performance testing and tuning
• Interacting with the Product team to understand and refine requirements
• Interacting with QA to address reported findings
• Working individually and as a team to achieve our goals
• Taking initiative to take on additional work if the present work stream slows down

Requirements:

• 12+ Years of experience
• SQL: Highly Skilled. Must be familiar with common table elements (CTEs), complex joins, and analytic & windowing functions
• Data Profiling: Must be able to identify unique and primary keys and determine cardinality, data type, precision, and scale, and skew
• Effective communication skills to communicate internally within our team and externally across other teams, notably Product and QA
• Understands the scope and context of the work and takes initiative to achieve the goals, rather than waiting to take specific direction
• Snowflake: Prefer candidates with real-world experience using Snowflake
• DBT: Prefer candidates with real-world DBT experience
• Healthcare Industry Experience: Some experience is required, preferably Payer experience
• Experience in Google Cloud Platform (Google Cloud Platform) using Spanner/BigQuery