Position Summary

Are you ready for an exciting opportunity that offers professional growth? Do you want to utilize cutting edge approaches and technology to identify and mitigate emerging threats within our client environments, all while helping support important missions? Are you a problem solver and an innovator with a passion for investigating illicit acts by US adversaries in order to protect our national interests?  Deloitte’s Investigations & Intelligence (I&I) team could be the place for you!  We help clients gather and understand vast amounts of information; analyze it through deep understanding of their regulatory, administrative, criminal or executive authorities; and produce tailored insights that inform enforcement or other legal actions. Join our team and begin tackling these critical issues in a collaborative team environment.

 

Work you’ll do 

  • Fulfill the customer's vision for enterprise data sharing capabilities
  • Responsible for the development of analytical solutions and databases
  • Develops specifications for the most efficient database solutions
  • Supports the evaluation and selection of solutions that meets customer requirements
  • Performs work involved in one or more of the phases of developing software used in products or services provided to the customer

The team 

Deloitte’s Government and Public Services (GPS) practice – our people, ideas, technology and outcomes—is designed for impact. Serving federal, state, & local government clients as well as public higher education institutions, our team of over 15,000+ professionals brings fresh perspective to help clients anticipate disruption, reimagine the possible, and fulfill their mission promise.   

The I&I team supports our GPS clients by delivering capabilities across the investigative lifecycle in the regulatory, civilian, law enforcement, health, and national security domains. Our professionals help our clients to identify, combat, and mitigate national security threats such as fraud, money laundering, sanctions violations, cybercrime, threats of terrorism, human trafficking, narcotics trafficking, litigations, and disputes.

 

Qualifications 

Required:  

  • Bachelor’s degree required 
  • Must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future 
  • Active Top Secret security clearance required 
  • Good working knowledge and hands-on experience with key software platform architectures, web servers, application servers, and relational databases
  • AWS Data Engineer experienced in building and maintaining transactional and reporting databases
  • 5+ years of experience working in Data Engineering or related roles
  • Strong experience with SQL
  • Proven experience designing, optimizing, and maintaining relational and non-relational databases, such as MySQL, SQL Server, Mongo, Cassandra, or equivalent
  • Expert knowledge of AWS RDS, DynamoDB, and RedShift
  • Experience with ETL, data analytics, and building data pipelines
  • Experience with AWS services such as CloudFormation, EC2, Kinesis, Lambda, SQS, CloudWatch, S3, and AWS Glue
  • Strong understanding of stored procedures, database functions, clustered/non-clustered indexes, and query plan information to troubleshoot performance related issues
  • Experience with data at-rest and in-transit encryption
Preferred:
  • AWS Certified Solutions Architect - Associate
  • Familiar with Agile and Waterfall methodologies

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.

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. Learn more about our commitment to developing our people.


As used in this posting, “Deloitte Advisory” means Deloitte & Touche LLP, which provides audit and enterprise risk services; Deloitte Financial Advisory Services LLP, which provides forensic, dispute, and other consulting services; and its affiliate, Deloitte Transactions and Business Analytics LLP, which provides a wide range of advisory and analytics services. Deloitte Transactions and Business Analytics LLP is not a certified public accounting firm. Please see www.deloitte.com/us/about for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. These entities are separate subsidiaries of Deloitte LLP.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.

Requisition code: 24787

SCAM ALERT

Caution against fraudulent job offers!

We have been informed of instances where jobseekers are led to believe of fictitious job opportunities with Deloitte US (“Deloitte”). In one or more such cases, false promises of actual or potential selection, or initiation or completion of the recruitment formalities appear to have been or are being made. Some jobseekers appear to have been asked to pay money to specified bank accounts of individuals or entities as a condition of their selection for a ‘job’ with Deloitte. These individuals or entities are in no way connected with Deloitte and do not represent or otherwise act on behalf of Deloitte.

We would like to clarify that:

  • At Deloitte, ethics and integrity are fundamental and not negotiable.
  • We are against corruption and neither offer bribes nor accept them, nor induce or permit any other party to make or receive bribes on our behalf.
  • We have not authorized any party or person to collect any money from jobseekers in any form whatsoever for promises of getting jobs in Deloitte.
  • We consider candidates on merit and that we provide an equal opportunity to eligible applicants.
  • No one other than designated Deloitte personnel (e.g., a Deloitte recruiter or Deloitte hiring partner) is permitted to extend any job offer from Deloitte.

Anyone who at any time has made or makes any payment to any party in exchange for promises of job or selection for a job with Deloitte or any matter related to this (including those for ‘registration’, ‘verification’ or ‘security deposit’) or otherwise engages with any such person who has made or makes fraudulent promises or offers, does so (or has done so) entirely at their own risk. Deloitte takes no responsibility or liability for any such unauthorized or fraudulent actions or engagements. We encourage jobseekers to exercise caution.