Reporting & EDI Analytics

ASSYST, Inc.
Baltimore, United States of America
18 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Baltimore, United States of America

Tech stack

HTML
Java
Business Analytics Applications
Data analysis
Databases
Data Validation
Data Infrastructure
ETL
Data Mining
Data Visualization
Data Warehousing
Database Applications
Electronic Data Interchange (EDI)
Python
PostgreSQL
Operational Data Store
Power BI
SQL Stored Procedures
SQL Databases
Data Streaming
Systems Integration
Tableau
Freeform SQL
Stylesheet Language
Advanced Reports
Complex Event Processing
Data Analytics
Data Management
Web Technologies
Tools for Reporting
Custom Reports
Programming Languages

Job description

  • Design, develop, implement and maintain complex operational and federally mandated reports.
  • Analyze reporting requirements and identify effective approaches for report generation, dashboard development and data extraction solutions.
  • Develop complex SQL queries, stored procedures and data extraction processes using PostgreSQL and other database platforms.
  • Create interactive reports and dashboards using Tableau, Power BI, or equivalent reporting tools.
  • Identify opportunities to securely share and distribute data across internal and external stakeholders.
  • Perform data analysis and interpretation to support management decision-making, policy development and operational reviews.
  • Evaluate data quality and system functionality using database applications and analytical tools.
  • Analyze business processes and translate reporting requirements into data-driven solutions, reports and dashboards.
  • Collaborate with cross-functional teams in a fast-paced environment to deliver reporting and analytical solutions.
  • Perform Medicaid 8001 Flat File validation and analysis.
  • Review Member Person Index (MPI) records for SSN matching and Master Data Management (MDM) validation.
  • Conduct HBX system error analysis, validate 1095-A and 1095-B files and reconcile Medicaid 8001 transactions.
  • Support development, testing and EDI operations teams by analyzing, troubleshooting, testing and transmitting EDI files on a daily basis.
  • Create data change requests to resolve consumer-reported and system-generated errors.
  • Coordinate with technical and business teams to analyze error reports and perform root cause analysis for transaction rejections.
  • Access and analyze application and database data to identify and resolve system issues.
  • Ensure compliance with all security, change management, project governance and operational procedures.

Requirements

  • Minimum 5 years of experience in data extraction, data analysis, report generation and dashboard development.
  • Minimum 5 years of experience developing complex SQL queries, stored procedures and custom reports within large-scale IT environments.
  • Minimum 5 years of experience developing reports and dashboards using Tableau, Power BI, or similar reporting platforms.
  • Minimum 2 years of experience translating business requirements into meaningful dashboards and data visualizations.
  • Experience designing, implementing and maintaining reporting databases and data warehouses.
  • Strong understanding of data modeling, data warehousing and ETL processes.
  • Excellent analytical, problem-solving, communication and stakeholder management skills.
  • Ability to manage multiple priorities and deliver results within tight deadlines., * 8+ years of hands-on experience designing and developing complex SQL queries, stored procedures and reporting solutions.
  • 4+ years of experience working with PostgreSQL databases for reporting and4+ years of experience developing advanced Tableau dashboards and analytical reports..
  • Extensive knowledge of data sources, data flow, system integrations and advanced reporting methodologies.
  • Experience supporting health insurance marketplaces, healthcare organizations, or Health and Human Services programs.
  • Hands-on experience with data visualization, report automation and advanced data analytics.
  • Familiarity with web technologies such as HTML, CSS and JavaScript.
  • Experience with programming languages such as Python, Java, or equivalent technologies.
  • Knowledge of EDI transaction sets including 834, 820 and 999.
  • Understanding of Medicaid and Qualified Health Plan (QHP) eligibility processes.
  • Knowledge of EDI 834 enrollment transactions, including Adds, Terminations, Cancellations and Life Event processing.

Apply for this position