Requirements
- Legally authorized to work in the US without employer sponsorship, now or in the future
- Active Top Secret security clearance
- 5+ years professional experience with SQL and/or ETL development, including complex SQL queries and data integration workflows
- Experience with SQL, ETL, relational databases, and data warehouse concepts
- Experience with PostgreSQL and/or Informatica ETL
- Ability to work onsite at the client site in downtown Washington, DC
Skills
Nice to have
Full job description
Work You'll Do
As a Project Analytics and Insights Engineer III on the project, you will:
- Support the strategy and program management functions as part of a fast-paced development effort to re-architect and modernize a high-visibility system.
- Partner closely with Federal Law Enforcement clients and functional team members to gather, define, document, and translate business and technical requirements into effective data solutions.
- Design, develop, and implement complex SQL code and ETL workflows to support data processing, integration, and system modernization needs.
- Develop and execute unit test plans, prepare test data, document results, and perform comprehensive data validation and testing.
- Test, debug, troubleshoot, and resolve SQL, ETL, and data-related issues in development and production environments.
- Ability to work independently and collaborate as part of a team
- Effective written and verbal communication skills
- Meticulous attention to detail and quality of work product
- Ability to build and sustain professional relationships
- Ability to lead projects or workstreams
- Ability to manage and prioritize multiple tasks in a fast-paced and dynamic environment
- Strong interpersonal skills and professional demeanor
- Ability to meet deadlines
- Ability to provide clear guidance to others
Deloitte's Government & 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 professionals brings fresh perspective to help clients anticipate disruption, reimagine the possible, and fulfill their mission promise.
Our AI & Data offering provides a full spectrum of solutions for designing, developing, and operating cutting-edge Data and AI platforms, products, insights, and services. Our offerings help clients innovate, enhance and operate their data, AI, and analytics capabilities, ensuring they can mature and scale effectively.
The Project Delivery Talent Model is designed for professionals with specialized skills that align to a current client need. Team members focus on delivering services to clients, without additional expectations related to business development or promotion. Their employment is tied to their role on a project, and they are eligible for a benefits package that is competitive for project delivery-focused professionals.
Qualifications
Required:
- Bachelor's degree
- 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
- 5+ total years of professional experience with SQL and/or ETL development, including hands-on experience developing complex SQL queries and data integration workflows.
- Experience with SQL, ETL, relational databases, and data warehouse concepts; experience with PostgreSQL and/or Informatica ETL strongly preferred.
- Ability to work onsite at the client site in downtown Washington, DC.
You may also be eligible to participate in a discretionary annual incentive program, subject to the rules governing the program, whereby an award, if any, depends on various factors, including, without limitation, individual and organizational performance.
Opens Deloitte LLP’s own application page in a new tab.