Job Description
Job DetailsJob Location: INSURICA Direct - Norman, OK 73072Position Type: Full TimeEducation Level: 4 Year DegreeSalary Range: $48,869.00 - $76,557.00 HourlyTravel Percentage: NoneJob Shift: DaySUMMARY:
The Direct Data Associate is responsible for working directly with the Campaign Coordinator to support daily adjustments to lead appetite, using acquisition cost metrics and production performance data. The Direct Data Associate will also work with the Campaign Coordinator to improve agency operations through data analysis and by developing dashboards and other reporting or display tools that help Direct Administration make data-informed decisions.
ESSENTIAL FUNCTIONS:
Monitor direct carrier and INSURiConnect to Direct data, reporting trends, issues, etc.
Look for lead trends in close ratios, declines, volume, NAICS, best performing codes, least successful codes, etc. to support lead buying decisions
Build requested/required reports and dashboards in Salesforce and Power BI, and monitor daily
Keep management informed on call quality and customer facing KPI’s, and create dashboards and reporting to enable real-time monitoring
Work with the book of business data to create dashboards and reporting to enable focus on the most profitable segments of the business
Report to the Campaign Coordinator on a regular basis regarding updates, issues, etc., specific to lead providers and lead sources
Provide consistent disposition reporting and updates for lead providers
Support other data needs for Direct leadership for Direct P&C and EB, as needed
Assist Direct Administration with data analytics for colleague scorecards
Effectively monitor and update various duties and projects with Direct leadership within Monday.com
Assist in Direct tasks on a campaign basis, such as cleaning the prospect list, Excel reports, and data clean-up
Monitor campaign data, reporting trends, issues, etc.
Review all activities relating to the public, customers, and companies to avoid issues involving potential errors and omissions
Participate in seminars and other training to maintain required licenses and for knowledge and skill development
Additional Responsibilities
This job description is intended to describe the level of work required of the person performing the position. Essential functions are outlined; however, other duties may be assigned, as needs arise, or as required to support the essential functions. Specific performance objectives may be developed each year to measure the performance of the tasks and functions listed in this job description.
Remote work opportunities vary by location, department, and business need and are subject to change, as needed. Each manager will provide details on any telecommuting opportunities, as well as scheduling, within their department.
QualificationsKNOWLEDGE, SKILLS, AND ABILITIES:
Excellent PC skills, with a focus on the Microsoft suite (Word, Excel, Outlook, Teams, etc.) and the ability to work with agency management systems and instructional software
Excellent Salesforce and Power BI skills, with the ability to export reports and create pivot tables as needed
Strong customer relationship management system background
Ability to work effectively with data tools to create effective and useful data displays
Ability to work within a fast-paced, changing priority environment
Self-motivated, with the initiative to prioritize and be self-directed
Regular and punctual attendance is required
Ability to communicate effectively, both verbally and in writing
Excellent interpersonal skills, with the ability to interact effectively with both colleagues and managers, across all levels
Ability to promote and maintain a team environment, willing to find accommodating solutions for our customers, companies and the Agency
Ability to successfully adhere to company policies and procedures, as well as maintain strict confidentiality
QUALIFICATIONS:
1 – 3 years of previous marketing/data review experience preferred
Bachelor's degree in education, business, information technology, or other related field, preferred
WORKING CONDITIONS AND REASONABLE ACCOMMODATIONS:
Fast-paced, multi-tasking, office environment with periodic high disruption and changing priorities
Ability to perform approximately 80% sedentary work, exerting up to 10 pounds of force occasionally, and negligible force frequently
Ability to lift up to 20 pounds occasionally
Requires operation of a computer workstation, including keyboard and video display
All requirements may be modified to reasonably accommodate physical or mental impairment