Defined Benefits Technical Consultant - Durham, NC, United States - Fidelity Investments

Description

The Defined Benefits Technical Consultant will support the business by working on highly complex Defined Benefit data consulting projects leveraging their analytical strengths and skills.

We are looking for someone to join our great team of experts, who enjoy a fast-paced environment, and can provide quality work and a best-in-class client/customer experience.

The Technical Consultant leverages various service category databases, data warehouses, and other technical applications (i.e. SQL, Snap Logic, Access, Snowflake, Excel) to identify, analyze and propose solutions to clean the data required to provide accurate administration of Defined Benefits. The technical consultant helps our clients, and their employees realize their hard-earned retirement dreams.

The Fidelity Workplace Consulting Group is composed of over 300 professionals who advise clients on the management of their domestic benefits.

We are a fast-growing business within Fidelity, providing a broad range of services that touch on every area of benefits design, strategy, funding, communication, and delivery.

Data Consulting engages in data quality improvement efforts that span single and multiple product lines (i.e. Health and Welfare, Defined Benefit, Defined Contribution, Stock Plan Services and HR/Payroll) within the implementation and ongoing servicing client lifecycle.

Required: 4+ Years of demonstrated Defined Benefit and/or Pension Administration experience required
Required: 4+ years writing SQL
Experience using Excel formulas for data analysis and data comparisons
Ability to translate technical client specifications into data analysis deliverables
Strong data analysis skills
Experience querying large data sets with optimized SQL code
Knowledge of Fidelity's backend product tables (DBR1, WIDE, Snowflake, etc.) Bachelor's degree or equivalent years of experience

High Quality data analysis with an attention to detail and clear communications
On time delivery of time sensitive project work
Recommendations of ways to streamline and/or enhance data analysis processes
Unit tested deliverables

We offer a wide range of benefits to meet your evolving needs and help you live your best life at work and at home.

These benefits include comprehensive health care coverage and emotional well-being support, market-leading retirement, generous paid time off and parental leave, charitable giving employee match program, and educational assistance including student loan repayment, tuition reimbursement, and learning resources to develop your career.

Note, the application window closes when the position is filled or unposted.

Fidelity Investments is a privately held company with a mission to strengthen the financial well-being of our clients. We help people invest and plan for their future. We assist companies and non-profit organizations in delivering benefits to their employees. And we provide institutions and independent advisors with investment and technology solutions to help invest their own clients' money.

You can take advantage of flexible benefits that support you through every stage of your career, empowering you to thrive at work and at home.

Candidates who are presented with a Fidelity offer will need to go through a background investigation, detailed in this document , and may be asked to provide additional documentation as requested.

This investigation includes but is not limited to a criminal, civil litigations and regulatory review, employment, education, and credit review (role dependent).

These investigations will account for 7 years or more of history, depending on the role. Amphetamines, THC (marijuana), cocaine, opiates, phencyclidine.

We believe that the most effective way to attract, develop and retain a diverse workforce is to build an enduring culture of inclusion and belonging.

Fidelity will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process. To initiate a request for an accommodation, contact the HR Accommodation Team by sending an email to .