SQL Developer SR Onsite in Fairfax, VA

Seeking a Sr. SQL Developer / Enterprise Data Warehouse with Data Warehousing and cloud environment experience to support to the Office of Information Systems (TC) within the Drug Enforcement Administration (DEA). The DEA's SQL Server-based EDW is used by a majority of DEA's applications and is a critical component of statistical reporting. An active secret clearance is required., Essential Duties and Responsibilities: (Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position)

• To assist the EDW Team and provide data warehouse information and facilitate the transition to a cloud environment.
• Create and maintain database integrity and performance using scripts and/or Visual Studio Database Projects;
• Create new and maintain/improve any and all data transformation services: Microsoft SSIS and others using VS data tools;
• Create SQL Scripts to deploy / enhance / maintain databases;
• Create and maintain database security, including, but not limited to: Data Base Roles, Users and Logins;
• May write reports or facilitate data access by other means as needed, to include SSRS, PowerBI, etc.
• Conducts performance tuning and database design, dimensional analysis and modeling.
• Maintain and add to an extensive set of SQL Server Integration Service (SSIS) packages for Extract, Transform, and Load (ETL) of data.
• Support the ongoing effort to establish a Data Engineering environment supported by Python and other languages to perform ETL and ELT (Extract, Load, and Transform) operations.
• Supports the review of database systems from non-Concorde applications in other DEA offices for ingestion into the EDW
• Participates in daily Agile stand-up meetings and monthly planning sessions, sprint reviews, and retrospective sessions.
• Other duties as assigned., * Contribute to growth of DEA Contract via identifying new opportunities based upon customer Pain Points (assist DEA PM with potentially bringing in additional FTEs)
• Create a stronger relationship with the DEA customer via providing high quality service and solving customer needs.
• Assist BD Department by reviewing/writing future Bids based upon your experience and expertise at least quarterly and/or when necessary

• Clearance needed? Secret clearance is Required for DEA suitability. DEA Suitability will take anywhere from 2-6 weeks to complete.

• Certifications Needed? CompTIA Security +

• Educational Requirements? Bachelor's Degree Top 3 Skill Sets:

• 8+ years of experience in the design, development and implementation of SQL Server databases creating and maintaining T-SQL Procedures, functions, and triggers.

• 5+ years of experience with SSIS packages for data manipulation and loading in an enterprise data warehouse environment.

• 5+ years of experience with the SQL Server 2016, 2019, & 2022 environment, * Knowledge of, and experience within, an Agile development environment.

• Knowledge of, and prior experience with Git and PowerShell

• Knowledge of, and ability to use, Azure DevOps Server.

• Ability to write efficient SQL queries as well as demonstrated ability to interpret preexisting scripts.

• Knowledge of, and prior experience with multi-dimensional data models.

• Demonstrated prior experience with SSIS.

• Demonstrated ability and desire to learn new technologies.

• Ability to reverse engineer existing logic of all kinds (queries, stored procedures, functions, Python, and C#)

• Ability to write test plans and cases

• Experience with data modeling.

• Quality Assurance Experience is a plus.

• Previous experience with Business Intelligence, Kimball Modeling / Kimball data warehouse methodology and/or elastic search is desired. Other Requirements: U.S. Citizenship Secret Clearance REQUIRED Must be able to pass a DEA Security Approval.

Our client asked us to help them find a SR SQL Developer to support the DEA onsite in Fairfax, VA. Requires an active secret clearance in order to get the DEA clearance, and a current security+ certification. Looking for strong experience with SQL Server 2016, 2019, and 2022 as well as T-SQL and SSIS experience for data manipulation and loading. This is a direct hire and will pay $150k-$160k or so. If this is a good fit and if you are interested, pls respond with your current resume in word format if possible and give me a call. If not, pls feel free to pass this on to anyone you know that may be interested. Thank you. This is supporting DEA Vortex contract. The Vortex contract refers to a data management support services agreement between the Drug Enforcement Administration (DEA). This contract aims to enhance the DEA's data management capabilities, supporting its mission to enforce controlled substances laws and regulations. The contract provides comprehensive data management services, including data analysis, integration, and reporting, to help the DEA effectively manage and utilize its data resources. This contract underscores the DEA's commitment to leveraging data-driven strategies in its operations, ensuring efficient and effective enforcement of drug-related laws.