Technical Specialist - II_Snowflake

JD: Data Engineer, • Data profiling to identify primary keys and issues with the data. • ETL to bring data onto the Cambia 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 • Other similar or related activities. 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. Specific technologies to be used and level of proficiency? • • DBT: Prefer candidates with real-world DBT experience. • Healthcare Industry Experience: Some experience is required, preferably Payer experience.