Data & Process Analyst

Job Description

Job Description

Job Code
519

Department Name
Retirement Services

Reports To
Manager of Retirement Programs

FLSA Status
Exempt

Union Code
N/A

Management
No

About Us:

Building Services 32BJ Benefit Funds (“the Funds”) is the umbrella organization responsible for administering Health, Pension, Retirement Savings, Training, and Legal Services benefits to over 185,000 SEIU 32BJ members. Our mission is to make significant contributions to the lives of our members by providing high quality benefits and services. Through our commitment, we embody five core values: Flexibility, Initiative, Respect, Sustainability, and Teamwork (FIRST). By following our core values, employees are open to different and new ways of doing things, take active steps to improve the organization, create an environment of trust and respect, approach their work with the intent of a positive outcome, and work collaboratively with colleagues.

The Funds oversees and manages $11 billion of dollars in assets, which are made up of many, varied and complex funds. The dollars come from a number of sources, including the property owners who pay into the funds on behalf of their employees, and as such, requires those who oversee and manage the money to be highly skilled financial management people.

32BJ Benefit Funds will continue to drive innovation, equity, and technology insights to further help the lives of our hard-working members and their families. We use cutting edge technology such as: M365, Dynamics 365 CRM, Dynamics 365 F&O, Azure, AWS, SQL, Snowflake, QlikView, and more.

Please take a moment to watch our video to learn more about our culture and contributions to our members: youtu.be/hYNdMGLn19A

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 decisions-making skills.

• Excellent organizational and prioritizing skills.

• Detailed 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.