Address
Form of workAlternate Locations: Hartford, CT (Connecticut); Fort Wayne, IN (Indiana); Greensboro, NC (North Carolina)
Work Arrangement:
Hybrid/Common Days+ : Work 2-3 days a week in a Lincoln office with a designated workspace.
Relocation assistance: is not available for this opportunity.
Requisition #: 72692
As the Excel/VBA Development Specialist, you will perform and deliver on routine assignments & development of benchmark test tools for our Annuity illustration and administration systems. You will serve as a technical resource to furnish advice to internal stakeholders, providing support for policy performance, tax code calculations, and system(s) related issues. You will provide forward thinking analysis furnishing advice to various stakeholders, provide support for numerous functions of the Annuity business and support ad hoc Annuity analytical initiatives.
• Develop Excel-based testing models for Variable, Fixed, Indexed, Immediate and Deferred Income Annuities to ensure the accuracy of our illustration systems – adding new products to existing spreadsheet models, creating new spreadsheets for new products and updating existing spreadsheets for product changes.
• Prepare spreadsheets for the illustration system with each release to verify illustration accuracy.
• Respond to queries from Distribution regarding product illustrations and projections.
• Interacts with multiple internal business areas, such as compliance and legal departments, to communicate detailed policy calculations, determine process improvements and issue resolution for tools and databases.
• Researches, interprets, and explains processes, procedures, and/or calculations related to the performance of products.
• Provides training to work groups/team members and serve as a resource for ad hoc annuity product pricing and risk analysis assignments as needed.
• Utilizes knowledge of products and markets to offer advice and suggestions to various Business Units and leadership to support the overall customer experience within Lincoln.
• Reviews process to quality check policy information and calculations in various administrative systems; recommends improvements to process as needed.
• Collaborates with stakeholders in other departments to increase turnaround time and reduce hand off.
• Advises IT on proposed updates/changes to administrative systems to ensure systems accurately reflect calculations and how product performs per policy specifications.
• Reviews IRS code calculations prepared by internal/external stakeholders.
• 4 Year Bachelor's degree or 4+ years of equivalent work experience
• 1 - 3+ Years of experience in modeling or programing - Insurance experience preferred (Required)
• Strong Excel and VBA experience required.
• Strong written and verbal communication skills.
• Apply concepts such as probability, statistics, modeling, percentages, ratios, and proportions to practical solutions.
• Works with mathematical concepts such as averages and/or variances.
• Ability to evaluate information and the implications of a course of action or solution.
• Ability to interpret and apply understanding to carry out a variety of instructions furnished in written, oral, or diagram form.
• Define problems, collect data, establish facts and draw valid conclusions.
• Demonstrated solid relationship management skills with internal clients (e.g. management, peers and colleagues).
• Demonstrates solid project management skills including, critical ability to coordinate and balance multiple projects in a time-sensitive environment, under pressure, and meeting deadlines.
• Proficiency with Microsoft Office Suite (Word, Excel, PowerPoint, Outlook).
What’s it like to work here?
At Lincoln Financial Group, we love what we do. We make meaningful contributions each and every day to empower our customers to take charge of their lives. Working alongside dedicated and talented colleagues, we build fulfilling careers and stronger communities through a company that values our unique perspectives, insights and contributions and invests in programs that empower each of us to take charge of our own future.
What’s in it for YOU:
A clearly defined career framework to help you successfully manage your career
Leadership development and virtual training opportunities
PTO/parental leave
Competitive 401K and employee benefits
Free financial counseling, health coaching and employee assistance program
Tuition assistance program
A leadership team that prioritizes your health and well-being; offering a remote work environment and flexible work hybrid situations
Effective productivity/technology tools and training
Pay Range: $51,900 - $75,800
Actual base pay could vary based on non-discriminatory factors including but not limited to work experience, education, location, licensure requirements, proficiency and qualifications required for the role. The base pay is just one component of Lincoln’s total rewards package for employees. In addition, the role may be eligible for the Annual Incentive Program, which is discretionary and based on the performance of the company, business unit and individual. Other rewards may include long-term incentives, sales incentives and Lincoln’s standard benefits package.
About The Company
Lincoln Financial Group helps people to plan, protect and retire with confidence. As of Dec. 31, 2022, approximately 16 million customers trust our guidance and solutions across four core businesses – annuities, life insurance, group protection and retirement plan services. As of September 30, 2023, the company had $290 billion in end-of-period account balances, net of reinsurance. Headquartered in Radnor, Pa., Lincoln Financial Group is the marketing name for Lincoln National Corporation (NYSE: LNC) and its affiliates. Learn more at LincolnFinancial.com.
Lincoln is committed to creating a diverse and inclusive environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.
Follow us on Facebook, Twitter, LinkedIn, and Instagram. Sign up for email alerts at http://newsroom.lfg.com
Be Aware of Fraudulent Recruiting Activities
If you are interested in a career at Lincoln, we encourage you to review our current openings and apply on our website. Lincoln values the privacy and security of every applicant and urges all applicants to diligently protect their sensitive personal information from scams targeting job seekers. These scams can take many forms including fake employment applications, bogus interviews and falsified offer letters.
Lincoln will not ask applicants to provide their social security numbers, date of birth, bank account information or other sensitive information in job applications. Additionally, our recruiters do not communicate with applicants through free e-mail accounts (Gmail, Yahoo, Hotmail) or conduct interviews utilizing video chat rooms. We will never ask applicants to provide payment during the hiring process or extend an offer without conducting a phone, live video or in-person interview. Please contact Lincoln's fraud team at fraudhotline@lfg.com if you encounter a recruiter or see a job opportunity that seems suspicious.
Additional Information
This position may be subject to Lincoln’s Political Contribution Policy. An offer of employment may be contingent upon disclosing to Lincoln the details of certain political contributions. Lincoln may decline to extend an offer or terminate employment for this role if it determines political contributions made could have an adverse impact on Lincoln’s current or future business interests, misrepresentations were made, or for failure to fully disclose applicable political contributions and or fundraising activities.
Any unsolicited resumes/candidate profiles submitted through our web site or to personal e-mail accounts of employees of Lincoln Financial Group are considered property of Lincoln Financial Group and are not subject to payment of agency fees.
Lincoln Financial Group (“LFG”) is an Equal Opportunity employer and, as such, is committed in policy and practice to recruit, hire, compensate, train and promote, in all job classifications, without regard to race, color, religion, sex (including pregnancy), age, national origin, disability, sexual orientation, gender identity and expression, Veteran status, or genetic information. Applicants are evaluated on the basis of job qualifications. If you are a person with a disability that impedes your ability to express your interest for a position through our online application process, or require TTY/TDD assistance, contact us by calling 260-455-2558.
This Employer Participates in E-Verify. See the E-Verify notices.
Este Empleador Participa en E-Verify. Ver el E-Verify avisos.
