Data Engineer (Healthcare)

Vaiticka Solution is seeking a Data Engineer to join their Agile team focused on building healthcare applications. The role involves data profiling, ETL processes, and collaboration with product and QA teams to ensure the delivery of high-quality data solutions.

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 update or 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:

• SQL: Highly Skilled. Must be familiar with common table elements (CTEs), complex joins, and analytic & windowing functions
• Snowflake: Prefer candidates with real-world experience using Snowflake
• 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
• DBT: Prefer candidates with real-world DBT experience
• Healthcare Industry Experience: Some experience is required, preferably Payer experience
• Experience in Google Cloud Platform (GCP) using Spanner/BigQuery