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

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

04 Dec 2024
Michigan, Detroit metro, 48201 Detroit metro USA

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.

Related jobs

  • Financial and Business Operations Analyst (Program Analyst IV)

  • SUMMARY

  • We Are:

  • Blue Cross Blue Shield of Michigan (BCBSM) has a Business Analytics Analyst opportunityavailablewithin our UAW Trust Consulting & Reporting area, which is part of the Analytics Center of Excellence (ACoE). About the Role Responsible for analyzing data to inform key strategic business decisions. Under general supervision, performs descriptive analyses, develops savings models, and evaluates program outcomes and size potential opportunities. Works across teams of data engineers and data scientists to identify and present actionable data to clinical and financial stakeholders. Please Note: Hybrid work structure, which requires working 2-days per week on-site at our downtown Detroit office (we provide free parking). In this Business Analytics Analyst opportunity, you will: Support the translation of business ideas to working hypotheses With supervision, produce statistical analyses and visualizations from the broader analysis plan Identify and analyze data patterns to test business and program hypotheses Perform data querying and manipulation of structured and unstructured data sets Support the synthesis of analysis results into insights for business decisions QUALIFICATIONS Bachelor\'s Degree in Statistics, Economics, Actuarial Science, Informatics, Epidemiology, Biostatics, Data Science, or other related field is required A minimum of one (1) year of related work experience Previous experience programming (at least one of: Python, R, SQL, SAS) is required Previous experience working in the healthcare industry is preferred Basic knowledge of how health care claims are billed and how the health system works Strong analytical, organizational, and problem-solving skills Basic knowledge about different evaluation study designs (i.e., case-control, cohort), methodologies for controlling for population differences in studies (i.e., regression analysis, propensity score matching), and programming (SQL, SAS, R or Python) Basic knowledge of statistical testing techniques (i.e. ANOVA t-tests, chi-squared, etc.) Intermediate skills in Microsoft Office Ability to develop creative solutions to problems lacking clear parameters Ability to effectively interface and present to management at all levels of the organization Ability to work independently and in a team environment Positive attitude, adaptable to change All qualified applicants will receive consideration for employment without regard to, among other grounds, race, color, religion, sex, national origin, sexual orientation, age, gender identity, protected veteran status or status as an individual with a disability.

  • Design & Usability Analyst Sr.

  • Job Description

  • JOB DESCRIPTION Job Summary Designs and implements processes and solutions associated with a wide variety of data sets used for data/text mining, analysis, modeling, and predicting to enable informed business decisions. Gains insight into key business problems and deliverables by applying statistical analysis techniques to examine structured and unstructured data from multiple disparate sources. Collaborates across departments and with customers to define requirements and understand business problems. Uses advanced mathematical, statistical, querying, and reporting methods to develop solutions. Develops information tools, algorithms, dashboards, and queries to monitor and improve business performance. Creates solutions from initial concept to fully tested production, and communicates results to a broad range of audiences. Effectively uses current and emerging technologies. KNOWLEDGE/SKILLS/ABILITIES

Job Details

Jocancy Online Job Portal by jobSearchi.