Technical Analyst

Company:

Marsh McLennan Agency

Description:

The Technical Analyst is responsible for the technical tasks and deliverables in regards to clients' benefit plan implementations, open enrollments, ongoing administration, and special projects. This includes working collaboratively with clients, carriers, and internal departments to develop technical and functional specifications, create and execute comprehensive test plans, and consult on system design, implementations, and business process flows.

ESSENTIAL DUTIES AND RESPONSIBILITIES include, but are not limited, to the following:

• Utilize Marsh McLennan's software applications to perform system setup, analysis, maintenance, and enhancements as required by clients' needs and project plan specifications;

• Establish and cultivate relationships with clients, vendors, carriers and internal departments to ensure successful implementations, renewals and ongoing administration;

• Gather and document business requirements to develop technical and functional design specifications for new programs or modifications to existing programs per client requirements;

• Analyze technical requirements, test plans, training materials and procedure documents;

• Execute test plans and test case scenarios to ensure requirements are being met;

• Perform data manipulation, mapping, conversions, and validations utilizing internal systems, external files, Access, and Excel;

• Create and execute Access queries to determine proper data logic and file structures;

• Develop and generate client specific or ad-hoc reports and provide escalated support for specific files such as, but not limited to, carrier files, enrollment counts, payroll files, census files, and billing reports while verifying reports meet quality standards;

• Assist with Project Management tasks such as scope definition, project plans, issue management, and status updates;

• Actively participate in meetings to provide technical subject matter expertise for clients, carriers and other internal departments;

• Provide daily support of client partnerships by delivering prompt, thorough, and client-centric responses to customized and standard requests;

• Resolve complex and escalated issues as well as identifying higher level risk;

• Support client implementations, renewals, and other project initiatives as needed;

• Possess thorough understanding and provide knowledge sharing of client and carrier data structures for proper data integration;

• Assist with the development and documentation operational standards and best practices;

• Train members of the technical analyst team and other internal departments as needed;

• Perform other duties or special projects as assigned.

REQUIRED EDUCATION AND EXPERIENCE:

• Bachelors degree in Management Information Systems, Computer Science, Mathematics or equivalent work experience is preferred;

• Minimum of 2 years of technical analytical work experience required (i.e. technical specification writing, test plan development, ad hoc report writing, data conversion, etc.);

• Working knowledge of Microsoft Access and Microsoft Excel is required; able to utilize applications for data manipulation, data analysis, reporting, and dashboard creation.

• Client facing experience is highly preferred;

• Knowledge of Software Development Life Cycle methodology (SDLC) is preferred;

• Experience within a health care, health and welfare consulting, insurance brokerage, human resources consulting, or employee benefits industry is highly preferred;

• Related exposure to Benefits Administration, COBRA, Spending Accounts, HRIS, and/or Payroll environments is a plus.

KNOWLEDGE, SKILLS AND ABILITIES

• Proven ability to multitask, adjust priorities, meet deadlines, and successfully operate in a fast-paced work environment;

• Ability to follow through on and successfully execute tasks while adhering to specified quality standards;

• Excellent problem analysis, troubleshooting, problem solving and decision making skills;

• Strong organizational, analytical skills and strong attention to detail;

• Possess proactive mindset to seek information to create effective solutions;

• Strong project management and project planning skills;

• Skills in delegating tasks and responsibilities;

• Skills in coaching, mentoring, teambuilding and motivating others;

• Proven ability to build rapport while providing superior customer service and maintaining positive relationships with internal teams and client contacts;

• Ability to work well independently and as a team member;

• Excellent interpersonal, verbal and written communication skills;

• Intermediate experience in the Microsoft Office Suite, including Word, Excel, Access, and Outlook.

PHYSICAL DEMANDS AND WORK ENVIRONMENT

• 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 with disabilities to perform the essential functions.

• While performing the duties of this job, the employee is:

• Frequently required to sit; speak or hear; use hands to finger, handle, feel objects, and reach with hands and arms;

• Occasionally required to stand and walk;

• Extensive use of computer and keyboard and viewing of computer screen is required;

• Specific vision abilities required by this job include vision, and ability to adjust focus.

• Other working conditions are normal for an office environment.

WORK LOCATION

• Work is typically in a hybrid manner based out of our Conshohocken, PA, office.

We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. Marsh & McLennan Agency offers competitive salaries and comprehensive benefits and programs including: health and welfare, tuition assistance, 401K, employee assistance program, domestic partnership benefits, career mobility, employee network groups, volunteer opportunities, and other programs. For more information about our company, please visit us at: http://marshmma.com/careers.