Data Systems Analyst

Summary

Software Guidance & Assistance, Inc. is a technology and resource solutions provider searching for a Data Systems Analyst for a remote opportunity with a premier healthcare client. The role leads the integration, analysis, mapping, validation, and standardization of healthcare payer and internal enterprise data to support value-based care initiatives and enterprise decision-making. The analyst will also support data governance, quality monitoring, technical specifications, and integration delivery.

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

Skills

• 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
• Ability to stand/sit for extended periods
• Visual acuity and fine motor skills
• Ability to travel as needed

Qualifications

Must Haves

• 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
• Ability to stand/sit for extended periods
• Visual acuity and fine motor skills
• Ability to travel as needed

Benefits

• Remote work opportunity
• Employee development
• A diverse team
• Customer service, employee development, and quality and integrity in everything we do