Note: The job is a remote job and is open to candidates in USA. CSAA Insurance Group, a AAA insurer, is one of the leading personal lines property and casualty insurance groups in the United States. They are seeking an IT Systems Analyst III to manage customer data across core applications and analytics consumers, ensuring data quality and supporting operations. The role involves collaborating with various teams to define data needs, validate integrations, and support platform initiatives.
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
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
- 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
Benefits
- Annual bonus eligibility for most roles
- 401(k) with a company match
- Total compensation package
- Flexible Workplace - Most employees hold Home-Flex roles, working primarily from home, often with the flexibility to work from various locations including CSAA offices
- Leaders and mentors partner with employees to align interests, unlock development opportunities, and support long‑term success
- Reasonable accommodations to qualified applicants and employees with disabilities or other limitations
- Company-wide annual discretionary bonus, through our Annual Incentive Plan (AIP), of up to 8% of eligible pay
Company Overview