Remote Metadata Jobs in Chicago, IL (NOW HIRING)

• Blended Analyst (stakeholders) and Systems (platforms)
• ***Patient memberships information, medical claims, pharmacy claims - required
• Data sets - cms, medicare, MOR, MMR, MAO, payer side experience people might be familiar with it.
• 834, 835, 837 claims transaction EDI sets - how much do they know, are they just moving files or really know content of data - not just edi processing analysts moving it. Need to the full process of the transaction.
• Less requirements and more Programmer/Analyst people fit this title.
• **Getting API, flat files integrated into data warehouse or data model
• Experience with Data warehouse to external healthcare clients, vendors - comm skills absolutely important.
• Attention to detail
• Strong SQL, know the full process of the data.
• Not to analyze the financials of the data - given data or API integration to destination data warehouse or crm system. Need average + data modeling, and good experience with data warehousing to design feeds to push and pull data from systems. Speak knowledgeably about data systems. Design questions that come up from clients.
• Snowflake would be great, but any data warehouse. Redshift, SQL Server, any database will do.
• BI - tableau, but won't require it at all.
• Excel will be key, sourcing target mapping requirements.
• 4-5 years experience

Job Title:

Data Systems Analyst

Location:

Remote

Job Summary

The Data Systems Analyst leads the integration of various healthcare payer data and internal enterprise systems data into enterprise data platforms. This role is responsible for analyzing, mapping, validating, and standardizing various payer feeds including eligibility, claims, quality, and risk adjustment data, alongside internal systems such as EMR , CRM, HR etc. to maintain a reliable single source of truth supporting value based care.

The ideal candidate will combine strong healthcare data knowledge, technical expertise, a collaborative mindset, and a desire to grow within a complex and mission-driven data environment.

Essential Duties and Responsibilities

Key Responsibilities:

• Onboarding and integration of various payer feeds, including eligibility (834 or flat files), medical and institutional claims (837 or flatfiles), HEDIS quality data, HIE, and risk adjustment and RAF related datasets
• Analyze and map data from external payer sources and internal systems such as EMR, CRM, and operational platforms into the enterprise data model
• Maintain source to target mappings, transformation logic, and standardized data definitions across payer and internal feeds
• Identify payer specific variations, data quality issues, and structural differences, and support normalization within the data warehouse
• Validate data ingestion and transformations through profiling, reconciliation, and exception analysis
• Partner closely with data engineering and senior analysts to ensure scalable, accurate, and well documented scenario documents and ingestion pipelines
• Serve as a subject matter expert for integrated payer and internal data, supporting analytics, reporting, and operational use cases
• Lead discovery sessions with customers to document technical specifications, data elements, and business requirements
• Support translation of clinical, operational, and business requirements into clear data and system specifications
• Define and implement data quality rules and monitoring frameworks for all critical data pipelines
• Develop and enforce data governance policies, including metadata management, lineage tracking, and compliance standards.
• Ensure assigned integration stories are delivered on time and are fully prepared for engineering implementation

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent experience
• 4-5 years of experience in data warehousing, data integration, or business intelligence roles
• Experience working with healthcare payer data, including experience working with 834, 837, HEDIS, pharmacy, census and RAF datasets Advanced SQL skills and strong understanding of relational database concepts
• Deep working knowledge of enterprise data warehouse and data mart architecture
• 1+ years of working experience with data governance frameworks and tools (e.g., Catalog, Atlan, Collibra, Alation) and data quality frameworks.
• 2+ years of experience of cloud-based data platforms like snowflake
• Solid SQL skills and understanding of relational database concepts
• Familiarity with scrum/agile methodologies and tools such as Jira
• Proven ability to support integration projects and drive agile delivery
• Strong communication skills with the ability to collaborate across technical and non technical teams
• Strong problem-solving skills, attention to detail, and a proactive approach to ownership
• High level of ownership, initiative, and attention to detail

Physical and Mental Requirements

• Ability to stand/sit for extended periods.
• Visual acuity and fine motor skills.
• Ability to travel as needed.

Work Environment

• Remote
• Travel may be required up to 15% locally or nationally