Senior Data Systems Analyst

Software Guidance & Assistance, Inc. (SGA, Inc.); Chicago (IL); Remote; USD 110,000 - 150,000; Full time

Job summary

Software Guidance & Assistance, Inc. (SGA), is seeking a Senior Data Systems Analyst for a remote opportunity in the Healthcare industry.

You will lead onboarding and integration of payer feeds and internal systems, shaping a reliable enterprise data platform that supports analytics and value-based care. The role requires strong Medicare payer data experience (834/837/HEDIS/RAF), advanced SQL, and knowledge of data governance, cloud platforms like Snowflake/Redshift, and agile delivery.

Qualifications

• 6+ years of experience in data warehousing, data integration, or analytics roles.
• Strong experience with Medicare Advantage payer data, including 834, 837, HEDIS, and RAF datasets.
• Advanced SQL skills and strong understanding of relational database concepts.
• Deep knowledge of enterprise data warehouse and data mart architectures.
• Experience with data governance frameworks and tools (Catalog, Atlan, Collibra, Alation) and data quality frameworks.
• Working knowledge of cloud-based data platforms like Snowflake/Redshift.
• Familiarity with scrum/agile methodologies and Jira.
• Proven ability to lead cross-functional teams and drive agile delivery.
• High level of ownership, initiative, and attention to detail.

Responsibilities

• Lead onboarding and integration of payer feeds, including eligibility and claims data.
• Analyze and map data from payer sources and internal systems into the enterprise data model.
• Own and maintain source-to-target mappings and transformation logic.
• Identify data quality issues and drive normalization within the data warehouse.
• Validate data ingestion and transformations through profiling and reconciliation.
• Partner with data engineering to ensure scalable, well-documented ingestion pipelines.
• Serve as SME for integrated payer and internal data to support analytics and reporting.
• Lead discovery sessions with customers to document technical specs and business requirements.
• Translate clinical, operational, and business requirements into data specifications.
• Define data quality rules and monitoring for all pipelines.
• Develop data governance policies including metadata management and lineage.

Skills

SQL

Data warehousing

Data integration

Analytics

Medicare data

Agile / Scrum

Jira

Data governance

Education

Bachelor's degree or equivalent experience

Tools

Snowflake

Redshift

Job description

Software Guidance & Assistance, Inc., (SGA), is searching for a Senior Data Systems Analyst for a remote opportunity with one of our premier clients in the Healthcare industry.

Multiple rounds of interviews - final round onsite required (multiple office options).

The Senior Data Systems Analyst leads the integration of healthcare payer data and internal enterprise systems into Client's enterprise data platforms. This role is responsible for analyzing, mapping, validating, and standardizing complex payer data feeds—including eligibility, claims, quality, and risk adjustment data—alongside data from internal systems such as EMR, CRM, HR, and other enterprise applications.

Plays a key role in establishing and maintaining a reliable, standardized single source of truth that supports value-based care, analytics, operational reporting, and enterprise decision-making. The ideal candidate combines strong healthcare data knowledge and technical expertise with the ability to take ownership of complex payer and enterprise system integrations. Will independently manage multiple concurrent data initiatives, coordinate across business and technical teams, and drive data integration efforts from analysis and mapping through validation, implementation, and ongoing support.

Job Description

• Lead onboarding and integration of various payer feeds, including eligibility (834 or flat files), medical and institutional claims (837 or flat files), 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
• Own and 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 drive normalization within the data warehouse
• Validate data ingestion and transformations through profiling, reconciliation, and exception analysis
• Partner closely with data engineering to ensure scalable, accurate, and well documented 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
• Translate 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 integration stories are delivered on time and are fully prepared for engineering implementation

Job Requirements

• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent experience
• 6+ years of experience in data warehousing, data integration, or analytics roles
• Strong experience working with Medicare Advantage payer data, including 834, 837, HEDIS, and RAF datasets
• Advanced SQL skills and strong understanding of relational database concepts
• Deep knowledge of enterprise data warehouse and data mart architectures
• Experience with data governance frameworks and tools (e.g., Catalog, Atlan, Collibra, Alation) and data quality frameworks.
• Working knowledge of cloud-based data platforms like snowflake/redshift etc.
• Familiarity with scrum/agile methodologies and Jira
• Proven ability to lead cross-functional teams and drive agile delivery
• 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

Travel may be required up to 15% locally or nationally.

Remote or Hybrid.

By applying for a job with SGA, you agree to allow SGA to process your application for this and future opportunities in accordance with our Privacy Policy. Also, to ensure timely processing, you agree to be contacted by our AI recruiter via email, text, or phone. Message frequency varies and data rates may apply, but you can reply STOP to any SMS message to opt-out of texts and may contact SGA at [e-mail] to opt-out of AI communications. The choice not to engage with AI will not adversely impact your consideration for placement. AI is not used to make any hiring determinations. SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at https://sgainc.com/ . SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.