Defined Benefits Technical Consultant
Job Description
The Role
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 incumbent must have deep Defined Benefits Domain Knowledge accompanied bystrong analytical technical skillset.
This a great role for someone who is looking for variety in their day-to-day activities as no two days are the same. This role owns the outcome and provides mentoring and support to the analyst team.
The ideal candidate enjoys a challenge with rewarding work having direct client impact. The technical consultant helps our clients, and their employees realize their hard-earned retirement dreams.
The Team
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.
While we focus on working with the Fortune 1000, we also work with Fidelity clients of all sizes.
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.
The Expertise and Skills You Bring
- 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.) a plus
- Ability to prioritize fast paced work
- Experience in a consulting role a plus
- ETL Experience
- Bachelor's degree or equivalent years of experience
The Value You Deliver
- High Quality data analysis with an attention to detail and clear communications
- Ownership of your delivery with minimal direction
- On time delivery of time sensitive project work
- Collaboration with teammates to ensure handoffs are made effectively
- Recommendations of ways to streamline and / or enhance data analysis processes
- Unit tested deliverables
- Interest and curiosity in your work that translates to thoughtful questions and engaging discussions leading to positive client experiences
The base salary range for this position is $85,000-$179,000 per year.
Placement in the range will vary based on job responsibilities and scope, geographic location, candidate’s relevant experience, and other factors.
Base salary is only part of the total compensation package. Depending on the position and eligibility requirements, the offer package may also include bonus or other variable compensation.
We offer a wide range of 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.
Certifications :