We are looking for a detail-oriented Data Analyst to support commission-related reporting and financial data review within the insurance industry in Elmwood Park, New Jersey. This Long-term Contract position is ideal for someone who enjoys working with complex datasets, identifying inconsistencies, and helping maintain accurate commission operations. The role combines analytical problem-solving, reporting, and cross-functional coordination to ensure commission activity is processed correctly and on time.<br><br>Responsibilities:<br>• Examine insurance commission data and validate calculations to support accurate statement processing.<br>• Investigate mismatches, payment issues, and reporting variances by researching broker and carrier records.<br>• Review new policy activity and account updates to confirm commission handling aligns with business rules.<br>• Reconcile internal commission information against carrier submissions and address exceptions promptly.<br>• Produce recurring monthly reports that highlight operational results and commission activity.<br>• Manage detailed carrier statement uploads and process high-volume or complex commission transactions.<br>• Support audit requests by gathering documentation and verifying the accuracy of commission records.<br>• Perform month-end reporting checks and system-level data reviews to improve accuracy and completeness.<br>• Build and maintain Excel-based analysis tools, using advanced formulas and macros to organize and interpret data.<br>• Monitor commission deposits, payment activity, and special reporting requests as needed.
<p>This Long-term Contract position focuses on interpreting business data, preparing meaningful reports, and sharing actionable insights with internal teams. The role offers the opportunity to work across recurring analysis needs as well as special projects in a fast-paced environment.</p><p><br></p><p>Responsibilities:</p><p>• Analyze large sets of operational and business data using Excel and other reporting tools to identify trends, exceptions, and opportunities.</p><p>• Gather information from multiple sources, organize findings, and present clear updates to stakeholders and team members.</p><p>• Create and maintain reports, spreadsheets, and dashboards that support ongoing business monitoring and decision-making.</p><p>• Partner with internal teams to respond to ad hoc analysis requests and deliver timely, accurate results.</p><p>• Assist with special projects by compiling data, validating information, and summarizing outcomes in an easy-to-understand format.</p><p>• Support data activities related to enterprise systems, including SAP-based reporting or training-related tasks when needed.</p><p>• Help improve reporting consistency by checking data quality and ensuring information is current and reliable.</p>