Sr Analyst, Healthcare Claims Analytics (SQL, Power BI)
Molina Healthcare New York; Ohio; Columbus, Ohio; Seattle, Washington; Phoenix, Arizona; Chandler, Arizona; Orlando, Florida; Davenport, Iowa; Owensboro, Kentucky; Michigan; Detroit, Michigan; Kearney, Nebraska; Rio Rancho, New Mexico; Syracuse, New York; Houston, Texas; Provo, Utah; Bellevue, Washington; Macon, Georgia; Savannah, Georgia; Columbus, Georgia; Georgia; Iowa City, Iowa; Idaho; Lincoln, Nebraska; Roswell, New Mexico; Utah; Miami, Florida; Cedar Rapids, Iowa; Nampa, Idaho; Sterling Heights, Michigan; Scottsdale, Arizona; Buffalo, New York; Tacoma, Washington; Washington; Tucson, Arizona; St. Petersburg, Florida; Racine, Wisconsin; Idaho Falls, Idaho; Lexington-Fayette, Kentucky; Bowling Green, Kentucky; Omaha, Nebraska; Nebraska; Santa Fe, New Mexico; Las Cruces, New Mexico; New Mexico; New York, New York; Cleveland, Ohio; San Antonio, Texas; Fort Worth, Texas; West Valley City, Utah; Tampa, Florida; Florida; Augusta, Georgia; Atlanta, Georgia; Yonkers, New York; Cincinnati, Ohio; Dallas, Texas; Layton, Utah; Spokane, Washington; Madison, Wisconsin; Milwaukee, Wisconsin; Iowa; Covington, Kentucky; Rochester, New York; Dayton, Ohio; Austin, Texas; Orem, Utah; Green Bay, Wisconsin; Wisconsin; Meridian, Idaho; Caldwell, Idaho; Louisville, Kentucky; Kentucky; Ann Arbor, Michigan; Grand Rapids, Michigan; Albuquerque, New Mexico; Akron, Ohio; Texas; Salt Lake City, Utah; Vancouver, Washington; Mesa, Arizona; Kenosha, Wisconsin; Jacksonville, Florida; Sioux City, Iowa; Des Moines, Iowa; Boise, Idaho; Warren, Michigan; Bellevue, Nebraska; Grand Island, Nebraska Job ID 2030854JOB 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.
KNOWLEDGE/SKILLS/ABILITIES
- 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.
JOB QUALIFICATIONS
Required Education
Bachelor's Degree in Finance, Economics, Computer Science
Required Experience
- 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 Education
- Bachelor's Degree in Finance, Economics, Math, or Computer Science
Preferred Experience
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
To all current Molina employees: If you are interested in applying for this position, please apply through the intranet job listing.
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 posting based on geographic location, work experience, education and/or skill level.
About Us
Molina Healthcare is a nationwide fortune 500 organization with a mission to provide quality healthcare to people receiving government assistance. If you are seeking a meaningful opportunity in a team-oriented environment, come be a part of a highly engaged workforce dedicated to our mission. Bring your passion and talents and together we can make a difference in the lives of others. Molina Healthcare offers a competitive benefits and compensation package. Molina Healthcare is an Equal Opportunity Employer (EOE) M/F/D/V.
Job Type: Full Time Posting Date: 03/19/2025ABOUT OUR LOCATION
View Map- Sr BI Analyst - ETL St. Petersburg Florida, Akron Ohio, Idaho, Scottsdale Arizona, Cincinnati Ohio, Washington, Rochester New York, Houston Texas, Dallas Texas, Chandler Arizona, Savannah Georgia, Atlanta Georgia, Iowa, Orlando Florida, Buffalo New York, Dayton Ohio, Wisconsin, Santa Fe New Mexico, Cleveland Ohio, Idaho Falls Idaho, Spokane Washington, Lexington-Fayette Kentucky, Racine Wisconsin, Michigan, Layton Utah, Provo Utah, West Valley City Utah, Augusta Georgia, Grand Island Nebraska, Warren Michigan, Nebraska, Iowa City Iowa, Sterling Heights Michigan, Caldwell Idaho, Detroit Michigan, Tacoma Washington, Boise Idaho, Fort Worth Texas, Albuquerque New Mexico, Texas, Yonkers New York, New York, Columbus Ohio, Orem Utah, San Antonio Texas, Madison Wisconsin, Milwaukee Wisconsin, Sioux City Iowa, New Mexico, Roswell New Mexico, Des Moines Iowa, Salt Lake City Utah, Tampa Florida, Las Cruces New Mexico, Miami Florida, Columbus Georgia, Kearney Nebraska, Grand Rapids Michigan, Kenosha Wisconsin, Green Bay Wisconsin, Louisville Kentucky, Omaha Nebraska, Lincoln Nebraska, Davenport Iowa, Austin Texas, Cedar Rapids Iowa, Bellevue Washington, Macon Georgia, Meridian Idaho, Jacksonville Florida, Ohio, Owensboro Kentucky, Bowling Green Kentucky, Ann Arbor Michigan, Tucson Arizona, Bellevue Nebraska, Rio Rancho New Mexico, Georgia, Utah, Vancouver Washington, Nampa Idaho, Florida, Syracuse New York, Phoenix Arizona, Kentucky, Mesa Arizona, Covington Kentucky 02/19/2025
- Hospice Oversight Case Manager (RN) California Burbank California, Glendale California, Simi Valley California, Santa Monica California, Compton California, Carson California, Irvine California, San Francisco California, Sacramento California, Torrance California, Huntington Beach California, Corona California, Temecula California, Apple Valley California, San Jose California, San Diego California, Fresno California, San Bernardino California, Riverside California, Long Beach California, Los Angeles California 02/11/2025
- Medical Economics Consultant - REMOTE St. Petersburg Florida, Rio Rancho New Mexico, Washington, Dallas Texas, Columbus Georgia, Utah, Orem Utah, Sterling Heights Michigan, Las Cruces New Mexico, Columbus Ohio, Sioux City Iowa, Albuquerque New Mexico, Austin Texas, Kentucky, San Antonio Texas, Roswell New Mexico, Grand Rapids Michigan, Rochester New York, Yonkers New York, Iowa, Buffalo New York, West Valley City Utah, Phoenix Arizona, Davenport Iowa, Tampa Florida, Orlando Florida, Macon Georgia, Tucson Arizona, Spokane Washington, Grand Island Nebraska, Tacoma Washington, Cedar Rapids Iowa, Savannah Georgia, Syracuse New York, Dayton Ohio, Santa Fe New Mexico, Michigan, Texas, Mesa Arizona, Chandler Arizona, Atlanta Georgia, Layton Utah, Houston Texas, Provo Utah, Salt Lake City Utah, Bowling Green Kentucky, Fort Worth Texas, Ohio, Des Moines Iowa, Bellevue Nebraska, Omaha Nebraska, Milwaukee Wisconsin, New York, Covington Kentucky, Kenosha Wisconsin, Bellevue Washington, Ann Arbor Michigan, Florida, Lexington-Fayette Kentucky, Scottsdale Arizona, Cleveland Ohio, Jacksonville Florida, Cincinnati Ohio, Georgia, Caldwell Idaho, Madison Wisconsin, Idaho, Iowa City Iowa, Boise Idaho, Meridian Idaho, Owensboro Kentucky, Green Bay Wisconsin, Miami Florida, Racine Wisconsin, Louisville Kentucky, Akron Ohio, Wisconsin, Augusta Georgia, Idaho Falls Idaho, Nampa Idaho, Nebraska, Detroit Michigan, Warren Michigan, Lincoln Nebraska, Long Beach California, New Mexico, Kearney Nebraska, Vancouver Washington 01/17/2025
- Analyst, Medical Economics - REMOTE West Valley City Utah, Layton Utah, Orem Utah, Tucson Arizona, Las Cruces New Mexico, Boise Idaho, Bellevue Nebraska, Caldwell Idaho, Bowling Green Kentucky, Atlanta Georgia, Augusta Georgia, Savannah Georgia, Santa Fe New Mexico, Iowa, Cincinnati Ohio, Akron Ohio, Fort Worth Texas, Macon Georgia, Buffalo New York, Michigan, Lincoln Nebraska, Vancouver Washington, Georgia, Idaho, Nebraska, Miami Florida, Racine Wisconsin, Scottsdale Arizona, Warren Michigan, Kearney Nebraska, Dallas Texas, Detroit Michigan, Albuquerque New Mexico, Dayton Ohio, Washington, Meridian Idaho, Roswell New Mexico, New York, Florida, Omaha Nebraska, Houston Texas, Provo Utah, St. Petersburg Florida, Salt Lake City Utah, Madison Wisconsin, Covington Kentucky, Kentucky, Bellevue Washington, Syracuse New York, Rio Rancho New Mexico, Cleveland Ohio, Columbus Georgia, Ann Arbor Michigan, Austin Texas, Kenosha Wisconsin, Sioux City Iowa, Tacoma Washington, Des Moines Iowa, Cedar Rapids Iowa, Wisconsin, Iowa City Iowa, Phoenix Arizona, Grand Rapids Michigan, Green Bay Wisconsin, Yonkers New York, San Antonio Texas, Sterling Heights Michigan, Milwaukee Wisconsin, Tampa Florida, Utah, Texas, Long Beach California, Chandler Arizona, Orlando Florida, Idaho Falls Idaho, Louisville Kentucky, Ohio, Davenport Iowa, Lexington-Fayette Kentucky, Rochester New York, Columbus Ohio, New Mexico, Jacksonville Florida, Owensboro Kentucky, Nampa Idaho, Grand Island Nebraska, Mesa Arizona, Spokane Washington 01/17/2025