Sr. Claims Reporting Analyst (SSRS / SSIS / SQL) Job in Long Beach 90810, California Us
SENIOR CLAIMS REPORTING ANALYST (SSIS /SSRS / SQL)
POSITION SUMMARY
Create and maintain reports supporting all functional areas of claims production, adjustments, recoveries, auditing, compliance and KPI. Ability to work closely with all levels of management to determine business requirements. Proactively perform analysis of data and provide management with concise summary and recommendations if appropriate. Familiar with software life cycle and working in a team environment. Mentor team members in both technical and functional subjects. Lead the team in innovation with new technology and processes. Help develop and enforce team standards. This position requires strong Excel, SQL and Microsoft Business Intelligence skills.
REQUIRED SKILLS AND QUALIFICATIONS
Education:
Bachelors Degree in one of the following or equivalent years of work experience:
o Business Administration, Information Systems
o Computer Science
o Business Administration, Accounting/Finance
Experience:
o 3 years in healthcare insurance preferred
o 5 years SQL required
o Microsoft Excel required
o Microsoft Business Intelligence (SSIS, SSRS, SSAS) required
o Microsoft SharePoint preferred
o QNXT experience preferred
o Microsoft Access required
o Demonstrated expertise in technology / claims functional subject areas
Licensure/Certification:
o Microsoft certification preferred
PRINCIPLE ACCOUNTABILITIES
o Work with all levels of management team to develop business requirements for reports supporting the Claims Department.
o Create and maintain reports utilizing SQL, Excel, MS Access, SSIS, SSRS and SharePoint. These reports will be used to manage claim inventory, adjustment processes, audit, compliance, recoveries, coordination with other departments such as Configuration and KPI metrics production.
o Gather data and work with management to perform analysis to resolve issues or to improve processes.
o Proactively identify problems and suggest resolutions for both reporting and functional processes.
o Follow team coding standards for report design. Work to build, implement and support best practices among the team.
o Mentor team members in both technical and functional subjects.
o Innovate new ways to provide support to the Claims Department through technology or improved processes.
DEPARTMENT/STATE SPECIFIC JOB FUNCTIONS
o Document report requirements
o Produce reports using Excel, T-SQL, SSIS, SSRS and SharePoint
o Validate results
o Work with team mates to ensure quality reports
o Analyze data and provide assistance to Claims staff and management team
o Develop and enforce standards for team processes
o Continually look for opportunities to improve both technical and functional processes
Molina Healthcare is an Equal Opportunity Employer (EOE) M/F/D/V