Sr Data Analyst (1700BR) Long Beach, California

Job Summary

Accountable for enrollment to premium related analysis for the organization. Responsible to ensure accurate and timely reconciliation and reporting of premium for month-end to management and corporate accounting for journal entries. Additionally responsible for creating databases, queries and SSRS reports in support of enrollment and premium billing and reconciliation. Identify observations to manager, pointing out areas of concern inaccuracy and efficiencies. Collaborate with the Enrollment team(s) to correct deficiencies identified within the core system related to member’s enrollment. Interact directly with the State/Federal agencies on a routine basis to resolve premium discrepancies. Participate in internal and external audits representing States/programs assigned.

Essential Functions

• Perform the monthly premium to enrollment reconciliation for multiple States/Program(s). Enrollment to revenue reconciliation.
• Utilizing premium application reports and SQL analysis of the various premium types to produce monthly output to Finance team for recording premiums into the general ledger.
• Responsible for submission of delivery data to the State agency for premiums due, including the follow-up for outstanding data and reconciling non-payables.
• Develops databases, queries and SSRS reports to produce reports as required in support of enrollment, premium billing and reconciliation.
• Responsible for maintaining documentation in support of SOX compliance (month-end audit trail). Participates in internal and external audits on routine basis to represent outcomes.
• Work directly and indirectly with State/ Federal agencies and/or 3rd party vendor to reconcile premium discrepancies.
• Tracks membership trends related to revenue.
• Work collaboratively with the enrollment teams to reconcile eligibility issues identified through the premium reconciliation process.
• Identify any deficiencies within the process, strategize and design improvements where possible.

Knowledge/Skills/Abilities

• Must be able to function independently and to manage multiple processes to meet established timelines and goals.
• Knowledge in finance, enrollment and premium related processes.
• Strong knowledge in MS SQL analysis, including SSRS and database development.
• Proficient in MS Office Suite products, key skills in Excel (V look-ups and pivots).
• Excellent verbal and written communication skills.
• Demonstrated adaptability and flexibility to changes, responds well to new ideas and approaches.
• Excellent interpersonal skills, ability to work in a distributed environment with other people who may be supervised by external parties.
• Ability to establish and maintain positive and effective working relationships with coworkers, vendors, and members.



Required Education: 
BA/BS/BC degree or minimum equivalent employment experience of 7+ years in Finance, Health Care or related field required.
  
Required Experience:  
3-7 years experience as database analyst in the managed healthcare industry or related field.  Must have strong finance, quantitative and analytical skills and ability.
Required Licensure/Certification:
   
 
Preferred Education:
BA/BS/BC degree
Preferred Experience:
Experience with data management and analysis preferred.  4 – 7 year’s experience in health care industry in related field desired
Preferred Licensure/Certification:
  
 



To all current Molina employees if you are interested in applying for this position please apply through the intranet job listing. Also, fill out an Employee Transfer Request Form (ETR) and attach it to your profile when applying online.

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

To apply, please click here