Senior Data Integration Specialist

Job Classification:

Group Insurance is seeking an experienced and motivated professional to join the Customer Data Management Team as a Technical Systems Analyst. This will be a customer-facing role, yet requires technical and business expertise. The ability to perform a consultative role to partner with Operation to define solutions for Group Insurance customers and their Third-Party Administrators will be a critical component of this position.
What you'll do:
This position supports the installation Group Insurance customers The Analyst works closely with our customers and/or their Third-Party Administrators, and internal business partners including Implementation, Distribution and Operations to define and implement effective solutions.
Specific duties include:

Defining data requirements specific to the customers’ plan design, reviewing data requirements with the customer, offering alternatives for data concerns. Once the test files are received, the analyst conducts a thorough review and analysis to identify and communicate any issues and offer alternative solutions to support the administration needs of our customers.
Once the customer production file is received, the analyst will coordinate activities to complete the data load into the appropriate administration system. In addition, the Analyst solves complex problems and takes a broad perspective to identify solutions. Works independently, with guidance in only complex situations.
This position will also contribute on internal team projects and cross- functional initiatives. They will act as a subject matter expert for cross-functional inquiries.
What you'll need:

• Cross-functional business expertise, with knowledge of Group Insurance products and services
• Excellent communication skills, including direct interaction with customers. Ability to tailor the message based on the customer needs.
• Strong analytical and problem-solving skills preferably working on data management / data integration projects
• Excellent interpersonal skills and the ability to build and cultivate partnerships with Group Insurance customers, TPA's and internal business partners
• Demonstrated project management skills, with the ability to work on multiple projects at varying stages
• Track record of delivering results, with ability to meet deadlines in a fast-paced environment
• Ability to work independently, prioritize deliverables, and drive to solutions
• Technical background with SQL, Excel / Excel Macros and text file manipulation
• Experience with CSV / fixed width file formats a must. Experience with XML highly desired.
• Ability to quickly ramp up and become proficient on new processes with minimal guidance
• Prior experience with administration of group insurance benefits or eligibility processing is preferred
• Bachelor’s degree or higher in business, a related field or equivalent work experience required

• Market competitive base salaries, with a yearly bonus potential at every level. 

• Medical, dental, vision, life insurance, disability insurance, Paid Time Off (PTO), and leave of absences, such as parental and military leave. 

• 401(k) plan with company match (up to 4%). 

• Company-funded pension plan. 

• Wellness Programs including up to $1,600 a year for reimbursement of items purchased to support personal wellbeing needs. 

• Work/Life Resources to help support topics such as parenting, housing, senior care, finances, pets, legal matters, education, emotional and mental health, and career development.  

• Education Benefit to help finance traditional college enrollment toward obtaining an approved degree and many accredited certificate programs.  

• Employee Stock Purchase Plan: Shares can be purchased at 85% of the lower of two prices (Beginning or End of the purchase period), after one year of service. 

Eligibility to participate in a discretionary annual incentive program is subject to the rules governing the program, whereby an award, if any, depends on various factors including, without limitation, individual and organizational performance. To find out more about our Total Rewards package, visit Work Life Balance | Prudential Careers. Some of the above benefits may not apply to part-time employees scheduled to work less than 20 hours per week.