Analyst, Data (SQL Queries)Long Beach, California Job ID 2000254
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 queries to support reporting for accounting and enrollment & premium billing and reconciliation. Maintain premium rate master tables, working closely with configuration teams. 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.
•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.
·Maintain premium rate master tables, working closely with configuration teams
·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, queries 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.
•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
•Knowledge in MS SQL queries 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.
BA/BS/BC degree or minimum equivalent employment experience of 7+ years in Finance, Health Care or related field required.
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.
Experience with data management and analysis preferred. 4 – 7 years’ experience in health care industry in related field desired
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.