Back to jobs
New

Reporting & EDI Analytics

Baltimore, MD

ASSYST is seeking an experienced Senior Systems Analyst – Reporting & EDI Analytics to support our client by designing, developing and maintaining complex reports, dashboards, data extracts and analytical solutions. This role is responsible for transforming business and operational data into actionable insights while supporting Electronic Data Interchange (EDI) analysis and data validation activities. The ideal candidate will have strong expertise in SQL, reporting tools, data analysis, dashboard development and healthcare-related data environments.

Roles & Responsibilities:

  • 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.

Required Skills & Qualifications:

Required Experience:

  • 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.

Preferred Qualifications:

  • 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.

ASSYST is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in ASSYST, Inc.’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.