Excel Macro Process Automation Specialist

at Lincoln Financial Group in Springfield, Illinois, United States

Job Description

Alternate Locations: Work from Home; Fort Wayne, IN (Indiana)

Work Arrangement:

Hybrid/Flexible : Work at home and use the office as appropriate for in-person collaboration.

Relocation assistance: is not available for this opportunity.

Requisition #: 73379

The Role at a Glance

We are excited to bring on a self-driven excel macro developer to our Workplace Solutions Production Support team in the role of Excel Macro Process Automation Specialist . Lincoln’s Retirement Plans Services (RPS) organizations rely on automation to deliver efficiencies for many of their processes, with over 150 excel macros in use by the various teams across RPS, with another 100 expected to be created and implemented in 2024. In this role, you will support RPS by building and maintaining the various macros used by these teams. This role can work remote or out of one of our key city locations.

What you’ll be doing

+ Creating new excel macros using Visual Basic for Applications (VBA)

+ Completing the necessary development for enhancements or to fix a defect on an existing macro

+ Collaborating with business teams to finalize requirements and determine appropriate test scenarios

+ Consulting with various business users to determine whether a macro can deliver efficiency gains or improve quality output

+ Continuing efforts to build out classes that increase efficiency and turnaround times of the macro development process

What we’re looking for

Must-haves:

+ 1-3+ years of experience with Visual Basic for Applications

+ 4 year degree or equivalent work experience

+ Ability to translate business requirements into a macro design solution and then subsequent code development

+ Expert level of experience with Microsoft Excel and a solid understanding of other Microsoft office applications, including Word and Access

+ An organized, self-driven, critical thinker who can work both independently and within a team

Nice-to-haves:

+ Knowledge of Selenium, IBM Communicator and other tools that enable VBA to interface with various systems and applications

+ Microsoft Access Database development experience

+ Microsoft Access SQL knowledge and experience

Application Deadline

Applications for this position will be accepted through August 19th, 2024, subject to earlier closure due to applicant volume

\#LI-Remote

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:

+ Clearly defined career tracks and job levels, along with associated behaviors for each Lincoln leadership Attribute.

+ Leadership development and virtual training opportunities

+ PTO/parental leave

+ Competitive 401K and employee benefits (https://hrdirectdocs.lfg.com/misc/HR/Recruiting/BenefitsResourcesGuide.pdf)

+ 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

The pay range for this position is $53,500 – $92,500 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 Group helps people to plan, protect and retire with confidence. As of Dec. 31, 2023, approximately 17 million customers trust our guidance and solutions across four core businesses – annuities, life insurance, group protection and retirement plan services. As of December 31, 2023, the company had $295 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 (https://www.lfg.com/public/aboutus/companyoverview/diversityinclusion?audience\page\id=1422918942386) 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 (http://www.facebook.com/lincolnfinancialgroup) , X (https://mobile.twitter.com/lincolnfingroup) , LinkedIn (https://www.linkedin.com/company/4307?trkInfo=tas%3Alincoln+financial%2Cidx%3A3-1-3&trk=tyah) , and Instagram (https://www.instagram.com/lincolnfingroup/) . For the latest company news, visit our newsroom (https://www.lincolnfinancial.com/public/aboutus/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 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 or 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 orientat