CA-SQL - Solution Advisor

4 days left

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

Job title: Complex Analytics - Consultant/Senior Consultant (SA/LSA)


At Deloitte, we do not offer you just a job, but a career in the highly sought-after risk Management field. We are one of the business leaders in the risk market. We work with a vision to make the world more prosperous, trustworthy, and safe. Deloitte's clients, primarily based outside of India, are large, complex organizations that constantly evolve and innovate to build better products and services. In the process, they encounter various risks and the work we do to help them address these risks is increasingly important to their success-and to the strength of the economy and public security.

By joining us, you will get to work with diverse teams of professionals who design, manage, and implement risk-centric solutions across a variety of domains. In the process, you will gain exposure to the risk-centric challenges faced in today's world by organizations across a range of industry sectors and become subject matter experts in those areas.

Our Risk and Financial Advisory services professionals help organizations effectively navigate business risks and opportunities-from strategic, reputation, and financial risks to operational, cyber, and regulatory risks-to gain competitive advantage. We apply our experience in ongoing business operations and corporate lifecycle events to help clients become stronger and more resilient. Our market-leading teams help clients embrace complexity to accelerate performance, disrupt through innovation, and lead in their industries. We use cutting-edge technology like AI/ML techniques, analytics, and RPA to solve Deloitte's clients' most complex issues. Working in Risk and Financial Advisory at Deloitte US-India offices has the power to redefine your ambitions.

The Team

Regulatory & Legal Services

We help organizations in their efforts to achieve regulatory and legal compliance and transform their departments to add greater value to the business. We combine highly specialized skills in discovery and data management, corporate investigations, Foreign Corrupt Practices Act, and anti-fraud with financial acumen and advanced analytics to produce transformative insights.

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.

Work you'll do

The key job responsibilities will be to:

§ Develop SQL scripts using Dynamic SQL based on the requirements gathered in 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.

Required skills

§ 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 environment

§ Bachelor's degree in a Computer discipline or commensurate work experience.

Preferred skills

§ 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.

  • B.Tech/M.Tech/MS/MBA

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: 146865