Process Analyst

We have a direct hire opportunity for a qualified process analyst. Our clients provide electronic bulk and seriatim transaction and inforce files to the Structured Solutions Products Management Team (SSPM). This data must be converted to a standard format, validated, mapped to treaties, mapped to standard transaction codes and valuation models, imported for accounting and billing, and loaded to the data warehouse. The client bulk files are primarily used to update and communicate aggregate client premium and claim payments and policy movement (transactions including premiums, deaths, annuitizations, terminations, withdrawals, and changes) as well as commission and expense allowances. The client seriatim inforce files are the client's statement of all policy details and values that they have ceded to as of a period end date, and they should correspond to client bulk reporting as of the same period. These files are also the source for inputs to all valuation models. This also receives underlying portfolio investment or trust reporting for some blocks.

Major Responsibilities :

• Research problems on incoming data and reporting from clients - work closely with groups within - Data Quality, SSPM, Actuarial and Finance/Accounting Departments to identify and resolve key issues.
• Compare and reconcile bulk to seriatim data and reporting files - thorough understanding of the downstream impact of data integrity.
• Inform appropriate parties of client reporting issues and anomalies - communicate findings thoroughly and timely.
• Participate in ongoing process improvement efforts - identify opportunities to increase operational efficiency.
• Populate data/reporting inventories, experience reports, Management reports, LOC requests, trust testing, etc.
• Identify and understand trends in the business, quantify impacts, and develop/implement ongoing analytical toolsets to trap future occurrences.
• Create & follow-through on Competency Development Plan, resulting in enhanced ability to process the business & serve the customer.
• Adhere to unit standards & accurately report the status of unprocessed work.
• Utilize instruments and methods for the evaluation and quality control of research or operational data.
• Assist other SSPM Team members in processing, billing, and reporting activities.

Minimum Requirements/Skills :

• BA/BS degree in Accounting/Business, Data Management, or related field or equivalent experience.
• 2+ years of experience in Life Insurance/Financial Services with customer/data administration experience.
• Demonstrated problem solving skills with the ability to start analysis at a detail level and develop the big picture or to start at the big picture level and deconstruct into detail analysis.
• Demonstrated analytical skills; must be extremely detail oriented & effective in production-oriented environment.
• Exceptional customer orientation skills.
• Proficient PC spreadsheet skills in a Windows environment, including MS Word, Excel & Access. Extensive use of Access and/or exposure to SQL Server/Oracle is preferred.
• Expertise with databases and spreadsheet programs and query tools to perform analytics on data.
• Experience with programming languages such as Visual Basic, .NET, etc. in creating programs to perform analytics on data.

Desired Behavioral Characteristics :

• Business acumen with the ability to recognize implications of business decisions and strategy.
• Technical expertise to analyze large volumes of data.
• Excellent creative problem solving and decision-making skills.
• Detail-oriented, analytical, and accurate.
• Capability to interact at any level within the organization.
• Capability to work on your own initiative.

Competencies :

• Decision Making - Identifying and understanding issues, problems, and opportunities; comparing data from different sources to draw conclusions; using effective approaches for choosing a course of action or developing appropriate solutions; taking action that is consistent with available facts, constraints, and probable consequences.
• Work Standards - Setting high standards of performance for self and others; assuming responsibility and accountability for successfully completing assignments or tasks; self-imposing standards of excellence rather than having standards imposed.
• Initiating Action - Taking prompt action to accomplish objectives; taking action to achieve goals beyond what is required; being proactive.
• Building Strategic Working Relationships - Developing and using collaborative relationships to facilitate the accomplishment of work goals.
• Customer Focus - Making customers and their needs a primary focus of one's actions; developing and sustaining productive customer relationships.
• Communication - Clearly conveying information and ideas through a variety of media to individuals or groups in a manner that engages the audience and helps them understand and retain the message.