Software Developer Advisor

Clearance Level
Software Development
Falls Church, Virginia

REQ#: RQ102441

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

General Dynamics Information Technology, Inc. has an opening for the position of Software Developer Advisor (Ref# SDA1019MS).

Work Location:  Position may telecommute from anywhere in the U.S.

Job Duties:  Research, design, develop, and/or modify enterprise-wide systems and/or applications software.  Design, develop, and unit test SQL Server ETL processes and thoroughly evaluate the system to analyze upstream and downstream effects.  Gather and analyze functional requirement documents from the business and understand the key business questions.  Translate the functional requirements into technical specifications.  Build and maintain the naming standards and data dictionaries with respect to the data model and database and document the data model.  Develop, operate, and maintain a transactional processing system.  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, PLEXIS Quantum Choice, MicroStrategy, XML, Visual Studio, Tortoise SVN, MS Visio, MS Office, and Windows.

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

This position requires being fully vaccinated against COVID-19 by January 18, 2022 or the start date, if after January 18. Individuals who work in or reside in Texas or Montana or work outside of the United States may be excluded from this requirement.

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.