Senior Business Technical Analyst

Position Purpose: Provides in-depth business knowledge and advanced technical support to one or more business areas through developed and ad hoc analysis/reporting , as well as designing and programming complex, new processes/reports. Acts as subject matter expert for department or business unit on business systems/applications. This role is 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. Analyzes company functions, processes, and activities to improve computer-based business applications for the most effective use of money, materials, equipment, and people. Performs application/system design and implementation. Documents development requirements. Consults with end users to test and debug applications to meet client needs. The ideal candidate brings advanced SQL, Snowflake, Databricks knowledge, healthcare data integration experience, data quality, regulatory compliance, and reusable documentation experience.

Develops ad-hoc reports to conduct data analysis and validation.

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.

Conducts business analysis and recommends technical alternative solutions to management as to course of action that best meets the organization's goals.

Analyzes provided requirements, procedures, and data needs to automate processing, improve existing business systems, and support production-ready SAS code for Encounter Risk Adjustment Prioritization and Encounter Risk Adjustment Chart Process workflows, with future Snowflake migration support.

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.

Research, evaluate and assess the financial impact of issues identified in data/processes

Analyzes requirements, procedures, and problems to automate processing or to improve existing business systems

Creates multiuser, real-time, robust database solution

Acts as subject matter expert to provide business and technical expertise in requirements solicitation, system analysis, technical design, programming and documentation of business applications/systems

May be responsible for monitoring and reporting to management on the status of departmental projects: Anticipates and identifies issues that could inhibit achieving the project goals and objectives, and implementing corrective actions and mitigation strategies.