Share Email Opening Apply Now
Title

Senior SQL Developer 

About the Organization VSolvit (pronounced: "We.Solve.it") is an award-winning SBA certified 8(a)/Small Disadvantaged Business and 8(m)/Economically Disadvantaged Woman owned, technology services provider that specializes in business intelligence (BI) systems, data warehousing, geographic information systems (GIS), custom application development, health analytics, project/program management, and hosting and cloud services. VSolvit serves clients such as the Department of Defense (DOD), the U.S. Department of Agriculture (USDA), the Department of Housing and Urban Development (HUD), and the Bill & Melinda Gates Foundation. Our custom technology solutions for federal and health industry clients and partners have won awards for innovation, been launched from the U.S. White House, and are being used to solve complex problems ranging from improving national security to optimizing vaccine supply chains and breast cancer screening and treatment programs.





These successes are but a reflection of overall team strength and supportive partnerships. Our company fosters innovation which makes it a great place for entrepreneurs and hard workers to be grown. We offer Medical, Dental, and Vision Insurance, as well as 401K Retirement Plan options, Profit Sharing, Tuition Reimbursement, and other benefits for our full time employees. Our goal is to grow together and enjoy the work that we do as a team.





 
Description

VSolvit is 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.  An active secret clearance is required.

 

Responsibilities:

  • Responsible for SQL Script development and creation of SSIS packages for ETL work.
  • May 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.
  • Will use MS Team Foundation Server or Azure DevOps Server
  • Work within an Agile development environment
 
Position Requirements

Basic Qualifications: 

  • Bachelor’s degree in IT, Computer Engineering, or a related discipline.
  • 8+ years of experience in the design, development, and implementation of SQL Server databases creating and maintaining T-SQL Procedures, functions, packages, and triggers.
  • 8+ years of experience in SQL Script development.
  • 2+ years of experience with SSIS packages for data manipulation and loading.
  • 2+ years of experience with the SQL Server 2012 environment.
  • 2+ years of experience in creating reports via SSRS; solid understanding of a variety of BI tools.
  • 2+ years of experience with SSIS
  • Active Secret Clearance is required.
  • Must be a U.S. Citizen

 

Preferred Qualifications:

  • Previous experience with Business Intelligence, Kimball Modeling and/or elastic search
  • Knowledge of Kimball methodology 

 

 

Company Summary:

Join the VSolvit Team! Founded in 2006, VSolvit (pronounced 'We Solve It') provides geospatial and information technology consulting services and solutions to government and private sector clients. VSolvit is an award winning 8(m)/EDWOSB company. We offer Medical, Dental, and Vision Insurance, as well as 401K Retirement Plan options, Educational Reimbursement, and other benefits. Our goal is to grow together and enjoy the work that we do as a team.

 

VSolvit LLC is an Equal Opportunity/Affirmative Action employer and will consider all qualified applicants for employment without regard to race, color, religion, sex, national origin, protected veteran status, or disability status.

 

 
EOE Statement We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status or any other characteristic protected by law.  
Category Software/Application Development  
Location Merrifield  
Full-Time/Part-Time Full-Time  
Exempt/Non-Exempt Exempt  
Clearances Required Secret clearance  
Travel  
Req Number SOF-21-00050  
Position SQL Server Database Developer  
Number of Openings 1  
Proposal Position  
Proposal Letter Of Intent (LOI)  
Open Date 7/23/2021  
Tags SSRS, SSIS, MS SQL Server, Database, T-SQL, BI tools, procedures, functions, packages and triggers, Secret clearance  

This position is currently accepting applications.

Apply Now



WE ALSO RECOMMEND

Other Jobs Within Same Category
Data Warehouse Analyst in Washington DC, District of Columbia
Posted on: 9/14/2021
[Apply Now]

Software Configuration Management (CM) Specialist in Point Mugu, CA
Posted on: 9/10/2021
[Apply Now]

Junior C# Developer in Chesapeake, VA
Posted on: 9/9/2021
[Apply Now]

Jr. Database Developer in Norco, CA
Posted on: 8/20/2021
[Apply Now]

Database Developer (Oracle DB) in Remote, Any
Posted on: 8/9/2021
[Apply Now]


Other Jobs Within 60 Miles
Administrative Assistant II in Washington DC, District of Columbia
Posted on: 8/29/2021
[Apply Now]

Senior Data Scientist in Merrifield, VA
Posted on: 7/30/2021
[Apply Now]

Front-End UX/UI Software Developer (DEA) in Merrifield, VA
Posted on: 6/28/2021
[Apply Now]

Data Warehouse Analyst in Washington DC, District of Columbia
Posted on: 9/14/2021
[Apply Now]



Follow us See who works here:
 


AppOne.comTM 1999-2021 HR Services, Inc.
Click here for technical assistance.