Senior Data Analyst – Snowflake & Healthcare Data
Description:
We are seeking a Senior Data Analyst with strong expertise in Snowflake, advanced SQL, healthcare data, data architecture, and data quality to support enterprise-scale data initiatives.
In this role, you will help design and prepare trusted, high-quality data assets for advanced analytics and AI use cases, working across complex healthcare data domains. The ideal candidate combines strong technical capabilities with analytical thinking, business acumen, and the ability to collaborate with technical and business stakeholders.
Responsibilities:
- 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.
- Develop and maintain source-to-target mappings, data lineage, metadata, and integration patterns.
- 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.
- Monitor data quality and contribute to scorecards, automated testing frameworks, defect tracking, and resolution.
- Support data governance, metadata management, data cataloging, and MDM initiatives.
- Gather and translate business requirements into effective data solutions.
- Collaborate with technical teams, business stakeholders, and cross-functional partners to identify and resolve data issues.
- Communicate analytical findings and data insights effectively through data storytelling and clear business recommendations.
- Ensure data solutions follow applicable security, governance, and healthcare data requirements, including HIPAA awareness.
Your Qualifications
- 7+ years of experience working with databases.
- 3+ years of hands-on Snowflake experience.
- Expert-level SQL development skills, including complex queries, dynamic SQL, stored procedures, reconciliation, and data profiling.
- Strong knowledge of Snowflake Dynamic Tables, Materialized Views, RBAC, data governance, and security.
- Experience with enterprise data architecture and data warehouse design.
- Strong knowledge of dimensional modeling, Star/Snowflake schemas, source-to-target mapping, data lineage, metadata management, and MDM concepts.
- Experience preparing and standardizing data for AI and advanced analytics.
- Strong experience working with healthcare data, including:
- Claims: Professional, institutional, medical, pharmacy, encounter, and adjudication data.
- Membership: Enrollment, eligibility, coverage history, benefits, population health, and member attribution.
- Provider: Directories, contracting, networks, NPI, attribution, and provider hierarchies.
- Health Plans: Benefits, products, groups, employers, consumer and commercial products, Medicare Advantage, Medicaid, and ACA Marketplace.
- Experience with data quality and testing, including completeness, accuracy, consistency, timeliness, validity, and uniqueness.
- Experience developing test plans, reconciliation testing, source-to-target validation, automated testing, data quality monitoring, and scorecards.
- Knowledge of data governance frameworks, data catalogs, metadata management, and HIPAA.
- Strong business analysis and requirements-gathering skills.
- Excellent stakeholder management, communication, problem-solving, and cross-functional collaboration skills.
- Ability to translate complex data concepts into clear, actionable business insights.
Metova Talent is interested in every qualified candidate who is eligible to work and reside in the United States. However, we will not consider applicants who are not U.S. citizens, U.S. nationals, lawful permanent residents, asylees, or refugees.
Metova Talent is an Affirmative Action and Equal Opportunity Employer.
*Notice to Third Party Recruitment Agencies:
Please note that Metova Talent does not accept unsolicited resumes from recruiters or employment agencies. In the absence of an executed Recruitment Services Agreement, there will be no obligation to any referral compensation or recruiter fee.
In the event a recruiter or agency submits a resume or candidate without an agreement, Metova Talent shall explicitly reserve the right to pursue and hire those candidate(s) without any financial obligation to the recruiter or agency. Any unsolicited resumes, including those submitted to hiring managers, shall be deemed the property of Metova Talent.