Senior Business Technical Analyst

Position Purpose

This role is a Sr. BTA position focused on translating Medicare Advantage and Medicaid Risk Adjustment business requirements into production-ready technical solutions, including Encounter RA Prioritization and Encounter RA Chart Process support.

Requirements

• Bachelor's Degree in a related field or equivalent work experience in technical data analysis, conducting system analysis meetings, developing system design documents, developing project plans with achievable milestones and deadlines, and mediating different department demands to gain approvals on system scope and design.
• Master's degree in a related field, i.e., Mathematics, Computer Science, etc. may be considered in lieu of some of the required experience (not to exceed 2 years).
• 1+ year of experience in Healthcare.
• 4+ years of experience in relevant programming to include SAS, SQL, Snowflake.
• Experience modernizing SAS ETL workflows into Snowflake using Snowflake SQL, Snowpark Python, and automated pipeline orchestration.
• 3+ years of experience in related business analysis.
• 1+ year of experience in ASP/ASP.NET.

Qualifications

• Advanced SAS, SQL, Snowflake, healthcare data integration, data quality, regulatory compliance, and reusable documentation experience.
• Partners with business analysts, Risk Adjustment stakeholders, IT, and vendor teams to understand provided Medicare Advantage and Medicaid business requirements, translate them into technical specifications, and support process improvements through SAS solutions and future Snowflake capabilities.
• Creates multi-user, real-time, robust database solutions by integrating complex healthcare datasets, including claims, enrollment, provider, pharmacy, clinical records, and vendor chart data.
• Acts as a technical subject matter expert to convert provided business requirements into system analysis, technical design, advanced SAS/SQL programming, Snowflake modernization, and documentation of business applications/systems.
• Modernizes legacy SAS ETL workflows into scalable Snowflake architecture using Snowflake SQL, Snowpark Python, and automated pipeline orchestration concepts such as Tasks and Streams.
• Implements validation, reconciliation, and data quality frameworks to support CMS audit standards, state Medicaid requirements, and compliant Risk Adjustment encounter submissions.
• Builds reusable SAS, SQL, and Snowflake data assets, modular code libraries, and technical documentation to reduce development time and support knowledge transfer across data and actuarial teams.
• Develops ad-hoc reports to conduct data analysis and validation.
• Conferences with area/department to analyze current operational procedures and trends and identify problems.
• Conducts business analysis and recommends technical alternative solutions to management as to course of action that best meets the organization's goals.
• Researches, evaluates, and assesses the financial impact of issues identified in data/processes.

Skills

• SAS Certified Professional or SAS Certification.
• SnowPro Certification.

Benefits

• Competitive pay.
• Health insurance.
• 401K and stock purchase plans.
• Tuition reimbursement.
• Paid time off plus holidays.
• A flexible approach to work with remote, hybrid, field or office work schedules.