Python Senior Technical Lead - Data Analysis, SQL

Job Summary

• Strong data analysis skills with the ability to interpret complex data structures and legacy specifications.

Key Responsibilities

Key Responsibilities

• Review and understand the Annuity Data Domain Model and associated enterprise mapping documents.

• Analyze Transcend specification documents for existing outbound data feeds.

• Translate Transcend feed specifications into ALIP‑based technical specifications aligned to the existing structures of the downstream feeds

• Prepare detailed source‑to‑target mapping documents for 275+ data feeds, including:

• Attribute‑level mappings

• Data type alignment

• Business rules and transformations

• Inclusion / exclusion criteria

• Key and relationship mappings

• Validate mappings against actual data by querying:

• Transcend (Oracle) source tables

• ALIP data domain in Lake or reference datasets

• Identify gaps, ambiguities, or inconsistencies in legacy specifications and work with stakeholders to resolve them.

• Ensure mappings adhere to enterprise data standards, naming conventions, and data governance guidelines.

• Support downstream development and testing teams by clarifying specifications and resolving data questions.

Skill Requirements

Required Skills & Experience

Core Skills

• Strong data analysis skills with the ability to interpret complex data structures and legacy specifications.
• Basic to intermediate SQL skills for:
• Querying Oracle databases (Transcend)
• Querying data in the enterprise Data Lake
• Ability to read and understand technical specifications, data models, and mapping documents.

Domain & Technical Knowledge

• Familiarity with relational databases and normalized data models.
• Exposure to insurance or annuity data domains is a strong plus

Other Requirements

Domain & Technical Knowledge

• Familiarity with relational databases and normalized data models.
• Exposure to insurance or annuity data domains is a strong plus