Lead Analyst, Business Quality - Excel/SQL/Claims Configuration

Job DescriptionJob SummaryInterfaces with the customer in developing requirements for major complex claims testing projects within Medicare, Medicaid and Marketplace; prepares system test design specifications; conducts research to resolve customer initiated issues related to core systems processing; and coordinates and manages project test resources in the development of large multi-system, multi-platform test project. Responsible for accurate and timely creation and execution of UAT test artifacts and tasks. May also assigns and manages the workload for a team of analysts on the projectJob Duties Works closely with customer to develop test requirements for major projects of considerable complexity.Lead/mentor Business Analysts and Sr Business Analysts on the team Prepares general system test design specifications. Creates, reviews, analyzes and estimates project test requests. Performs research and analysis of customer initiated inquiries and requests, utilizing technical tools as necessary to fully test reported issues/requirements . Fields direct questions from Molina Operations Staff regarding business, technical and operations rules that may impact testing. Develops technical tests to complex business and system problems. Provides guidance for development teams through project testing as needed. Provides excellent customer service to internal and external customers handling all aspects of client relations concerning testing for technical projects, including notifying the client of implementation schedules and co-ordination and assistance in presentation of results. Provides leadership by mentoring others and sharing business and system knowledge. Develops, reviews and validates test results per requirements. Develops and documents a test plan that describes the testing steps and test cases needed to prove that the components of the solution work as expected for any and all solutions, including complex solutions Creates, presents and executes functional and acceptance test cases in accordance with the requirements of the solution/project. Manages complex project testing tasks from requirements review through deployment, including work assignment, prioritization, issue triage etc. Understands other Molina changes in process that may impact the customer, and notifies the customer of such changes well ahead of their implementation. Supports Integrated Test Facility (QA) as needed through audit and validation of testing wor completed. Able to work in a project team setting while also able to complete tasks individually within the provided timeline or as needed, accelerated timeline to meet the desired deployment deadline. Provides testing guidance to Business Systems Analysts as needed for the project.Job QualificationsREQUIRED EDUCATION:Bachelor’s Degree in Business Administration or Information Technology or equivalent combination of education and experienceREQUIRED EXPERIENCE/KNOWLEDGE, SKILLS & ABILITIES:7 + years experience in a combination of applicable business and business systemsPREFERRED EXPERIENCE:Medicare, Medicaid and Marketplace claims knowledgeComplex SQL and Excel expert knowledgeSQL query and codingPHYSICAL DEMANDS:Working environment is generally favorable and lighting and temperature are adequate. Work is generally performed in an office environment in which there is only minimal exposure to unpleasant and/or hazardous working conditions. Must have the ability to sit for long periods. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential function.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: $73,102 - $171,058 / ANNUALActual compensation may vary from posting based on geographic location, work experience, education and/or skill level.