CA-SQL - Consultant

Apr 22, 2024
Apr 28, 2024
Work Mode
Full Time
Organization Type
Academia, Corporate
Position Summary


Deloitte Transactions and Business Analytics LLP advises clients on managing business controversy and conflict, executing deals, and maintaining regulatory compliance. We provide services to companies throughout their lifecycle from purchasing a company to investigating potential fraud.

In 2008, Deloitte Transactions and Business Analytics LLP (DTBA) opened a new facility in Nashville, TN for e-discovery and computer forensics work. DTBA's E-Discovery Solutions Center ("EDSC") continues to increase the capacity, quality, and efficiency of DTBA' s e-file processing by utilizing state-of-the-art technology in a dedicated environment. We are looking for dedicated individuals to join DTBA's Analytic & Forensic Technology practice and help drive the success of the EDSC.

The EDSC is a 24x7, 365 days a year operation.

Complex Analytics team:

Complex Analytics is the team that generates customized technical solutions for project specific needs. The solutions include writing SQL scripts using dynamic SQL that are executed on demand or on a recurring basis. We also build custom applications and in house innovative tools that can be executed independently. The team also generates various reports to the clients using SSRS platform. Data investigations, Relativity Event Handlers, and Relativity Script Kits are used across Multiple clients with eDiscovery services. Deloitte's eDiscovery Solution Center (EDSC) assists our clients with litigation and crisis-related data challenges including collecting, processing, analyzing, and producing large amounts of information.

Roles and Responsibilities

Develop SQL scripts using Dynamic SQL based on the requirements gatheredin the most optimized structure.

Create and debug stored procedures and user defined functions.

Performs intermediate to basic troubleshooting, analyzing situations or data anomalies.

Able to understand the existing workflow and execute pre-written scripts and reports and validate the results accurately.

Demonstrates good judgment in using methods and techniques for obtaining optimized solutions.

Work independently and be able to provide support and take ownership of issues or exceptions as identified.

Follows through and provides status updates on requests.

Takes initiative to understand the solution and client objectives.Communicates effectively with leadership and seeks guidance at appropriate times.

Exhibits curiosity, enthusiasm to learn and advance technology capabilities, and is confident to put thoughts forward in a collaborative setting with more experienced colleagues.

Qualifications Required:

Flexible to work in Night shifts and the weekends for long term.

Education or experience analyzing business problems, transactional data, or unstructured data.

Scripting experience with SQL coding is mandatory.

Experience in handling multiple concurrent activities within a technical environmentBachelor's degree in a Computer discipline or commensurate work experience.


Experience with e-Discovery operations or engineering experience or advanced application development, application maintenance, and relational database technologies is a plus.

Knowledge of common e-Discovery tools is a plus (i.e. Concordance, Relativity, Introspect, Discovery Cracker, IPRO, and OCR software packages)

Prior working experience on Debugging, Exception Handling, and Dynamic SQL is a plus.

Hands on experience with both traditional (Boolean and key word search) as well as concept-based search tools and technologies is a plus.

Knowledge on Power BI or any other reporting tool is a plus.

Excellent verbal and written communication skills with both internal staff and clients.

How you'll grow

At Deloitte, our professional development plan focuses on helping people at every level of their career to identify and use their strengths to do their best work every day. From entry- level employees to senior leaders, we believe there's always room to learn. We offer opportunities to help sharpen skills in addition to hands-on experience in the global, fast- changing business world. From on-the-job learning experiences to formal development programs at Deloitte University, our professionals have a variety of opportunities to continue to grow throughout their career. Explore Deloitte University, The Leadership Center.


At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you.

Deloitte's culture

Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture where our people excel and lead healthy, happy lives. Learn more about Life at Deloitte.

Corporate citizenship

Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill- based volunteerism, and leadership to help drive positive social impact in our communities.

Learn more about Deloitte's impact on the world.

Deloitte refers to one or more of Deloitte Touche Tohmatsu Limited, a UK private company limited by guarantee ("DTTL"), its network of member firms, and their related entities. DTTL and each of its member firms are legally separate and independent entities. DTTL (also referred to as "Deloitte Global") does not provide services to clients. In the United States, Deloitte refers to one or more of the US member firms of DTTL, their related entities that operate using the "Deloitte" name in the United States and their respective affiliates. Certain services may not be available to attest clients under the rules and regulations of public accounting.

Please see to learn more about our global network of member firms.

Copyright 2021 Deloitte Development LLC. All rights reserved.

Recruiting tips

From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte.Check out recruiting tips from Deloitte recruiters.


At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits.Learn more about what working at Deloitte can mean for you.

Our people and culture

Our diverse, equitable, and inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our client most complex challenges. This makes Deloitte one of the most rewarding places to work.Learn more about our inclusive culture.

Our purpose

Deloitte's purpose is to make an impact that matters for our clients, our people, and in our communities. We are creating trust and confidence in a more equitable society. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. We are focusing our collective efforts to advance sustainability, equity, and trust that come to life through our core commitments.Learn more about Deloitte's purpose, commitments, and impact.

Professional development

From entry-level employees to senior leaders, we believe there's always room to learn. We offer opportunities to build new skills, take on leadership opportunities and connect and grow through mentorship. From on-the-job learning experiences to formal development programs, our professionals have a variety of opportunities to continue to grow throughout their career.

Requisition code: 147778