Technical Lead / Technical Specialist – Snowflake & Advanced SQL

As a Technical Lead – Snowflake + SQL, you will be a part of an Agile team to design and build healthcare applications and implement new features while adhering to the best coding development standards.

Responsibilities: -

• Data profiling to identify primary keys and issues with the data.
• Write ETL to bring data onto the client Data Platform, de-duplicate data, create or update dimensional data structures, and produce use case-specific output.
• Interact with the Product team to understand and refine requirements.
• Interact with QA to address reported findings.
• Work individually and as a team to achieve goals.
• Take initiative to take on additional work if the present workstream slows down.
• Mentor junior team members and help to bring new team members in the team.

Experience: -

• 5 - 7 Years

Location: -

• Pune
• Chennai
• Bangalore
• Mumbai

Educational Qualifications: -

• Engineering Degree – BE/ME/BTech/MTech/BSc/MSc.
• Technical certification in multiple technologies is desirable.

Skills: -

Mandatory Skills: -

• SQL: Must be familiar with common table elements (CTEs), complex joins, and analytic and windowing functions
• Python
• 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 the 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 directions

Good to Have Skills: -

• Healthcare Industry (Payer experience)
• Data Modeling
• Python