Broker Data Delivery Analyst- Remote

About this role

Responsibilities

• Maintains expert working knowledge of how member, policy, premium, and agent assignment data originates in source systems and flows through staging, transformation, and delivery into SAP APM (Callidus) for broker commission processing
• Investigates and resolves broker portal data discrepancies including commission display errors, book of business inaccuracies, agent/firm association issues, and any additional data problems
• Writes and maintains intermediate to advanced SQL queries various data sources, relevant stages, and related databases to support commission file generation, reconciliation, reporting, and audit activities
• Applies AI-assisted query and data analysis tools to accelerate investigation of large datasets, identify patterns in commission anomalies, and surface data quality issues that would be difficult to detect through manual review alone
• Supports internal and external audit activities by providing data extracts, documentation, and analysis as needed