Remote Healthcare Data Analyst - Power BI & SQL

Astrana Health Management; Monterey Park (CA); Hybrid; USD 72,000 - 84,000; Full time

Job summary

Astrana Health Management is seeking a Business Data Analyst to join our Ops - Claims Ops team in a remote US-based capacity. You will analyze claims data, develop robust reports and dashboards, and support regulatory reporting requirements.

The role involves extracting data from multiple sources, building ETLs in SSIS, and presenting analytic findings. Proficiency in SQL, SSRS, and Power BI is essential, with Databricks experience a plus.

Qualifications

• Bachelor's degree in a related field.
• At least three years experience in healthcare data analysis, database development, or database administration.
• Experience with healthcare claims data, CPT/diagnosis codes, dates of service.
• Proficiency in SQL for querying and managing large datasets.
• Hands-on experience developing reports and dashboards using Power BI.

Responsibilities

• Provide data analysis and reporting solutions to our business units in support of operational goals.
• Collaborate with business units, compliance, and project teams to define reporting requirements and cadence.
• Determine the best reporting approach (ad-hoc, scheduled, real-time).
• Implement reporting from new or existing datasets and ensure data integrity.
• Support creation of new dataset architecture and reporting pipelines.
• Query multiple data sources with SQL, develop ETLs, and produce Power BI/SSRS reports and dashboards.
• Analyze root causes of errors and communicate/escalate issues as needed.
• Assist in evaluating additional technical capabilities to support organizational needs.
• Meet or exceed compliance timeliness and accuracy standards.
• Manage escalations to resolution and drive them to closure.
• Conduct root-cause analysis to identify improvement opportunities.
• Identify and track technical debt and ensure it is addressed.

Skills

SQL

Data analysis

Dashboard development

Education

Bachelor's degree

Tools

SSIS

Power BI

Databricks

Power Apps

Power Automate

Job description

Astrana Health Management is seeking a Business Data Analyst to join our Ops - Claims Ops team in a remote US-based capacity. You will analyze claims data, develop robust reports and dashboards, and support regulatory reporting requirements.

The role involves extracting data from multiple sources, building ETLs in SSIS, and presenting analytic findings. Proficiency in SQL, SSRS, and Power BI is essential, with Databricks experience a plus.