Senior Business Analyst- Medicaid 8001

Analyst, Systems (Senior) Design, develop, build, and manage complex, operational, and federally mandatedreports.Identify from design, implementation, and post-implementation evaluation a varietyof possible approaches for generating reports, dashboards, and data extractionrequirements.Write a variety of complex queries in SQL for data extractions and develop reports inTableau, and other tools using PostgreSQL and other databases as data sources.Identify opportunities for securely sharing commonly used data internally andexternally.Interpret data, and perform data analysis for management decision-making, policyformulations, and review.Utilize database applications and analytical tools to evaluate data quality, andfunctions and maintain operations.Analyze the business processes to develop data solutions, reports, and dashboards tomeet reporting requirements.Work with multi-disciplinary teams in a fast-paced, technically challengingenvironment delivering data to various internal and external stakeholders.Perform Medicaid 8001 Flat File validation and analysis, review multiple MemberPerson Index(MPI) for SSN matching and Master Data Management (MDM) matching.Perform HBX System Error analysis, validate 1095-A/1095-B files, and reconcileMedicaid 8001 transactions.Assist the development team, EDI operations team, and testing team in analyzing,fixing, testing, and transmitting EDI files on a daily basis.Create data change requests to fix consumer or system-reported errors, coordinatewith technical and business teams to analyze error reports, and access the HBXdatabase and application to perform root cause analysis for transaction rejections.Adhere to all security, change control, and MHBE Project Management Office (PMO)policies, processes, and methodologies.Note: The candidate must be flexible to work overtime as needed, including weekends,holidays, and off-hours.2.6 Personnel Qualifications - Minimum Qualifications
4For minimum qualifications, see the labor category description in MHBE IT IDIQ RFP for the subject RFR laborcategory. In addition, qualified candidates MUST meet the minimum qualifications specified below. Please referto RFP Section 2.6.1 minimum qualifications for substitution requirements.Candidates not meeting minimum qualifications will be deemed not reasonably susceptible for the award andwill not progress to full evaluation.Labor Category/s(From Section 1 Above)Minimum QualificationsAnalyst, Systems (Senior) A minimum of five (5) years of experience performing complex data extractions,analysis, report generation, and dashboard creation.A minimum of five (5) years of experience working in a complex IT organizationdeveloping a variety of queries and custom reports utilizing SQL, stored procedures,and complex queries.A minimum of five (5) years of experience developing various reports and dashboardsutilizing reporting tools such as Tableau, or PowerBI.A minimum of two (2) years of experience translating business requirements intoeffective data visualizations and dashboards.Experience in establishing and maintaining reporting databases and data warehouses.Knowledge of data modeling, data warehousing, and ETL processes.Effective communication and collaboration skills to work with stakeholders andtechnical teams.Demonstrated ability to manage multiple critical priorities and tight deadlines.Demonstrated analytical and problem-solving skills.Preferred QualificationsThe additional Experience/Knowledge/Skills listed below are preferred by MHBE.Analyst, Systems (Senior) A minimum of eight (8) years of hands-on experience designing complex queries andreports using SQL and Stored Procedures.A minimum of four (4) years of experience developing queries and reports in thePostgreSQL database environment.A minimum of four (4) years of experience developing complex reports anddashboards utilizing Tableau, or equivalent.Extensive knowledge of data sources, data flow, data/system interactions, andadvanced reports design techniques to develop complex analytical reporting solutions.Experience with developing reports and dashboards for the health insurancemarketplaces, healthcare, or Health and Human Services domains.Hands-on experience with data visualization, data analysis, and report automation.Experience with web technologies, such as HTML, CSS, and JavaScript.Familiarity with programming languages such as Python, Java, or equivalent.Knowledge of EDI transaction sets such as 834, 820, and 999.Knowledge of Medicaid and Qualified Health Plan (QHP) eligibility rules.Knowledge of EDI 834 enrollment transactions, including Adds, Terminations,Cancellations, and life events.