Data & Process Analyst

32bjfunds; New York (NY); On-site; USD 85,000 - 110,000; Full time

Job summary

32BJ Funds in New York is seeking a Data and Process Analyst in Retirement Services to deliver defined benefit and defined contribution process analysis and ensure alignment with the Funds' strategy. Under supervision of the Manager of Retirement Programs, this role handles pension payroll coordination, census data preparation with actuaries, and support for annual 1099 and IRS Form 8955 projects.

A Bachelor's degree and strong Excel/MS Dynamics/validation skills are required in a fast-paced

Qualifications

• Two years' experience in defined benefit or defined contribution administration preferred.
• Knowledge of pension calculations and data validation preferred.
• Prioritization and deadline-driven work ability required.
• Strong MS Office, especially Excel, proficiency expected.
• Experience with MS Dynamics and QlikView preferred.
• V3locity V10 experience helpful for system tasks.
• Analytical, problem solving and decision making skills essential.
• Excellent organizational and multitasking capabilities.
• Detail-oriented with thorough work approach.

Responsibilities

• Pension payroll processing coordination with IT and Finance.
• Review actuarial valuation data and census files for funded positions.
• Support audits of pension plans and 401(k) plans with CPAs.
• Assist Annual 1099 project with validation and distribution.
• Support IRS Form 8955 data extraction, validation and submission.
• Coordinate batch processes, including RMDs and notifications.
• Validate weekly census files for SRSP data processing.
• Participate in SRSP projects and data research.
• Assist V3 implementation testing and specs review.
• Contribute to special projects as assigned.

Skills

Defined benefit/defined contribution

Pension calculations

Prioritization

Analytical skills

Organization

Multitasking

MS Excel

MS Dynamics

QlikView

V3locity V10

Education

Bachelor's degree in Math/Accounting or related analytical field

Tools

Microsoft Dynamics

QlikView

V3locity V10

Job description

Job Code: 519 | Department Name: Retirement Services | Reports To: Manager of Retirement Programs | FLSA Status: Exempt | Union Code: N/A | Management: No

Job Summary

Under the supervision of the Manager, Retirement Services Operations, the Data and Process Analyst is responsible for the delivery of specific defined benefit and defined contribution processes ensuring consistency with Funds' strategy and goals. The Data and Process Analyst is responsible for analysis of Taft-Hartley benefit plan data and administration of union member benefits and will use their knowledge and understanding of benefit administration and information systems to support projects for the Retirement Services department.

Essential Duties and Responsibilities

• Pension payroll processing – coordinate batch processing calendars with IT and Finance departments, reconcile month-over-month headcount and financial activity and troubleshoot variances, validate tax withholding activity, document recurring procedures and keep disaster recovery plans up to date.
• Process and review actuarial valuation data files – work with management and consulting actuaries to generate annual census data files for use in determining the funded position of 32BJ’s pension plans.
• Provide support for audits of pension plans and SRSP (401(k) Plan) – work with external CPA auditors to validate payment activity for disbursements made from benefit plans.
• Provide support for the Annual 1099 project – support the accurate and timely preparation, validation, and distribution of annual 1099 tax forms.
• Annual IRS Form 8955 project – support the annual generation, review, and submission process for IRS Form 8955 by coordinating data extraction, validation, cleanup, and quality review across pension plans.
• Coordination of all batch processes, including RMDs, age 65 notifications and suspension batches.
• SRSP weekly data processing – validate weekly census files sent to TPA for recordkeeping.
• SRSP projects including IRS non-discrimination testing file preparation, and RMD review.
• Special pension participant data/eligibility research.
• SRSP participant issue resolution.
• V3 implementation – work with Implementation Team on system enhancements including UAT, calc spec review, report/batch spec review, creating and reviewing test cases.
• Special projects or tasks, as assigned by management.

Qualifications (Competencies)

• Two years' experience in defined benefit administration or defined contribution plan administration preferred.
• Knowledge of pension calculations and validation of data elements preferred.
• Ability to prioritize work and meet deadlines.
• Strong proficiency in Microsoft Office Suite, specifically, Microsoft Excel (a proficiency assessment will be administered).
• MS Dynamics and QlikView experience preferred.
• V3locity V10 experience helpful.
• Strong analytical, problem solving, and decision-making skills.
• Excellent organizational and prioritizing skills.
• Detail-oriented with strong ability to multitask.

Soft Skills (Interpersonal Skills)

• Demonstrated customer service orientation.
• Strong oral and written interpersonal skills.
• Ability to work both independently and as a team player.
• Ability to effectively operate in a fast-paced work environment.

Education

Bachelor's degree required from an accredited university with concentration in Math, Accounting, or related analytical field.

Reasoning Ability

High

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals to perform the essential functions.

• Under 1/3 of the time: Standing, Walking, Climbing or Balancing, Stooping, Kneeling, Crouching, or Crawling
• Over 2/3 of the time: Talking or Hearing
• 100% of the time: Using Hands

Work Environment

Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.