Defense The Defense group supports the Department of Defense (DoD) mission to keep our homeland and its citizens safe. We provide solutions to improve the Nation's defense by providing software, systems engineering, IT, training and logistics and fleet management solutions.
Responsibilities
The Data Warehouse Analyst / Programmer is responsible for designing and development of Extract-Transform-Load (ETL) processes for data warehouses, gathering requirements, and designing data bases. Defines and oversees database organizations, standards, controls, procedures, and documentation. Responsible for data design, database architecture, metadata and repository creation. Provides technical consulting in the definition, design, and creation of a database environment. Advises applications development staff and users on data-based solutions to business problems, data architectures, data base management system facilities and capabilities, and the operation and tuning of databases. Provides technical expertise to create new data warehouses and performs testing and dimensional modeling to ensure database solutions are functioning properly and accurately. Advises on applications development, data architectures, data base management system facilities and capabilities, and the operation and tuning of data bases. Reviews and ensures that data loaded into the data warehouse is accurate. Performs data warehouse design and construction. Designs and implements databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods. Uses data mapping, data mining and data transformational analysis tools to design and develop databases. Determines data storage and optimum storage requirements. Prepares system requirements, source analysis and process analyses and design throughout the database implementation.
Specific Responsibilities include:
Design, build, and support the components of data warehouse, such as ETL processes, databases, reports, and reporting environments
Plans technical transitions between development, testing, and production phases of the workplace.
Performs data warehouse design and construction.
Codes and documents scripts and stored procedures.
Designs dimensional models with conformed dimensions, following the business' processes.
Creates processes for maintaining or/and capturing metadata.
Identifies and documents all requirements for both fresh and current data warehouse components and reports by working with end users.
Develops programs and systems documentation and assists clients with data warehouse requirement
Provide database warehouse support to Information Operations for briefings, work groups, & events.
Qualifications
Required Qualifications: (Tasks from PWS 5.4.7.3 area)
Bachelor's Degree in a Computer Science or other related field.
At least Eight years' experience in conducting analysis and open source research supporting DoD or IC customer, Plus;
Demonstrated experience SAP Business Objects, Microsoft SQL Server, and SQL Server Integration Service (SSIS), Microsoft Azure and Amazon AWS computing platforms
Demonstrated experience developing codes, testing for quality assurance, administering RDBMS, and monitoring of database
Strong knowledge of the fundamentals of data warehouse, and experience supporting and developing data warehouses.
Possess excellent skill in communicating in writing and speaking with senior managers and team members
Desired Qualifications:
Demonstrated leadership supporting open source research and strong proficiency in IO Planning
Eight years' experience in conducting analysis and open source research supporting DoD or IC customer with at least a portion of the experience within the last two years.
Ten or more year's active duty military, civilian or contractor performance working in Information Operations.
About Perspecta
What matters to our nation, is what matters to us. At Perspecta, everything we do, from conducting innovative research to cultivating strong relationships, supports one imperative: ensuring that your work succeeds. Our company was formed to bring a broad array of capabilities to all parts of the public sector-from investigative services and IT strategy to systems work and next-generation engineering.
Our promise is simple: never stop solving our nation's most complex challenges. And with a workforce of approximately 14,000, more than 48 percent of which is cleared, we have been trusted to do just that, as a partner of choice across the entire sector.
Perspecta is anAA/EEOEmployer - All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
As a government contractor, Perspecta abides by the following provision
Pay Transparency Nondiscrimination Provision
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of the other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c).
