Design, develop, build, and manage complex, operational, and federally mandated reports.
Identify from design, implementation, and post-implementation evaluation a variety of possible approaches for generating reports, dashboards, and data extraction requirements.
Write a variety of complex queries in SQL for data extractions and develop reports in Tableau, and other tools using PostgreSQL and other databases as data sources.
Identify opportunities for securely sharing commonly used data internally and externally.
Interpret data, and perform data analysis for management decision-making, policy formulations, and review.
Utilize database applications and analytical tools to evaluate data quality, and functions and maintain operations.
Analyze the business processes to develop data solutions, reports, and dashboards to meet reporting requirements.
Work with multi-disciplinary teams in a fast-paced, technically challenging environment delivering data to various internal and external stakeholders.
Perform Medicaid 8001 Flat File validation and analysis, review multiple Member Person Index(MPI) for SSN matching and Master Data Management (MDM) matching.
Perform HBX System Error analysis, validate 1095-A/1095-B files, and reconcile Medicaid 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, coordinate with technical and business teams to analyze error reports, and access the HBX database 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. |