IT Systems Analyst III – Customer Data Hub (Data & Analytics) - Remote

CSAA Insurance Group, a AAA Insurer•Washington, DC

4d•$89,865 - $119,800•Remote

About The Position

The Customer Data Hub is a foundational enterprise capability responsible for mastering customer data and distributing it across core applications, customer communication platforms, and analytics consumers. In this role, you will partner with technical and business teams to onboard new source systems and data consumers, define and validate integrations, establish data quality expectations, and support reliable, stable operations—ensuring teams across the organization can confidently use customer data every day.

Requirements

Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).
7+ years of experience in systems analysis and/or data-focused technical roles, including requirements, documentation, and partner collaboration.
Consistent track record of writing clear, structured user stories with strong acceptance criteria.
Solid experience translating business needs into data requirements and creating source-to-target mappings that support integration and analytics use cases.
Working knowledge of data mastering and transformation concepts (standardization, validation, enrichment, reconciliation) and how to test/verify outcomes using data analysis.
Solid background in data integration (batch, API, events) and data quality principles; able to define validation, reconciliation, and monitoring needs for critical customer data flows.
Experience with Master Data Management solutions (e.g., Reltio), including supporting mastering/match-merge outcomes and data stewardship workflows.
Comfortable working with APIs and integration specifications (schemas/payloads, status codes, error handling) and partnering with engineers to solve data/interface issues.
Advanced SQL and data analysis skills to profile data, validate outcomes, and support root-cause analysis across source, hub, and consumer systems.
Experience in production support (incident triage, root cause analysis, and documenting fixes/runbooks) for data pipelines and/or integration platforms.
Familiarity with data governance practices and handling sensitive customer data in accordance with privacy/security requirements.
Experience with Snowflake or comparable cloud data warehouse technologies.
Experience working with agile teams, partnering with BRMCs, data engineers, QA, and technical partners.
Good communication skills—able to align priorities, explain technical tradeoffs, and coordinate delivery across multiple application teams and data partners.
Strong analytical and problem‑solving skills with exceptional attention to detail.
A proactive, dedicated attitude and the ability to quickly learn new tools and concepts.

Nice To Haves

Actively shapes our company culture (e.g., participating in employee resource groups, volunteering, etc.)
Lives into cultural norms (e.g., willing to have cameras when it matters: helping onboard new team members, building relationships, etc.)
Travels as needed for role, including divisional / team meetings and other in-person meetings
Fulfills business needs, which may include investing extra time, helping other teams, etc.

Responsibilities

Work within an agile environment to design, document, and support Customer Data Hub capabilities that enable multiple application teams, customer communications, and analytics/reporting consumers.
Partner with product and business partners (including Business Relationship Management Consultants and data stewards) to understand customer data needs and translate them into clear, comprehensive user stories.
Lead the creation and refinement of user stories, ensuring they are complete, prioritized, and traceable, with dependencies and impacts understood across upstream source systems and downstream consumers.
Define robust acceptance criteria that cover functional behavior, data accuracy and data quality, transformation expectations, integration/error handling scenarios, and non-functional requirements.
Perform customer data mapping and lineage analysis, identifying sources, documenting attributes and definitions, and tracing how customer data moves from source applications into the hub and out to downstream consumers.
Analyze and define customer data mastering and transformation logic (standardization, validation, enrichment, and reconciliation) so downstream systems receive accurate, complete, and well-structured data.
Support platform modernization and data enablement initiatives, including adopting cloud-based data platforms, improving data pipelines, and enabling scalable analytics consumption.
Validate integrations and data outcomes by reconciling source vs. hub vs. downstream results, verifying match/merge behavior where applicable, and ensuring fixes are regression-tested.
Collaborate with engineers and architects on hub configuration and solution design, integration patterns, SQL reviews, and debugging during development and production support cycles.
Partner with QA teams to validate solution quality using the acceptance criteria you authored.
Support stable operations for the Customer Data Hub through incident triage, root cause analysis, impact assessment, and clear communications; create and maintain runbooks, data dictionaries, and interface documentation to enable repeatable support and reduce repeat issues.
Continuously learn and improve, adapting to new tools and platforms while helping evolve shared standards for customer data definitions, quality, and integrations.
Apply data governance and privacy/security practices when documenting, analyzing, and troubleshooting sensitive customer data, partnering with data stewards and control teams as needed.