Data and Reporting Analyst

What We Provide

• Referral bonus opportunities

• Generous paid time off (PTO), starting at 30 days of paid time off and 9 company holidays

• Health insurance plan for you and your loved ones, Medical, Dental, Vision, Life and Disability

• Employer-matched retirement saving funds

• Personal and financial wellness programs

• Pre-tax flexible spending accounts (FSAs) for healthcare and dependent care

• Generous tuition reimbursement for qualifying degrees

• Opportunities for professional growth and career advancement

• Internal mobility, generous tuition reimbursement, CEU credits, and advancement opportunities

What You Will Do

• Performs analyses and reporting to provide insight to decision-makers.

• Performs detailed analyses in response to requests from internal and external customers. Analyzes and manipulates data, identifies trends, reviews and evaluates findings. Summarizes data in user-friendly reports constructing tables, graphs, and providing statistical and qualitative analysis.

• Responsible for the distribution of data needed for quarterly and annual cost reporting.

• Engineer data structures in data warehouse used for MMCOR filing & identifies opportunities to improve data collection, report distribution and maintenance to management; participates in implementation of changes, as appropriate. Collaborates with Provider and/or Outcomes team to streamline standard reporting needs.

• Develop dashboards for statewide MMCOR data for all health plans in order analyze competitor data for comparison of market performance.

• Instructs, orients and trains department staff to new and existing reports and reporting tools.

• Obtains end user feedback/input to ensure that their reporting needs are met.

• Reviews and monitors key operational indicators related to cash flow, reconciliation of charges and services rendered, and performs detailed denial analyses including reconciliation of payments at the time of service against posted payments. Analyzes errors in billing and denial data to identify root causes.Designs and documents business and IT processes using standard process mapping techniques including but not limited to, VSM, SIPOC, Swimlanes, etc.For Finance only:

• Identifies problems in the process flow or organizational structure that impedes financial outcomes, proposes solutions, and collaborates with department to implement corrective action.

• Participates in special projects and performs other duties as assigned.

Licenses and Certifications:

• Experience with statistical software programs (i.e. Minitab, SAS). preferred

Education:

• Bachelor's Degree in Computer Science, Mathematics, Statistics, Economics, Finance or related discipline or the equivalent work experience required

Work Experience:

• Minimum two years of experience applying analytics, statistics and/or data visualization expertise, preferably in a healthcare setting required

• Strong qualitative and quantitative analytic skills, as well as, with the ability to interpret and present key analytic findings required

• Demonstrated ability to understand industry issues and problems, relate them to clients' needs, and propose appropriate solutions required

• Effective oral, written and interpersonal communication skills required

• Knowledge of and experience with SQL, Python and/or R to extract and manipulate data, delivered through dashboards required

• Proficiency with MS Office suite required. Experience with Business Intelligence tools such as MicroStrategy, Tableau, Power BI and CRM tools such as Salesforce, and statistical software such as Mini Tab preferred

• For Revenue Cycle Only: Understanding of healthcare provider operations and revenue cycle management is preferred