Note: The job is a remote job and is open to candidates in USA. Vaiticka Solution is a company focused on building healthcare applications, and they are seeking a Data Engineer to join their Agile team. The role involves data profiling, ETL processes, testing, and collaboration with product and QA teams to enhance application features.

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

Skills

• 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
• Prefer candidates with real-world experience using Snowflake
• Prefer candidates with real-world DBT experience
• Some experience is required, preferably Payer experience
• Experience in Google Cloud Platform (GCP) using Spanner/BigQuery

Company Overview