Senior SQL Server Developer- Remote

Clearance Level
Other
Category
Software Development
Locations
Falls Church, Virginia
Remote, Based in Virginia

REQ#: RQ105987

Travel Required: None
Public Trust: Other
Requisition Type: Regular

General Dynamics Information Technology (GDIT) is seeking a Senior SQL Server/ SQL Server Data Tool (SSDT) Developer to join our team providing support to the World Trade Center Health Program (WTCHPS). GDIT, in conjunction with our partners, delivers technical and management support services for The Centers for Disease Control and Prevention (CDC) -  National Institute for Occupational Safety and Health (NIOSH) with the implementation of the WTC Act.

In this role, you will design, develop, and unit test SQL Server ETL processes using SSDT and thoroughly evaluate the system to analyze upstream and downstream effects.  You will be part of a team of other Technical team members. 

See more information about the impact you can make by being part of this program here - https://www.cdc.gov/wtc/programvideos.html

  • Design, build, and maintain data warehouse to house data extracted from multiple sources to support analytical analysis/financial reporting.
  •   Enhance the existing data model to facilitate the financial and clinical reporting needs of the end users. 
  • Reverse engineer existing source databases to understand the data architecture and perform detailed source data analysis. 
  • Develop and maintain SQL queries, stored procedures, triggers, and functions to support the ETL (Extract, Transform & Load) process. 
  • Design and maintain source to target mapping and implementation documents to support the ETL processes to refresh the target database or data mart with data from multiple sources. 
  • Create and maintain SSIS/SSDT packages to load data from various sources to data warehouse as well as generate output extracts to external entities.  Support ad hoc report requests from the business.
  •   Create and maintain database objects, enforce constraints, and create validation rules around data maintained in MS Access databases for custom functionality. 
  • Develop and maintain production notification process to efficiently track and report the automated job status to the business.
  •   Tune SQL generated by MicroStrategy for improved performance. 
  • Effectively utilize the tool to its maximum efficiency to read, cleanse, validate, transform, and move data from a variety of source data structures into target databases and vice versa. 
  • Interact and coordinate with business teams as part of requirements gathering and analysis and conduct design review meetings. 
  • Use of SQL Server, SQL Server Integration Services (SSIS), SQL Server Data Tools (SSDT), T-SQL, CA Erwin, Visual Studio, Tortoise SVN, MS Visio, MS Office, and Windows.

Requirements: 

  • Bachelor’s degree plus 8 years of progressive experience in lieu of the required education and experience or a Master’s degree or foreign academic equivalent in Computer Science, Electrical / Electronics Engineering, Information Technology, or a related field. 
  • 6 plus years of experience in a related occupation including Data Modeler, Programmer Analyst, or related experience. 
  • 3 years of experience with ETL, SQL Server, SSIS, T-SQL, CA Erwin.
  • Will accept any suitable combination of education, training, or experience as per the requirements cited herein. 

COVID-19 Vaccination Requirement: To protect the health and safety of its employees and to comply with customer requirements, GDIT may require employees in certain positions to be fully vaccinated against COVID-19. Vaccination requirements will depend on the status of the federal contractor mandate and customer site requirements.

We are GDIT. The people supporting some of the most complex government, defense, and intelligence projects across the country. We deliver. Bringing the expertise needed to understand and advance critical missions. We transform. Shifting the ways clients invest in, integrate, and innovate technology solutions. We ensure today is safe and tomorrow is smarter. We are there. On the ground, beside our clients, in the lab, and everywhere in between. Offering the technology transformations, strategy, and mission services needed to get the job done.

GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.