US
0 suggestions are available, use up and down arrow to navigate them
What job do you want?

Senior SQL Developer with Security Clearance job in Merrifield at DT Professional Services

Create Job Alert.

Get similar jobs sent to your email

List of Jobs

Apply to this job.
Think you're the perfect candidate?
Senior SQL Developer with Security Clearance at DT Professional Services

Senior SQL Developer with Security Clearance

DT Professional Services Merrifield, VA Full-Time
Job Summary: Seeking a Senior SQL Developer to provide Enterprise Data Warehouse (EDW) 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. Responsibilities: Develop SQL Script and create SSIS packages for ETL work.
Be able to write SSRS reports or facilitate data access by other means as needed.
Conducts performance tuning and database design, dimensional analysis, and modeling.
Maintains and adds to an extensive set of SQL Server Integration Service (SSIS) packages for Extract, Transform, and Load (ETL) data manipulation.
Maintain, enhance, and create enterprise and application level reports using SQL Server Report Service (SSRS) and other Business Intelligence (BI) tools. If requested, the EDW team will leverage SQL Server Analysis Services (SSAS) for performance purposes.
Supports the review of database systems from non-Concorde applications in other DEA offices.
Participates in daily Agile stand-up meetings and monthly planning sessions, sprint reviews, and retrospective sessions.
Requirements: Must be able to work onsite in Merrifield, VA.
Bachelor’s degree in IT, Computer Engineering, or a related discipline.
Minimum of 8 years of experience in the design, development, and implementation of SQL Server databases creating and maintaining T-SQL Procedures, functions, packages, and triggers.
Minimum of 2 years of experience with SSIS packages for data manipulation and loading.
Minimum of 2 years of experience with the SQL Server 2012 environment.
Previous experience with Business Intelligence, Kimball Modeling and/or elastic search is desired.
Ability to obtain and maintain a DoD government secret (or higher) clearance Qualifications: Agile development environment.
MS Team Foundation Server or Azure DevOps Server.
Highly skilled at SQL Script development.
Ability to create reports via SSRS; solid understanding of a variety of BI tools.
Experience with SSIS.
Knowledge of Kimball methodology desired.

Recommended Skills

  • Administration
  • Agile Methodology
  • Business Intelligence
  • Computer Engineering
  • Data Processing
  • Data Warehousing
Apply to this job.
Think you're the perfect candidate?

Help us improve CareerBuilder by providing feedback about this job:

Job ID: 6820329

CareerBuilder TIP

For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.