Business Data Analyst

astranahealth; Monterey Park (CA); On-site; USD 70,000 - 100,000; Full time

Job summary

astranahealth seeks a Business Data Analyst in Monterey Park, CA to meet regulatory reporting needs for Claims Ops and Provider Dispute Resolution. You will design, deploy, and manage data systems, reports, and dynamic dashboards, extract and validate data, and present analytic findings to stakeholders.

Responsibilities include writing SQL queries, developing SSRS reports, ETL with SSIS, and crafting visualizations in Power BI, QlikView, and Tableau.

Qualifications

• Experience with SQL in Microsoft SQL Server
• Experience building reports with SSRS
• ETL development with SSIS
• Experience creating dashboards with Power BI/Tableau/QlikView

Responsibilities

• Write queries in SQL Management Studio
• Develop reports in SSRS
• Build and maintain ETL processes with SSIS
• Create analytical visualizations using Power BI, QlikView, Tableau

Skills

SQL

ETL

Data analysis

Data visualization

Tools

SQL Server Management Studio

SSRS

SSIS

Power BI

QlikView

Tableau

Job description

Job Title: Business Data Analyst Department: Ops - Claims Ops About the Role: 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
• managing data systems development and enhancement projects