Sr Data Analyst- Brokerage Carrier Intergration

Position Compensation Range:

Pay Rate Type:

Compensation may vary based on the job level and your geographic work location. Relocation support is offered for eligible candidates.

• Job Description Summary

  The Senior Data Analyst / Brokerage B2B Coordinator plays a crucial role in enhancing the integration between our brokerage unit and insurance carriers. You will ensure the accuracy and completeness of exchanged data, coordinating data flows, resolving data quality issues, and serving as a liaison between departments, partners, and carrier partners.

  Job Description

  Primary Accountabilities

• Conduct accurate business analysis to support decisions using statistical modeling and other business analysis tools.

• Collaborate with partners to define important financial and operational metrics to monitor and report performance.

• Collaborate with partners in the delivery of main performance analysis.

• Build and maintain models used to project our results; enhance the model where there is value in adjusting the models.

• Ensure analysis and reporting accuracy and integrity and explain performance drivers and provide insights into performance trends.

• Analyze and address data quality issues, tests and analyze impact of system changes to data/reporting infrastructure.

• Develops, tests, and deploys automated reporting solutions and automated decision analytics to replace manual business processes.

• May be requested to complete other assignments or participate in projects based on skills, achievements, or experience.

• Data Processing Operations:

  • Oversee daily data exchanges between insurance carrier partners and American Family, ensuring and accurate transmissions.

  • Monitor data processing to identify potential bottlenecks or issues.

  • Communicate and escalate data transmission issues to relevant partners.

  • Collaborate with IT and other departments to increase data exchange processes.

  • Ensure seamless data integration and synchronization across systems.

• Data Validation and Quality Assurance:

  • Communicate data validation requirements to IT partners to ensure data accuracy and completeness as part of the carrier data ingestion flow.

  • Identify and investigate data quality issues, such as missing, incorrect, or inconsistent data.

  • Develop data quality reports to track progress and identify improvement areas.

  • Conduct regular data audits to ensure compliance with data quality standards.

• Data Quality Improvement:

  • Coordinate carrier integration testing

  • Collaborate with insurance carriers and our teams to implement data quality improvements.

  • Identify new technologies or processes to enhance data quality.

  • Develop data quality improvement plans and programs.

• Carrier Communication and Planning:

  • Be a contact for insurance carriers and team members regarding data quality issues.

  • Communicate data quality issues and progress updates to relevant departments.

  • Collaborate with carrier partner to develop and implement integration improvement roadmaps/plans.

  • Develop relationships with insurance carrier partners.

  • Facilitate collaboration to address data quality challenges.

• Data Governance:

  • Understand data governance procedures.

  • Participate in data governance meetings and programs.

  • Advocate for data quality best practices.

  • Ensure compliance with regulatory requirements and industry standards.

• Documentation:

  • Maintain accurate documentation of data quality processes, procedures, and reports.

  • Ensure compliance with data quality standards and regulations.

  • Maintain data quality documentation, including data dictionaries and process flows.

  • Provide training and support to team members on data quality best practices.

• Metrics:

  • Create and report on data quality metrics to monitor and improve data quality standards.

  • Analyze data quality trends and provide applicable insights to partners.

  • Develop dashboards and visualizations to communicate data quality performance.

• Specialized Knowledge & Skills Requirements

• Demonstrated experience providing customer-oriented solutions or service.

• Solid knowledge of forecasting techniques or statistical analysis.

• Demonstrated experience using data tools to build complex formulas and create reports.

• Understanding of software tools to query and report data.

• Knowledge of a variety of standard reporting software packages and best practices for report deployment processes.

• Demonstrated experience developing data sets.

• Required Skills:

  • Proficiency in EDI or ACORD electronic commerce standards is required.

  • Experience in the P&C insurance sector is required.

  • Experience supporting agency downloads.

• Travel Requirements

  • Up to 10%.

• Physical Requirements

  • Work that involves sitting/standing.

• Working Conditions

  • Not Applicable.

• Offer to selected candidate will be made contingent on the results of applicable background checks

• Offer to selected candidate is contingent on signing a non-disclosure agreement for proprietary information, trade secrets, and inventions

• Sponsorship will not be considered for this position unless specified in the posting

We encourage you to apply even if you do not meet all of the requirements listed above. Skills can be used in many different ways, and your life and professional experience may be relevant beyond what a list of requirements will capture. We encourage those who are passionate about what we do to apply!

We provide benefits that support your physical, emotional, and financial wellbeing. You will have access to comprehensive medical, dental, vision and wellbeing benefits that enable you to take care of your health. We also offer a competitive 401(k) contribution, a pension plan, an annual incentive, 9 paid holidays and a paid time off program (23 days accrued annually for full-time employees). In addition, our student loan repayment program and paid-family leave are available to support our employees and their families. Interns and contingent workers are not eligible for American Family Insurance Group benefits.

We are an equal opportunity employer. It is our policy to comply with all applicable federal, state and local laws pertaining to non-discrimination, non-harassment and equal opportunity. We also consider qualified applicants with criminal histories, consistent with applicable federal, state and local law.