Consultant, ESI Processing and Data Transformation l Technology

Job description

Who We Are FTI Consulting is the leading global expert firm for organizations facing crisis and transformation. We work with many of the world’s top multinational corporations, law firms, banks and private equity firms on their most important issues to deliver impact that makes a difference. From resolving disputes, navigating crises, managing risk and optimizing performance, our teams respond rapidly to dynamic and complex situations. At FTI Consulting, you’ll work side-by side with leaders who have shaped history, helping solve the biggest challenges making headlines today. From day one, you’ll be an integral part of a focused team where you can make a real impact. You’ll be surrounded by an open, collaborative culture that embraces diversity, recognition, professional development and, most importantly, you. Are you ready to make your impact? About The Role We are seeking a Consultant / Senior Consultant to join our Data Engineering team. The role supports eDiscovery and data investigation engagements through data processing, transformation, analysis, troubleshooting and production support. The successful candidate will apply strong SQL skills, working knowledge of eDiscovery workflows and practical scripting capabilities to deliver accurate, timely results in collaboration with local and global teams. Work flexibly across projects, shifting priorities and deadlines; participate in global team coverage and, when required, evening, night, weekend or holiday work based on project needs. Be willing to travel for client or business requirements, generally with advance notice. Maintain responsiveness, professionalism, confidentiality and a client-service mindset in interactions with internal and external stakeholders. Take ownership of assigned work, communicate progress and risks promptly, and learn new tools, data sources and processes as engagement needs evolve. What You’ll Do Perform data intake, processing, extraction, conversion, transformation, analysis, loading, export and production support for eDiscovery and data investigation matters. Map, cleanse, normalize and reconcile metadata; resolve issues involving identifiers, document families, date/time values, character encoding and inconsistent source data. Prepare, validate and troubleshoot eDiscovery load files and related native, text and image deliverables; perform documented quality-control checks for accuracy, completeness and integrity. Investigate processing exceptions and technical issues, recommend practical solutions and escalate risks or dependencies appropriately. Coordinate with case teams and stakeholders to clarify requirements, provide timely updates, manage assigned deliverables and document procedures, scripts and resolutions. Identify opportunities to standardize or automate repetitive workflows and improve quality and efficiency. How You’ll Grow We are committed to investing and supporting you in your professional development and we have developed a range of programs focused on fostering leadership, growth and development opportunities. We aim to promote continuous learning and individual skills development through on-the-job learning, self-guided professional development courses and certifications. You’ll be assigned a dedicated coach to mentor, guide and support you through regular coaching sessions and serve as an advocate for your professional growth. As you progress through your career at FTI Consulting, we offer tailored programs for critical professional milestones to ensure you are prepared and empowered to take on your next role. What You Will Need to Succeed Basic Qualifications Bachelor’s degree in Computer Science, Information Technology, Information Systems or a related discipline, or equivalent relevant practical experience. Consultant : typically 2+ years of relevant experience in eDiscovery, data processing, data transformation or comparable technical data operations. Senior Consultant : typically 3–5+ years of relevant experience, including independent delivery of complex technical tasks, troubleshooting and coordination with project teams. Preferred, not mandatory: familiarity with EDRM; Nuix or other review/processing platforms; Microsoft 365, Teams, Slack, SharePoint, OneDrive, Google Workspace or mobile extraction data; large-volume SQL optimization; PowerShell, pandas/openpyxl, regular expressions or Relativity APIs; and consulting or litigation support experience. Strong analytical thinking, attention to detail and a methodical approach to troubleshooting and quality control. Clear written and verbal communication, including the ability to explain technical findings to non-technical colleagues and stakeholders. Ability to organize and prioritize multiple tasks, follow documented processes, work independently within assigned scope and collaborate across teams. Initiative, adaptability and willingness to learn unfamiliar tools, workflows and digital data sources. Preferred Qualifications Strong working proficiency in Microsoft SQL Server / T-SQL for data manipulation, joins, complex queries, scripts, stored procedures and troubleshooting. Working knowledge of eDiscovery workflows and platforms such as Relativity, including imports/exports, metadata management, review support and productions. Ability to work with common eDiscovery load files (DAT, OPT, CSV) and structured or semi-structured formats such as Excel, JSON and XML. Basic Python scripting skills for file handling, ad-hoc data processing and automation; ability to adapt and troubleshoot existing scripts. Comfort with Microsoft Windows and Office tools, especially Excel, for day-to-day technical operations and validation. FTI Consulting is an equal opportunity employer and does not discriminate on the basis of race, color, national origin, ancestry, citizenship status, protected veteran status, religion, physical or mental disability, marital status, sex, sexual orientation, gender identity or expression, age, or any other basis protected by law, ordinance, or regulation.