This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
This position directly supports the Strategic Partnership's organization mission to strengthen relationships with our producer partners and support the achievement of Aetna’s growth and retention objectives. Individuals in this role will develop and analyze recurring reporting and tools to assess and communicate the performance of our incentive programs in order to support decision-making processes and provide insights that helps our senior leaders and sales/AM teams achieve our growth goals. The key deliverables in this role include monthly reporting in support of our producer incentive programs, administration of Aetna’s contracts with General Agents, managing our resource center in SharePoint as well as other ad-hoc projects such as the credentialing of our reporting suite. The associate in this position will be able to develop their technical skillset using Microsoft Access, Excel, SharePoint and Tableau. They will be able to work independently and provide recommendations on potential enhancements to our reporting suite.
Job Responsibility:
Responsible for timely, accurate and insightful reporting and tools in collaboration with colleagues both inside and outside of own work area
Manages all aspects of General Agent contracting, inclusive of rate analyses, term changes, vesting procedures
Tracks progress and communicates project status on a regular basis to all impacted parties
Manages development and distribution of training, presentation and other materials for incentive reporting rollouts
Identifies gaps and recommends process improvements to new/existing reports, tools, processes, projects or workflows
Proactively leads assigned projects by creating project timeline, identifying key milestones and identifying additional resources needed to successfully complete the work
Requirements:
1-3 years experience in data/business analytics, strategic business planning, managing large data sets and/or reporting and analyses
1-3 years of experience in Excel (x lookups)
Bachelor's Degree or equivalent experience (REQUIRED)
Nice to have:
1-3 years of experience in Access (link tables and write queries)
Excellent written and verbal communication skills
Ability to communicate effectively with colleagues, stakeholders and leadership
Ability to work collaboratively within work teams
Ability to handle multiple tasks in a fast-paced environment
Strong prioritization and organization skills
Attention to detail
What we offer:
Affordable medical plan options, a 401(k) plan (including matching company contributions), and an employee stock purchase plan
No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching
Benefit solutions that address the different needs and preferences of our colleagues including paid time off, flexible work schedules, family leave, dependent care resources, colleague assistance programs, tuition assistance, retiree medical access and many other benefits depending on eligibility