> Markdown version of [/jobs/ext/3762516-jr-commissions-data-analyst](https://www.wearedevelopers.com/jobs/ext/3762516-jr-commissions-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Jr. Commissions Data Analyst - **Company:** Simplicity Group - **Location:** San Diego, CA, United States - **Experience:** Starter - **Salary:** $65,000.0 - $74,880.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Artificial Intelligence, Data Analysis, Audit Trail, Big Data, Customer Data Management, Information Engineering, Data Governance, Data Manipulation Languages, Pivot Tables, Standard Sql, DataOps, Salesforce.Com, SQL Databases, Manual Data Entry, Data Analytics, Data Management - **Published:** October 15, 2026 - **Apply:** https://www.thejobnetwork.com/job/e33ca6f7-15ae-4963-a594-7d956321ae9a/jr-commissions-data-analyst ## About the Role o Bachelor's degree in Accounting, Finance, Business Administration, Data Analytics, or a related field (or equivalent experience). o 1-3 years of experience in commissions, accounting, financial operations, or data operations roles. o Working knowledge of basic accounting concepts, including debits and credits, accruals, receivables and payables, account reconciliation, and period close. o Strong Excel and data manipulation skills (lookups, pivot tables, SUMIFS); comfort working with large datasets. · Preferred: o Experience with insurance or annuity commission structures (first-year vs. renewal/trail, hierarchies and overrides, chargebacks). o Hands-on experience with Salesforce. o Basic SQL; experience using Salesforce Data Loader, DemandTools, or similar tools. o Experience working in an IMO, BGA, or other multi-entity insurance distribution organization. o Proficiency using AI tools to speed up data analysis, write and troubleshoot formulas or SQL, and document processes, with sound judgment in validating AI-generated output. Core Competencies: · Analytical & Critical Thinking: Ability to reconcile complex datasets, perform root cause analysis on variances, and devise effective solutions for commission data issues. · Meticulous Attention to Detail: Proven ability to identify subtle data anomalies, patterns, and inconsistencies with a high degree of accuracy, including small dollar variances. · Collaboration & Communication: Excellent verbal and written skills to explain findings to Commissions, Accounting, and non-technical stakeholders and work effectively across departments. · Integrity & Confidentiality: Handles sensitive compensation and financial data with discretion and sound judgment. ## Description Summary / Job Objective: The Junior Commissions Data Analyst plays a key role in ensuring the accuracy, completeness, and integrity of commission data within Simplicity's enterprise Salesforce platform and supporting systems. This position supports the technology and commissions teams by executing hands-on validation, reconciliation, and correction of commission data received from insurance carriers and paid to Simplicity's agencies and advisors. Essential Job Functions: * Stand or sit in a stationary position for extended periods * Clearly communicate and exchange accurate information with others * Work closely with colleagues and external parties * Operate computer and/or other office equipment constantly * Regularly use wrists, hands, and/or fingers for repetitive motions * Assist colleagues, clients, third parties via telephone, email and/or in person * Ability to observe details within a close range * Analyze and interpret data * Communicate and present in a group setting Primary Responsibilities: · Commission Data Quality & Reconciliation o Review and validate carrier commission statements and data feeds for completeness and accuracy after they are loaded into Salesforce. o Reconcile commissions received against expected amounts based on commission schedules, premium, and hierarchy/split arrangements; research and resolve variances. o Identify and correct commission data errors such as unmatched or misattributed policies, incorrect writing agent numbers, split percentages or rates, and duplicate or missing transactions. o Track and verify chargebacks, reversals, advances, and manual adjustments, ensuring they are properly applied and documented. o Perform manual data entry and record updates as needed, such as applying one-off corrections, with a high degree of accuracy. · Collaboration & Process Execution o Partner with Commissions, Accounting, Licensing, and New Business departments to identify, prioritize, and resolve commission data issues. o Work with carrier contacts and internal stakeholders to research discrepancies and obtain corrected statements or data. o Coordinate with the data engineering team and system administrators to design, test, and implement correction workflows and automated validation rules. o Assist with data imports, updates, and transformations using Salesforce Data Loader, Validity's DemandTools suite, and basic SQL. · Governance & Controls Support o Apply data governance policies and financial control standards to day-to-day commission data operations. o Document commission data definitions, reconciliation procedures, and an audit trail of corrections and adjustments. o Participate in ongoing data stewardship and process improvement initiatives as assigned by the VP of Technology Solutions.