This job listing has expired and the position may no longer be open for hire.

Senior SQL Developer (VA, Merrifield) at VSolvit, LLC

Posted in Other 30+ days ago.

Location: Merrifield, Virginia





Job Description:













































































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




More jobs in Merrifield, Virginia


ECS Corporate Services

ECS Corporate Services

ECS Corporate Services
More jobs in Other


Shaner Hotel

Shaner Hotel

Shaner Hotel