25 days old

Data Analyst II, Prime Clerk

Duff & Phelps, LLC
New York, NY 10007
  • Job Code

Prime Clerk is the leading global provider of complex claims administration and business services. Through our proprietary technology platforms and industry experts, we provide a full suite of claims administration services, leading notice media solutions, a robust business services platform and unrivaled subject matter expertise in global corporate actions. As a division of Duff & Phelps, Prime Clerk and its affiliates employ more than 3,500 employees in over 70 offices around the world.

The Data Analyst position is primarily responsible for supporting the Client Services department related to data parsing, importing, managing and analyzing of client data. The selected candidate will work as part of a high functioning team, tasked with supporting day to day operations of a busy Legal Services provider. Independently define and develop solutions, with minimal direction, for a wide range of technical problems. Participate in team meetings and other collaborations, as well as design and peer reviews. Be flexible; prepared to approach things laterally; able to think outside the box. Interface with business stakeholders, to identify or clarify requirements in order to address various problems.


  • Serve as a resource for executing ad-hoc data requests, custom reports, test scenarios, data migration, data analysis and quality assurance testing in an operations environment.
  • Develop robust spreadsheet models with clearly defined inputs, calculations, and final output.
  • Understand, evaluate and provide documentation, including data flow mapping, for new and existing spreadsheet models.
  • Author queries to extract data from corporate sources for data analysis & reporting.
  • Rearrange files, directories, and subdirectories in the DOS command line.
  • Import data files into a Microsoft SQL Server database.
  • Characterize results of data analysis in clear and simple terms for non-technical staff.
  • Restructure and reconcile Excel files.
  • Develop computer programs or macros to help automate repetitive manual tasks.
  • Develop automated and reusable routines for extracting information from various data sources.
  • Utilize VBA in new and existing Excel-based tools to automate recurring work processes.
  • Integrate capability in Excel-based tools to both pull and push data from/to SharePoint Server.
  • Work with data in SQL Server databases, Oracle databases, and SAS

  • A bachelor's or master's degree in mathematics, computer science, physics, chemistry, engineering, finance, accounting, or economics
  • Experience in coding, programming, macros, or scripting
  • Flexibility and willingness to figure it out as we go along
  • Enthusiasm and desire to learn lots of technical skills

Preferred Skills:
  • Experience with SQL queries.
  • Experience with Excel VBA macros.
  • Experience in complex formula authoring, array functions, dynamic named ranges, pivot tables, data validation, V & H lookups and conditional formatting
  • Experience with computer programming (Java, Ruby, Python, Perl, R, SAS, C, C++, etc.)
  • Experience with DOS command line.
  • Experience with SharePoint Designer, InfoPath, Web Parts and workflow creation is a PLUS

In order to be considered for a position at Duff & Phelps, you must formally apply via careers.duffandphelps.jobs

Duff & Phelps is committed to providing equal opportunities in employment. We will not discriminate between applications for reason of gender, gender identity, race, religion, color, nationality, ethnic origin, sexual orientation, marital status, veteran status, age or disability .

Posted: 2020-10-04 Expires: 2020-11-02
Sponsored by:
ADP Logo
Sponsored by:
Bank of America Logo

Featured Jobs[ View All ]

Featured Employers

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Analyst II, Prime Clerk

Duff & Phelps, LLC
New York, NY 10007

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast