Associate Business Analyst

Monroe Plan for Medical Care is a not-for-profit care management agency focused on improving access to quality healthcare for individuals and families served by government-sponsored insurance programs. The Associate Business Analyst supports business requirements gathering, report and data validation, testing, SQL-based analysis, documentation, project coordination, and HIPAA-compliant data handling while developing greater independence under the guidance of senior staff.

Responsibilities:

• Meet with internal stakeholders and end users to collect and record business needs, current processes, and desired outcomes
• Draft requirements documents, user stories, acceptance criteria, and specifications for review by senior staff
• Ask clarifying questions to resolve gaps, ambiguities, and conflicting information before work is handed to developers or analysts
• Document data definitions, business rules, calculation logic, and report specifications
• Confirm completed work against documented requirements and communicate discrepancies
• Review reports, dashboards, and data extracts for accuracy, completeness, and reasonableness prior to release
• Compare output against source data and expected results and document any variances found
• Execute test plans and test cases for new and modified reports, applications, and data processes
• Coordinate and support user acceptance testing, including preparing test scenarios and collecting stakeholder feedback
• Log defects with clear reproduction steps and track them through resolution and retest
• Fulfill ad hoc data and reporting requests under the direction of senior analysts
• Write and modify basic SQL queries to retrieve, summarize, and cross-check data
• Build and maintain recurring reports, trackers, and summary files in Excel and organizational reporting tools
• Assemble and format data for distribution to internal departments, program leadership, and external partners
• Identify data quality issues, anomalies, and trends observed during routine work and escalate them appropriately
• Create and maintain process documentation, workflow diagrams, data dictionaries, and report inventories
• Write end-user instructions, job aids, and knowledge base articles for supported systems and reports
• Maintain version control and organization of departmental documentation and shared files
• Document meeting notes decisions, and follow-up items and distribute them to participants
• Keep documentation current as systems, reports, and business processes change
• Maintain accurate work item, request, and issue records in the team project tracking system
• Perform initial intake and triage of incoming report, data, and enhancement requests and route them for prioritization
• Track task status, deadlines, and outstanding dependencies and provide status updates to the team
• Schedule and prepare materials for project meetings, requirements sessions, and stakeholder reviews
• Follow up on open items to keep projects and requests moving toward completion
• Handle protected health information and member-related data in accordance with HIPAA and the Minimum Necessary standard
• Follow organizational policies for data access, storage, transmission, and disposal
• Avoid exposure of confidential data, credentials, and member identifiers in documentation, test files, screenshots, and email
• Report suspected data quality, privacy, or security concerns promptly to a supervisor
• Complete all required compliance, privacy, and security training
• Attend regularly scheduled department and intradepartmental meetings
• Work effectively in a team environment while performing multiple tasks
• Participate in training, mentoring, and skill development activities provided by the department
• Work collaboratively with internal and external staff from diverse healthcare, operational, and technical backgrounds
• Work on multiple assignments in an organized manner, maintaining excellent communication with team members
• Seek guidance and escalate promptly when an assignment is unclear or exceeds current skill level
• Performs other duties as assigned

Requirements:

• • Bachelor's degree in Business Administration, Information Systems, Data Analytics, Health Information Management, Public Health, or related field; equivalent combination of education and experience may be considered
• • 0-2 years of professional experience; internships, academic projects, or relevant coursework may substitute for professional experience
• • Proficiency with Microsoft Excel, including sorting, filtering, pivot tables, and common formulas
• • Foundational understanding of relational data concepts, with demonstrated willingness and ability to develop SQL query skills
• • Strong written and verbal communication skills, including the ability to capture clear notes and produce organized, readable documentation
• • Strong attention to detail and accuracy when reviewing data, reports, and test results
• • Ability to organize and track multiple assignments and to ask clarifying questions when requirements are incomplete or unclear
• • Ability to work collaboratively and to accept direction, coaching, and constructive feedback from senior team members
• • Ability to handle confidential information and protected health information in accordance with HIPAA requirements
• • Coursework, certificate, or intership experience in data analytics, business analysis, health informatics, or information systems
• • Introductory experience writing SQL SELECT queries against a relational database
• • Exposure to reporting or visualization tools such as SSRS, Power BI, or Tableau
• • Familiarity with healthcare, managed care, Medicaid, or care management programs
• • Experience with Jira, or exposure to comparable project tracking, ticketing, and work management tools
• • Familiarity with process mapping or diagramming tools such as Visio or LucidChart
• • Exposure to Agile or Scrum delivery practices