Data Analyst I, Prime Clerk at Duff & Phelps, LLC in New York, New York

Job Description:

In a world of disruption and increasingly complex business challenges, our professionals bring truth into focus with the Kroll Lens. Our sharp analytical skills, paired with the latest technology, allow us to give our clients clarity-not just answers-in all areas of business. We value the diverse backgrounds and perspectives that enable us to think globally. As part of One team, One Kroll , you'll contribute to a supportive and collaborative work environment that empowers you to excel.

Prime Clerk, part of Kroll's Business Services division, is the leader in global, end-to-end restructuring administration services. We offer the industry's leading suite of technology-driven and consulting services to support restructurings of every complexity, size, industry and type. Additionally, our unmatched public securities and solicitation expertise provides clients with the comprehensive resources they need to execute corporate transactions globally.

Kroll Business Services is the global leader in complex claims administration and legal and business solutions. As an integral part of Kroll, the world's premier provider of services and digital products related to governance, risk and transparency, Kroll Business Services is supported by nearly 5,000 professionals in 30 countries and territories around the world

At Kroll, your work will help deliver clarity to our clients' most complex governance, risk and transparency challenges. Apply now to join One team, One Kroll .

Note: This position can be remote in the US.

Preferred Location: US West Coast.

RESPONSIBILITIES:

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 a production environment
• Perform SQL queries and analyze results
• Provide data processing support for the client services team
• Seek to establish and implement process improvements at the direction of the department manager
• Testing own work to ensure compliance with requirements before handing off to QA.
• Candidate must be detail oriented, work at a good pace, be able to work independently and willing to work long hours (as necessary).

REQUIREMENTS:

• SQL knowledge is required
  
  
  • Experience creating and supporting complex SQL Server objects, batch processes and batch scripts

• 
  
  • Experience performing complex data analysis of large datasets
  • Experience tuning T-SQL queries
  • Experience using SQL Server error handling
  • Experience using source control
• Expertise with advanced Excel and data manipulation
• VBA Scripting
• Data cleansing and data manipulation
• Ability to understand complex business processes and adapt solutions to meet the needs of the business
• Excellent communication skills for interaction with peers, managers and business stakeholders
• Must enjoy and have experience working in a fast paced environment
• Ability to quickly realign with shifting priorities
• Reporting Services (SSRS) experience a plus
• Knowledge or Power Query and Power Query M a huge plus
• Flexibility with work schedule is a must - shifts will cover all hours of operations, including beyond ordinary business hours (rotating shifts 9:00-6:00pm EST and 1:00pm - 10:00pm EST)

To learn more, please visit www.krollbusinessservices.com

In order to be considered for a position, you must formally apply via careers.kroll.com.

Kroll is committed to creating an inclusive work environment. We are proud to be an equal opportunity employer and will consider all qualified applicants regardless of gender, gender identity, race, religion, color, nationality, ethnic origin, sexual orientation, marital status, veteran status, age or disability.

#LI-RemotePrime Clerk, part of Kroll's Business Services division, is the leader in global, end-to-end restructuring administration services. We offer the industry's leading suite of technology-driven and consulting services to support restructurings of every complexity, size, industry and type. Additionally, our unmatched public securities and solicitation expertise provides clients with the comprehensive resources they need to execute corporate transactions globally.