Data Analyst
Region VII Area Agency on Aging is accepting applications for a highly motivated Data Analyst. Choose a challenging and rewarding career where you can enjoy a deep sense of personal satisfaction by making a positive and meaningful difference in the lives of others. We are a growing non-profit organization located in Bay City, MI.
Purpose of the position
This position is responsible for reviewing departmental processes, such as ensuring the validity of claims and encounter processing, identifying and disseminating information related to trends, oversight of financial obligations and discrepancies and comprehensive administrative, technical support for the Waiver department programs and assist in Waiver cost settlement and enrollment appeals as necessary. They are ensuring accurate and timely invoices and payment processes within the agency. They collaborate closely with various departments to streamline procedures and resolve any discrepancies efficiently.
RESPONSIBILITES AND DUTIES:
- Assist with Software/Information Technology provider(s), including participation in the development/refinement of current programs and need for timely updates.
- Assist Contract and Billing Manager with communication to Michigan Department of Health & Human Services (MDHHS) staff as related to funding and payment, including the oversight, monitoring, and processing of enrollment and payment reports and cost reconciliation.
- Provide support during audits and financial reporting processes. Assists as needed with Fiscal Department requests.
- Participate in internal and external quality management audits and activities.
- Develop, produce, and disseminate pertinent reports to assist agency staff in ensuring quality and adherence to established guidelines and protocols, including but not limited to participant status, coding, and nursing facility level of care.
- Investigate and resolve billing discrepancies through data analysis, working with internal teams and providers.
- Conduct routine review of systems data utilizing system or ad hoc reports to ensure accuracy/perform data maintenance.
- Maintain, produce and submit reports as needed for agency programs, such as reporting for External Quality Review Organization (EQRO), Electronic Visit Verification (EVV) and other reporting as requested.
- Generate, distribute invoices, provide follow-up, provide reports, and communicate with Wavier and Fiscal departments regarding payments received, outstanding invoices, etc. for waiver participants serving a divestment.
- Participate in Office of Inspector General (OIG) reporting and program integrity activities.
- Connect multiple data sources to create comprehensive analytical solutions.
- Analyze billing data to ensure accuracy and completeness.
- Assist with process improvements, such as automating billing tasks or optimizing workflows.
- Ensure that all submitted encounter data is timely, accurate and complete.
- Review, respond and reconcile encounter submission responses in accordance with the Michigan Department of Health and Human Services (MDHHS) guidance and standards of promptness.
- Assist and enter Community Transition Services Program billing into billing systems.
- All other duties as assigned.
QUALIFICATIONS AND SKILLS:
- Possession of an associate’s degree preferred, or equivalent combination of education and experience as acquired with one to two years’ relevant work experience in an office setting with billing experience.
- Familiarity with medical terminology, Medicare and Medicaid policies.
- Strong analytical and problem-solving abilities
- Excellent in written and verbal communication
- Ability to translate technical concepts for non-technical audiences
- Demonstrated experience in multi-source data integration
- Experience with data visualization tools and platforms
- Ability to analyze data, identify patterns, and draw conclusions.
- Ability to communicate effectively with internal teams and providers.
- Proficiency in Microsoft Word, Excel, Power Point, Outlook, and SharePoint for document creation, data analysis, presentations, email management and collaboration.
- Fundamental understanding of the Excel environment and demonstrate proficiency in applying its main features. This includes creating and managing worksheets, cells, ranges, tables, formulas, functions, charts, and objects.
- Be willing and able to travel within all ten counties of the region (and at times out of region) in reliable transportation
This description is intended to describe the essential job functions. It is not an exhaustive list of duties, responsibilities or requirements. Other functions may be assigned, changed or added at any time as HR department sees fit.
OSHA CATEGORY: This position in the regular course of business would not encounter any tasks or situations involving exposure to bodily fluids.
PHYSICAL DEMANDS: The duties of this position are consistent with those of a regular office work environment. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.