Associate Consultant (Intern) - Data Analytics

ABOUT THE FIRM

StoneTurn, a global professional services firm, works with law firms, corporations, and government agencies in solving the most complex and consequential business issues. Our team provides a broad range of services across investigations, compliance, economics, technology, cybersecurity, and business and litigation advisory. Province and StoneTurn together form a leading global advisory firm that helps clients navigate their most complex strategic, operational, financial, and legal challenges. By integrating StoneTurn's investigative, compliance, and dispute capabilities with Province's established leadership in restructuring, interim management, capital markets, and litigation support, the combined firm brings deep global experience, a proven track record in high-stakes matters, and a multidisciplinary approach to each engagement.

Our core values guide how we work, make decisions, and serve our clients and communities. We are committed to forging deep, trust-based relationships; delivering excellence through accountability and innovation; maintaining a relentless focus on client outcomes; and empowering our people to grow, collaborate, and make a meaningful impact. These principles shape our culture and define what it means to succeed at our firm.

StoneTurn is seeking a qualified Associate Consultant (Intern) to join our Data Science & Analytics practice.

ROLE SUMMARY

The Data Science & Analytics practice at StoneTurn both serves clients directly and supports other practice areas through the analysis of structure and unstructured business or third-party data. In serving clients directly, engagements focus on empowering our clients by providing key data-driven insights based on dynamic visualizations, identification of trends or anomalies, quantification of financial impact, and the efficient operationalization of company data. The group also enhances the capabilities of, and brings added efficiencies to, other key StoneTurn practice areas by providing a full spectrum of data science and analytics services to compliance, investigation, and litigation matters. Applying more than just programming and technical expertise, our Data Science and Data Analytics professionals think critically to understand engagement objectives, adapt to changing client needs, and participate fully in the planning, execution and delivery of value-added services.

As an Associate Consultant (Intern) in the Data Science & Analytics practice your primary responsibility will be to deliver data analytics solutions across a variety of consulting engagements. You will work with multi-disciplinary professionals within the Data Science & Analytics group to develop and execute business development strategies. You will also be required to contribute towards pre-sales and practice development activities such as sales pitches, proposals, workplans, thought leadership content, case studies et al.

ROLE AND RESPONSIBILITIES

• Participate in data-collection conversations with our attorney clients
• Prepare strategic analysis plans with StoneTurn colleagues
• Collect, import, and validate client datasets
• Perform analytic data-mining activities manipulating data such to interpret financial patterns, unusual activity and dynamic financial damages theories.
• Consistently work with several relational databases building on past professional experiences utilizing data mining, anomaly testing among other data analytics skills to deliver quality work product.
• Communicate effectively providing quality data analytics work product to attorneys on a variety of complex business matters often performed in the dispute litigation environment
• Communicate data requirements and intricacies with technical and non-technical professionals

QUALIFICATIONS / IDEAL CANDIDATE

• Bachelor's Degree in progress within computer science, or a business field with proven proficiency in computer science.
• Relational database experience:
  • SQL proficiency required
  • The ability to import data from a variety of sources and platforms
  • Basic knowledge of database maintenance
• Full understanding and advanced knowledge of Microsoft suite of products (Excel, Word, Outlook, Access, SharePoint, etc.). A demonstrated ability to create complex formulas, chart creation, and use pivot functionality.
• Strong time management skills to allow for optimal delivery, maintaining composure in highly stressful situations.
• Demonstrated record of working well in both team and independent atmospheres.
• Strong written and verbal communication skills.
• Willingness to travel to meet the needs of client requirements

DESIRABLE QUALIFICATIONS

• Experience with programming languages such as Python, .NET, or VBA
• Experience with Oracle
• Fundamental knowledge of accounting, finance, and economics
• Knowledge in out-of-box accounting solutions (QuickBooks, SAGE)
• Familiarity with visualization tools:
  • Tableau
  • Power BI
  • Qlikview
  • Or similar
• Familiarity with statistical software:
  • R
  • Stata
  • SAS
  • Or similar

ADDITIONAL INFORMATION

A 10-week internship from June through August

A "seasonal employee" is an employee who is hired into a position for which the customary annual employment is six months or less.

AFFIRMATIVE ACTION/EEO STATEMENT:

Our firm provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment in accordance with applicable federal, state, or local laws.

ADDITIONAL INFORMATION:

This job description outlines the primary responsibilities of the position. It does not encompass all duties that may be required in this role. The employee may be expected to perform additional job-related tasks and responsibilities as instructed by management within the boundaries of applicable law. Management reserves the right to add, revise, or delete information in this job description. Reasonable accommodation will be provided to qualified individuals with disabilities as required by law. This document does not create an employment contract, implied or otherwise, other than an "at-will" employment relationship.