IT Systems Analyst III - Customer Data Hub - Data and Analytics

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

Location: United States

Job Description:

Job Information

CSAA Insurance Group (CSAA IG), a AAA insurer, is one of the leading personal lines property and casualty insurance groups in the United States. Here, every employee shapes our mission. We build innovative, human-centered solutions that help AAA members prevent, prepare for, and recover from life's uncertainties. You will join a collaborative, inclusive culture where your strengths have room to grow and your ideas can drive real impact. Step into a role where you can contribute to our shared success through meaningful work.

We are actively hiring for a IT Systems Analyst III - Customer Data Hub (Data & Analytics) - Remote

Your Role: 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.

Your Work:

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

Required Experience, Education and Skills

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

What would make us excited about you?

• 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

Please note we are hiring for this role remote anywhere in the United States with the following exceptions: Hawaii and Alaska.

Why Choose a Career at CSAA IG?

At CSAA IG, we are a mission-driven organization proudly committed to empowering our members, our employees, and our communities to thrive.

Recognition: We offer a total compensation package, annual bonus eligibility for most roles, 401(k) with a company match, and so much more!

The national average salary range for this position is $89,865.00-$99,850.00. However, we have a location-based compensation structure. Our salary ranges vary and are calculated based on work location. The starting pay range for this position across all the states we hire in is $89,865.00-$119,800.00.  This role also includes an opportunity for a company-wide annual discretionary bonus, through our Annual Incentive Plan (AIP), of up to 8% of eligible pay.