Excel/VBA Annuity Modeling Specialist
$66.75k - $106.8kLincoln Financial
Alternate Locations: Hartford, CT (Connecticut); Charlotte, NC (North Carolina); Fort Wayne, IN (Indiana); Greensboro, NC (North Carolina); Omaha, NE (Nebraska); Radnor, PA (Pennsylvania)
Work Arrangement:
Hybrid : Employee will work 3 days a week in a Lincoln office
Relocation assistance: is not available for this opportunity.
Requisition #: 76824
The Role at a Glance We are excited to bring on an Excel/VBA Annuity Modeling Specialist to join our Retail Solutions organization in a hybrid work environment. We are open to candidates in the following key city locations: Charlotte (NC), Fort Wayne (IN), Greensboro (NC), Hartford (CT), Omaha (NE) and Radnor (PA).
Background Details
As the Excel/VBA Annuity Modeling Specialist, you will contribute to the development of benchmark test tools for our annuity illustration, administration, and other product platforms. Working under general supervision and following established guidelines, you will apply working knowledge of Excel and VBA to build and maintain spreadsheet models that verify the accuracy of our systems. This position supports analysis for stakeholders across the Annuities group while delivering on routine assignments within its assigned area. The incumbent also serves as a resource for annuity product technical questions and supports other ad hoc annuity analytical initiatives as needed.
What you'll be doing You will support the development and implementation of Excel-based testing models for Variable, Fixed, Indexed, Immediate and Deferred Income Annuities to ensure the accuracy of our illustration system(s), digital platform(s), administration system(s), and any other supporting system(s), including but not limited to: adding new products to existing spreadsheet models, creating new spreadsheets for new products, and updating existing spreadsheets for product changes.
You will work collaboratively with fellow team members to meet shared goals and deadlines.
You will leverage AI tools to enhance and accelerate spreadsheet modeling, testing, and analysis workflows.
You will assist in debugging systems and help determine the sources of differences from the benchmark tool.
You will respond to straightforward queries from distribution regarding product illustrations and projections.
You will work with Operations and the Product Implementation team to support production-related calculation issues.
You will maintain working knowledge of current developments and trends for assigned area(s) of responsibility.
You will support and positively contribute to departmental and enterprise change management initiatives within assigned area(s) of responsibility.
You will perform and deliver on routine assignments/projects while applying working knowledge of assigned area(s) of responsibility.
You will serve as a resource for ad hoc annuity product analysis assignments as needed.
What we’re looking for 4 Year/Bachelor’s Degree, preferably in mathematics, computer science, or a similar technical field.
1–3+ Years of experience in Excel modeling that directly aligns with the specific responsibilities for this position.
Working knowledge of spreadsheets and programming experience with VBA.
Experience using AI platforms (i.e., CoPilot, Claude).
Demonstrated analytical and problem-solving skills; detail-oriented, motivated, and eager to learn.
Strong written and verbal communication skills.
Ability to read, analyze, and interpret both internal and external documents.
Ability to apply mathematical concepts such as probability, statistics, percentages, ratios, and proportions to practical solutions.
Ability to solve challenging but noncomplex problems and deal with a variety of concrete variables where guidelines exist.
Ability to collect data, establish facts, and draw valid conclusions.
Ability to evaluate trends in data or information.
Understanding of annuity products and markets preferred, or a willingness to develop it.
Ability to work with others in a collaborative team environment under general supervision.
Demonstrated relationship management skills with internal clients (e.g., management, peers, and colleagues).
Demonstrates strong organizational skills with the ability to prioritize workload and multi-task while maintaining attention to detail.
Application Deadline Applications for this position will be accepted through November 30, 2026, subject to earlier closure due to applicant volume.
What’s it like to work here?
At Lincoln Financial, 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:
Clearly defined career tracks and job levels, along with associated behaviors for each of Lincoln's core values and leadership attributes 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 Work arrangements that work for you Effective productivity/technology tools and training The pay range for this position is $66,750 - $106,800 with anticipated pay for new hires between the minimum and midpoint of the range and could vary above and below the listed range as permitted by applicable law. Pay is 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 (NYSE: LNC) helps people to confidently plan for their version of a successful future. We focus on identifying a clear path to financial security, with products including annuities, life insurance, group protection, and retirement plan services.
With our 120-year track record of expertise and integrity, millions of customers trust our solutions and service to help put their goals in reach.
Lincoln Financial Distributors, a broker-dealer, is the wholesale distribution organization of Lincoln Financial. Lincoln Financial is the marketing name for Lincoln Financial Corporation and its affiliates including The Lincoln National Life Insurance Company, Fort Wayne, IN, and Lincoln Life & Annuity Company of New York, Syracuse, NY. Lincoln Financial affiliates, their distributors, and their respective employees, representatives and/or insurance agents do not provide tax, accounting or legal advice.
Lincoln is committed to creating an 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, X, LinkedIn, Instagram, and YouTube. For the latest company news, visit our newsroom.
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 View email address on click.appcast.io 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 or candidate profiles submitted through our web site or to personal e-mail accounts of employees of Lincoln Financial are considered property of Lincoln Financial and are not subject to payment of agency fees.
Lincoln Financial ("Lincoln" or "the Company") 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, age, national origin or disability. Opportunities throughout Lincoln are available to employees and 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 View phone number on click.appcast.io.
This Employer Participates in E-Verify. See the E-Verify notices.
Este Empleador Participa en E-Verify. Ver el E-Verify avisos.
Vacancy posted 6 hours ago
Similar jobs that could be interesting for youBased on the Excel/VBA Annuity Modeling Specialist in Hartford, CT vacancy
$108k - $162k
Sr Analyst Model Risk Management - KM07AEWe’re determined to make a difference and are proud to be an insurance company that goes well... ...different programming languages/technology platforms including Excel/VBA,R, Python, SAS/SQL, C++, JavaPractical experience with...ExcelVBAFull timeTemporary workShift work$150k - $220k
...Director - Actuarial Life and Annuities Consulting ~202606128... ...engagements including financial modeling, financial reporting, mergers... ...product which conforms with WTW Excellence standards Share expertise... ...(e.g. Microsoft Excel with VBA, SQL, Python, or R) and/or financial...ExcelVBAFull timeTemporary workLocal areaRemote workFlexible hours$100k - $150k
...Manager - Actuarial Life and Annuity Consulting ~202606127 ~... ...engagements including financial modeling, financial reporting, mergers... ...which conforms with WTW Excellence standards Support client correspondence... ...(e.g. Microsoft Excel with VBA, SQL, Python, or R) and/or...ExcelVBAFull timeTemporary workWork at officeLocal areaRemote workVisa sponsorshipWork visaFlexible hours$100k - $120k
...transparent, and multi-channel, spanning retail annuities, block and flow reinsurance, and legal... ...assumptions, scenario severity, and model performance to ensure continued... ...CFA designation is a plus Proficiency in Excel, VBA, and SQL are required Experience with Python...ExcelVBAFull timeWork at office$1,350 - $1,600 per month
...and M&A. Through its rotational model, ICG works across management... ...strategic business challenges Excellent written and verbal... ...with R, Python, SQL, SAS, or VBA *If interested in the ICG,... ...Life Overview : Focuses on life, annuity, and long-term care work, including...ExcelVBAWeekly payPermanent employmentFull timeSummer workInternshipSummer internshipWork at officeLocal areaRemote workFlexible hours3 days per week1 day per week$112.4k - $168.6k
...reporting, portfolio aggregation and catastrophe pricing and modeling. The Senior Catastrophe Risk Analyst will support reporting of... ...related to catastrophe risk management and modeling.Experience in Excel/VBA, SQL, R and CoPilot (or other AI)Experience of working with...ExcelVBAFull timeTemporary workWork experience placementVisa sponsorship$74.9k - $147.6k
...actuarial processes, data, technology, and operating models to improve efficiency and business... ...using one or more of the following: Microsoft Excel, Microsoft Word, Microsoft Access, or Visual Basic for Applications (VBA)1+ years of experience applying Statutory Accounting...ExcelVBAWork at officeLocal areaVisa sponsorshipNight shift$113.2k - $169.8k
...ahead of our competitors.Opportunities:Develop internal modeled rate level indications to inform product rate strategy... ...ability to effectively resolve complex issues.Strong Excel skills required. Knowledge of SQL, VBA, R, Python, SAS or similar code languages a plus....ExcelVBAFull timeTemporary workWork at office3 days per week$100.4k - $197.9k
...actuarial processes, data, technology, and operating models to improve efficiency and business... ...using one or more of the following: Microsoft Excel, Microsoft Word, Microsoft Access, or Visual Basic for Applications (VBA)1+ years of experience applying Statutory Accounting...ExcelVBALocal areaVisa sponsorship$121.36k - $182.04k
...analytical tools and market data platforms such as Excel, Bloomberg, Intex, Trepp, BlackRock Aladdin, Tableau, R, VBA, or similar tools.Experience using AI-enabled... ...actionable conclusions.Strong analytical and financial modeling skills, including structured finance cash flow...ExcelVBAFull timeTemporary workWork at officeRemote work- ...income portfolios using multi-factor risk models to understand the primary drivers of risk,... ...Experience with Bloomberg Terminal and Bloomberg Excel API Data analysis and visualization... ...knowledge of Microsoft Excel including VBA, SQL and any programming languages. Educational...ExcelVBAWork experience placement
$150.89k - $167.66k
...Transmission Planning will conduct detailed technical modeling and analysis, perform as project leader,... ...PSSE, PSCAD, Microsoft Office 365; Word, Excel, Visio, SharePoint, OneDrive. Programming experience highly desirable: Python, VBA. Simulation software highly desirable:...ExcelVBAFull timeH1bWork at officeRemote work$150.3k - $167k
...have extensive experience with modeling and planning the bulk electric... ...Functions:Serve as a technical specialist to transmission planning in the... ..., OneLiner, PSCAD, TARA, Word, Excel, PowerPoint. Programming experience in Python and VBA is highly desirable. Additional...ExcelVBAFull timeH1bWork at officeLocal areaRemote work$80k - $100k
...worldclass technical expertise and engineering excellence to power utility and industrial clients... ...and skilled Project Controls Specialist to join our team at K&A Power Group in... ...including advanced data analysis, financial modeling, and reporting capabilities....ExcelContract workTemporary workFor contractorsFlexible hours$89.25k - $105k
...Job Title Project Controls Specialist Job Description Summary The Project Controls... .... Develop and enforce governance models. Support training and upskilling initiatives... ...Support sustainability and operational excellence initiatives through data-led...ExcelMinimum wageLocal areaRemote workFlexible hours$68.5k - $97.7k
...developing or enhancing internal tools, dashboards, or workflows (e.g., Excel models, Power BI, simple scripts, or low-code solutions) to streamline... ...~ Basic coding or scripting experience (e.g., Python, VBA, SQL, or low-code platforms) is a plus, with interest in applying...ExcelVBAFull timeContract workTemporary workFor contractorsWork experience placementWork at officeLocal areaImmediate startFlexible hours$102.5k - $182k
...intelligence, or reporting using tools such as Microsoft Power BI, Structured Query Language (SQL), Python, Microsoft Excel, or Visual Basic for Applications (VBA)Must be able to obtain and maintain the required Public TrustAbility to travel 10%, on average, based on the...ExcelVBAWork at officeLocal area2 days per week$92k - $169.8k
...analytical, critical thinking and problem-solving skills, with the ability to effectively resolve complex issues.Strong Excel skills required. Knowledge of SQL, VBA, R, Python, SAS or similar code languages a plus.Excellent written and verbal communication skills.Attention to...ExcelVBAFull timeTemporary workWork at officeRemote work3 days per week$150k - $200k
...Description POSITION SUMMARY The Underwriting Specialist, Primary Casualty ("UWS") reviews and... ...underwriting strategies such as pricing models and solutions including product... ...risk decisions. Strong computer skills (Excel, Word and SharePoint), with demonstrated...ExcelTemporary workWork at officeFlexible hours3 days per week- ...Advisory practice is at the forefront of transformation, offering excellent opportunities for individuals to advance their careers and... ...Cloud and advanced Excel skills such as Pivot, VLookup, writing VBA macros, Microsoft Project with sound knowledge in data conversion...ExcelVBAH1bLocal area
- ...requirements. Build and optimize data models using Power BI Desktop including Power Query... ...limited to SQL Server, Oracle DB, JSON, Excel, etc. Design and develop Microsoft Power... ...support. Help migration from existing Excel VBA to .net Help migration from legacy MS...ExcelVBATemporary work
$83.6k - $125.4k
...theirs, too. Join our team as we help shape the future. Senior Specialist, Marketing - Commercial Specialty Insurance Overview: Join a high... ..., etc.) preferred.Experience with Copilot and AI agents, Excel, PowerPoint and MS Teams preferred.Strong collaboration skills...ExcelFull timeTemporary work$26 per hour
...Relocation: CVS Health follows a hybrid work model providing office-based colleagues the... ...with Microsoft Office products including Excel, Outlook, PowerPoint, and Word Preferred... ...Experience with coding software such as VBA, R, or Python Prior internship/work experience...ExcelVBAHourly payFull timeWork experience placementSummer workInternshipSummer internshipWork at officeLocal areaRemote workWork from homeRelocationRelocation packageFlexible hours2 days per week$50k - $60k
...with a stable nonprofit organization in order to identify an AP Specialist for their team. Why Work Here? Family... ...Accounting or equivalent experience The AP Specialist must have basic Excel skills Salary is $50,000-60,000 EB-1476234491ExcelWork at officeRemote workFlexible hours$45 - $52 per hour
...Strong planning, problem solving, organizational, and project management skills * Expert in Excel use required with basic scripting experience in any programming language (VBA, Matlab, etc.) a plus * Hands on experience in a laboratory environment * Highly self-...ExcelVBAContract work- ...today. Job Overview We are seeking a Production Control Specialist to join our team. As a Production Control Specialist, you will... ...organizational and time management skills ~ Proficiency with Microsoft Excel and ERP/MRP systems ~ Excellent verbal and written...ExcelWork at office
$88.8k - $184.46k
...ResponsibilitiesPerform data analysis using Excel, SAS, and proprietary Milliman programs to... ..., reserving, financial projections, model development, forecasting, and mergers and... ...Success in this RoleExperience working with SAS,VBA, or other coding languagesis advantageous...ExcelVBAFull timeTemporary workWork experience placementWork at officeRemote workWorldwideFlexible hours$22.34 - $27 per hour
...preferred. Skills Ability to calculate and apply mathematical concepts required. Proficiency in MS Office Suite, advanced skills in Excel required. High degree of concentration and accuracy with adherence to strict confidentiality. Effective customer service and...ExcelHourly payFull timeShift work$71k - $84k
...Loureiro Engineering Associates, Inc. is seeking an experienced EHS Specialist to support a diverse portfolio of environmental, health, and... ...or industry standards. Proficiency with Microsoft Excel and the ability to complete technical calculations and prepare...ExcelRemote work$103.5k - $214.82k
...CMS LEAD (Long Term Enhanced ACO Design) model and other CMMI innovation programsManage and... ...junior staffPerform data analysis using Excel, SAS, Python, SQL, and proprietary Milliman... ...technologiesExperience working with Python, SQL, SAS, VBA, or other coding/data analytics...ExcelVBAFull timeTemporary workWork experience placementWork at officeRemote workFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Excel/VBA Annuity Modeling Specialist. Be the first to apply!
Related searches
- sewing specialist Hartford, CT
- technology integration specialist Hartford, CT
- evaluation specialist Hartford, CT
- educational technology specialist Hartford, CT
- policy specialist Hartford, CT
- performance improvement specialist Hartford, CT
- assessment specialist Hartford, CT
- criminal justice specialist Hartford, CT
- performance specialist Hartford, CT
- payment posting specialist Hartford, CT





