Sales Technical Business Analyst I/II/III - 001451

Summary

This position is responsible for ongoing operation and maintenance of the Health Plan's systems utilized for the Broker and Sales Rep assignments and compensation process including administration and payment for the Health Plan's Broker and Sales Incentive Programs. Responsibilities include execution of monthly processing jobs, audit testing and quality assurance. The incumbent performs continuous assessment of end-to-end system operating performance from an end-to-end business operation. The position actively manages resolution of defects and installation of new releases designed to achieve optimal system performance. The position serves as the lead technical representative for interactions in relation to these applications. The analyst is also responsible for the reporting and analyzing of data used to make strategic decisions regarding the compensation program.

Essential Responsibilities/Accountabilities

All Levels

• Conducts the commission plan administration activities, including plans setup, management of monthly and quarterly commission payment cycles, and ensuring timely distribution of reports and processing of commission payments.
• Partners with IT, commissions vendor and sales to drive improvements in commission processing.
• Researches, queries and understands data flows to explain variances in commission pay and/or target attainment and communicate this to our customers.
• Researches problems and structure solutions.
• Works cross-functionally with sales, Marketing and finance teams, to deliver value.
• Assists with the enhancement of policies, procedures and business practices that improve efficiency within the Commissions function and the business.
• Assists in the appointment process for new brokers of the Health Plan as well as the relationship with our general agency.
• Researches and processes Broker of Record (BOR) and Sales Representative changes in the applicable systems.
• Triages the broker web access submissions and is the liaison between our broker partners, data security and web help desk.
• Maintains current system and process documentation and catalogs all documentation to assure compliance with internal policy and all required regulations.
• Updates and maintenance of broker collateral.
• Consistently demonstrates high standards of integrity by supporting the Lifetime Healthcare Companies' mission and values and adhering to the Corporate Code of Conduct and leading to the Lifetime Way values and beliefs.
• Maintains high regard for member privacy in accordance with the corporate privacy policies and procedures.
• Regular and reliable attendance is expected and required.
• Performs other functions as assigned by management.
  Level II - in addition to Level I:
• Understands the strategies that drive our commission plans and suggest improvements as needed to ensure the plans continue to meet business needs.
• Actively participates in system testing and identifies severity and impact of bugs. Develops service requests and contributes to prioritization in support of ongoing system development with goal to continuously enhance user and customer experience.
• Creates system updates and test cases for preparation of new or updated commission payment schedules.
• Monitors data exchanges across multiple internal and external systems to ensure they are operating as expected.
• Runs and creates reports to be shared with sales leaders and external partners.
• Serves as a subject matter expert and represents the team on cross functional initiatives.
• Prepares audit reports to monitor process controls and support compliance with Sarbanes Oxley.
  Level III - in addition to Level II:
• Leads implementation of complex management reports, commission schedule updates and large divisional system or data management by developing work plans and monitoring against milestones.
• Develops tools and reports to proactively identify market-based opportunities or threats for the commission program and creates solutions.
• Creates forecasts and model's for finance to use in Administrative budgeting and forecasting.

Minimum Qualifications

NOTE: We include multiple levels of classification differentiated by demonstrated knowledge, skills, and the ability to manage increasingly independent and/or complex assignments, broader responsibility, additional decision making, and in some cases, becoming a resource to others. In addition to using this differentiated approach to place new hires, it also provides guideposts for employee development and promotional opportunities.

Level I

• Associates degree in business administration or related field with minimum of five years of experience in data or information analysis and reporting. Bachelor's degree in business or similar discipline preferred.
• Excellent organizational skills and attention to detail and quality.
• Excellent oral and written communication skills.
• Capable of establishing effective relationships with internal and external customers.
• Adaptable to dynamic work environment and rapidly changing priorities.
• Sound judgment and decision making.
• Demonstrated proficiency with Microsoft Excel.
• Proven aptitude to readily learn new skills, applications and tools.

Level II - requires similar minimum qualifications as level I, plus:

• Minimum of seven years of experience in data or information analysis and reporting.
• Creative thinker willing to take initiative and formulate recommendations to impact enterprise strategy and/or tactics.
• Advanced data management and query skills such as SQL, SAS or Cognos Report Studio.
• Ability to find solutions, test and implement.
• Ability to analyze and create reports for different levels of Management in the Health Plan.

Level III - requires similar minimum qualifications as level II, plus:

• Minimum of nine years of experience in data or information analysis and reporting.
• Project Management experience preferred.
• Strong analytical and problem-solving skills.
• Strong ability to take a concept from research to implementation considering operational and financial impact.

Physical Requirements

• Ability to travel independently to various company and business associate offices.
• Use of a computer for extended periods of time.
• Use of an office telephone a must.

Salary Range

The salary range indicated in this posting represents the minimum and maximum of the salary range for this position. Actual salary will vary depending on factors including, but not limited to, budget available, prior experience, knowledge, skill and education as they relate to the position's minimum qualifications, in additional to internal equity. The posted salary range reflects just one component of Excellus's total rewards package. Other components of the total rewards package may include participation in group health and/or dental insurance, retirement plan, wellness program, paid time away from work, and paid holidays.

Level I: Min: $55,400.00 - Max: $78,900.00

Level II: Min: $55,400.00 - Max: $90,100.00

Level III: Min: $55,500.00 - Max: $103,000.00

The Lifetime Healthcare Companies aims to attract the best talent from diverse socioeconomic, cultural and experiential backgrounds, to diversify our workforce and best reflect the communities we serve.

Our mission is to foster an environment where diversity and inclusion are explicitly recognized as fundamental parts of our organizational culture. We believe that diversity of thought and background drives innovation which enables us to provide leading-edge healthcare insurance and services. With that mission in mind, we recruit the best candidates from all communities, to diversify and strengthen our workforce.

OUR COMPANY CULTURE:

Employees are united by our Lifetime Way Values & Behaviors that include compassion, pride, excellence, innovation and having fun! We aim to be an employer of choice by valuing workforce diversity, innovative thinking, employee development, and by offering competitive compensation and benefits.

In support of the Americans with Disabilities Act, this job description lists only those responsibilities and qualifications deemed essential to the position.

Equal Opportunity Employer

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)