Description

*JOB SUMMARY* VBC Analytics is a single, independent team covering BSW Health and Quality Alliance (ACO) analytical needs. Domain verticals connect directly to core stakeholders and operational structures while aligning with internal SMEs and current capacities. We have over 1.2 million lives across multiple blocks of business and industry-leading analytics to support our organization. We are seeking a customer-facing Analyst who works closely with key business stakeholders within the value-based care team. As a crucial member of our analytics department, you will be responsible for transforming complex healthcare data into insightful and actionable insights or visualizations. This role will operate in two capacities; to augment existing data products, as well as innovate new analytic experiences that simplify data into insights. *The pay range for this position is $28.52/hour (entry level qualifications) - $42.79/hour (highly experienced). The specific rate will depend upon the successful candidate's specific qualifications and prior experience. * *Responsibility includes a combination of:* * Handle ad-hoc analysis of quality measures to analyze trends, performance (20%) * Leverage medical and pharmaceutical claims and Electronic Health Record (EHR) data with Snowflake SQL to measure financial impact (15%) * Support enterprise data governance initiatives by implementing data quality rules, validations, and monitoring tools to ensure accuracy, timeliness, completeness, and consistency of analytical datasets. (15%) * Design architecture, model data and create BI dashboards and/or reporting solutions for Quality measures to identify trends, variance (20%) * Data Integration & Product Enhancement: Integrate diverse healthcare datasets using Power BI and the Microsoft Power Platform to deliver comprehensive insights while supporting and enhancing existing products through automation, enforcement of technical standards, and implementation. (10%) * Run and support the end-to-end Measures integration process by securely sending data to third party, receiving and validating computed measure files for completeness, accuracy, and format, and monitoring and troubleshooting the ETL workflow in coordination with internal teams and external partners. (15%) * Continue personal growth and development through weekly dedicated time (5%). * This role is a good fit for those familiar with healthcare and medical trends *Essential Functions of the Role:* * Design, develop, and maintain scalable data models, pipelines, and reporting solutions to support business intelligence and advanced analytics needs. * Collaborate with cross-functional teams including business stakeholders, data engineers, and product managers to gather requirements and deliver actionable insights. * Optimize and write complex SQL queries for performance and scalability across large datasets, in Snowflake. * Lead initiatives in cloud platforms (e.g., Azure, AWS, or GCP) for data ingestion, transformation, and storage. * Perform statistical analysis of quality measures, claims to understand trends in cost, utilization and performance. * Ensure data accuracy, integrity, and security by enforcing governance and quality standards. * Create and manage dashboards and visualizations in Power BI to support data-driven decision-making. *Required Qualifications:* * The ideal candidate will have most of the following skills and an eagerness to learn the rest. * Bachelor's degree in computer science, Information Technology, Mathematics or STEM field. * Proficiency in SQL-based languages. * Experience with ETL * Experience with Medical Trends & Healthcare Knowledge. * Experience with Microsoft SQL Server or other data warehouse tools showing comfortability and hands-on experience with large datasets. * Experience with building Power BI (or similar) dashboard with rich Visuals * Design analytical solutions on Snowflake cloud data warehouse using snow SQL. * Solid communication skills with both technical and non-technical collaborators *Preferred Qualifications:* * Experience with Medical Trends & Healthcare Knowledge. * Experience with Quality measures and HEDIS is preferred * Experience in analytical methodologies and algorithms * Any experience in AD group security or row level security or automation * Scripting knowledge with Python * Experience of delivering reporting solutions to end users with AI Agents. * Foundation in SDLC methodologies - Agile and SCRUM * Experience in understanding the healthcare ecosystem - the relationship between payers and providers, and how analytics enables strategic transformation and growth. * Knowledge of Power Platforms like Power Automate, Power Apps *BENEFITS* Our competitive benefits package includes the following Immediate eligibility for health and welfare benefits 401(k) savings plan with dollar-for-dollar match up to 5% Tuition Reimbursement PTO accrual beginning Day 1 Note: Benefits may vary based upon position type and/or level *QUALIFICATIONS* - EDUCATION - Bachelor's or 4 years of work experience above the minimum qualification - EXPERIENCE - 1 Year of Experience