- Analyze, design, and support enterprise data solutions using Snowflake and advanced SQL.
- Develop complex SQL queries, stored procedures, dynamic SQL, joins, and subqueries.
- Design and optimize Snowflake solutions using Dynamic Tables, Materialized Views, and Role-Based Access Control (RBAC).
- Perform data profiling, reconciliation, anomaly detection, and data quality analysis.
- Support enterprise data architecture and data warehouse initiatives, including dimensional modeling and Star/Snowflake schemas.
- Prepare and standardize data assets for AI, machine learning, and advanced analytics use cases.
- Analyze and validate healthcare data across claims, membership, provider, and health plan domains.
- Develop test plans and execute source-to-target validation, reconciliation, and data quality testing.
- Support data governance, metadata management, data cataloging, and MDM initiatives.