Senior Analyst, Healthcare Analytics - SQL/Power BI - Remote

Molina Healthcare; City of Syracuse (NY); Remote; USD 77,000 - 156,000; Full time

Job summary

A healthcare analytics firm in Syracuse seeks a professional to analyze complex healthcare claims data, produce reports, and provide insights. Ideal candidates have a Bachelor's Degree and 5-7 years of experience in data management and healthcare metrics analysis. The role involves developing reports using SQL and other tools, analyzing trends, and making data-driven recommendations. A competitive benefits and compensation package is offered.

Benefits

Competitive benefits and compensation package

Qualifications

• 5-7 years of experience in database and data management responsibilities.
• Experience in quantifying and analyzing healthcare metrics.
• Basic knowledge of SQL required.

Responsibilities

• Develop ad-hoc reports using various analytic and programming tools.
• Collect report requirements and ensure accuracy in reporting.
• Analyze data trends and provide recommendations.

Skills

Healthcare data analysis

SQL programming

Statistical analysis

Report generation

Education

Bachelor's Degree in Finance, Economics, or Computer Science

Tools

SQL Server Reporting Services (SSRS)

Crystal Reports

Excel

Job description

Job Summary

Performs research and analysis of complex healthcare claims data, pharmacy data, and lab data regarding network utilization and cost containment information. Evaluates, writes, and presents healthcare utilization and cost containment reports and makes recommendations based on relevant findings.

Responsibilities

• Develop ad-hoc reports using SQL programming, SQL Server Reporting Services (SSRS), Medinsight, RxNavigator, Crystal Reports, Executive Dashboard, and other analytic / programming tools as needed.
• Generate and distribute standard reports on schedule using SQL, Excel, and other reporting software.
• Create new databases and reporting tools for monitoring, tracking and trending based on project specifications.
• Collects and documents report / programming requirements from requestors to ensure appropriate creation of reports and analyses. Uses peer-to-peer review process and end-user consultation to reduce report writing errors and rework.
• Responsible for timely completion of projects, including timeline development and maintenance; coordinates activities and data collection with requesting internal departments or external requestors.
• Identify and complete report enhancements/fixes; modify reports in response to approved change requests; retain old and new report design for audit trail purposes.
• Analyze data sets and trends for anomalies, outliers, trend changes and opportunities, using statistical tools and techniques to determine significance and relevance. Utilize extrapolation, interpolation, and other statistical methodologies to predict future trends in cost, utilization and performance. Provide executive summary of findings to requestors.
• Create comprehensive workflows for the production and distribution of assigned reports, document reporting processes and procedures.
• Assist with research, development and completion of special projects as requested by various internal departments, or in support of requests from regulatory agencies, contracting agencies, or other external organizations.
• Maintains SharePoint Sites as needed.

Requirements

• Bachelor's Degree in Finance, Economics, Computer Science
• 5-7 years increasingly complex database and data management responsibilities
• 5-7 years of increasingly complex experience in quantifying, measuring, and analyzing financial/performance management metrics
• Demonstrate Healthcare experience in Quantifying, Measuring and Analyzing Financial and Utilization Metrics of Healthcare
• Basic knowledge of SQL

Preferred Qualifications

• Preferred experience in Medical Economics and Strong Knowledge of Performance Indicators:
• Proactively identify and investigate complex suspect areas regarding medical cost issues
• Initiate in-depth analysis of the suspect/problem areas and suggest a corrective action plan
• Apply investigative skill and analytical methods to look behind the numbers, assess business impacts, and make recommendations through use of healthcare analytics, predictive modeling, etc.
• Analysis and forecasting of trends in medical costs to provide analytic support for finance, pricing and actuarial functions
• Healthcare Analyst I or Financial/Accounting Analyst I experience desired
• Multiple data systems and models
• BI tools

Molina Healthcare offers a competitive benefits and compensation package. Molina Healthcare is an Equal Opportunity Employer (EOE) M/F/D/V.

Pay Range: $77,969 - $155,508 / ANNUAL

*Actual compensation may vary from geographic location, work experience, education and/or skill level.