Business Data Analyst

Astrana Health, Inc.•Monterey Park, CA

1d•$72,000 - $84,000•Remote

About The Position

This position is responsible for meeting the company's delegated and regulatory reporting requirements for both the Claims and Provider Dispute Resolution departments. Additionally, there may be occasions when support is needed to generate operational reports for these functions. The position involves analyzing, designing, developing, deploying, and managing data systems, reports, and dynamic dashboards. The Analyst may also be responsible for presenting analytic findings. This role includes extracting data from multiple sources, manipulating and validating the data, and may involve conducting root cause analysis. Candidates should be comfortable performing the following tasks: writing queries in SQL Management Studio, developing reports in SQL Server Reporting Services (SSRS), writing Extract, Transform, Load (ETL) processes in SQL Server Integration Services (SSIS), creating analytical visualizations using tools such as Power BI, QlikView, and Tableau, as well as managing data systems development and enhancement projects.

Requirements

Bachelor’s degree in Business, Mathematics, Computer Science, Information Technology, or a related field.
At least three years experience in healthcare, primarily related to Data Analysis, Database Development, or Database Administration.
writing queries in SQL Management Studio
developing reports in SQL Server Reporting Services (SSRS)
writing Extract, Transform, Load (ETL) processes in SQL Server Integration Services (SSIS)
creating analytical visualizations using tools such as Power BI, QlikView, and Tableau
managing data systems development and enhancement projects

Nice To Haves

Experience in a Managed Care environment
Experience with Managed Care Applications (MCA) or Healthcare Core system (EzCap, IDX, Epic, FACETS, NextGen, Etc.)
Experience with SSIS, Power Apps, and Power Automate is a plus

Responsibilities

Provide data analysis and reporting solutions to our various business units in support of their operational goals
Work closely with our business units, compliance and project teams to understand reporting requirements of each of our contracted health plans, collaborate to define and document required reporting requirements, templates and cadence
Use sound judgment in analyzing business needs and provide guidance in determining the best reporting approach (ad-hoc, scheduled, real-time, etc.)
Implement reporting from new or existing datasets and ensure data integrity
Provide support for new dataset creation and architecture
Query multiple data sources using SQL, develop ETLs, and produce reports and dashboards using Power BI and SSRS
Analyzes root cause of errors; communicates errors to the appropriate clients and escalates system errors, issues, or problems to the Business Unit Manager
Assists in the research and evaluation of additional technical capabilities required in support of our organization’s needs
Meets or exceeds assigned standards from a compliance timeliness and accuracy perspective
Manages assigned escalations to resolution
Conducts root cause analysis (project and technical) to identify opportunities for improvement
Ensure that all forms of technical debt are identified, tracked, communicated, and addressed
Defines, develops, and evaluates performance metrics to establish process success, and may participate in working with multiple stakeholders, often with competing/conflicting objectives, to ensure cohesive and reachable measures of success Reviews data post- implementation to measure success; participates in defining standards of improvement success
Participates in and may lead change management activities associated with process improvement. Engages leadership and stakeholders to obtain support and buy in for changes. Partners with management, project champions, and process owners to align process improvement initiatives with business objectives