Skip Navigation

Technical Analyst

Location: King of Prussia, Pennsylvania, United States

Secondary Locations: Mt. Laurel,New Jersey,United States;

Company: Marsh & McLennan Agency

Job ID R_061842-en

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 Trion’s proprietary software and other 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 SQL and/or 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.


  • 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 Microsoft Access and/or SQL is required;
  • 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.


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


  • 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 is typically performed either on site at Trion’s King of Prussia, PA or Mt. Laurel, NJ office, or at various customer/Trion locations as required.
Apply Later
  • Stay Connected

    Join our Talent Community and receive information on future opportunities.

    Sign Up

  • Saved Jobs

    You have not saved any jobs.

    See All Saved Jobs

  • Mercer Campus Careers

    Mercer offers many exciting and fruitful internship and entry-level positions.

    Learn more here

  • Leadership Recognition

    Dan Glaser, President and CEO, has been named to Institutional Investor magazine’s 2017 All-America Executive Team ranked as the #3 Overall CEO in the insurance industry, #3 with buy-side analysts and #2 with sell-side analysts.

  • Careers at Marsh & McLennan Companies