1 day old

Database Warehouse Analyst / Programmer

Fort Belvoir, VA 22060
Apply Now
Apply on the Company Site
  • Jobs Rated
    61st
Business Group Highlights

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)

  • Bachelors 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;
    1. Demonstrated experience creating metadata, developing ETL processes
    2. 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
  1. Strong knowledge of the fundamentals of data warehouse, and experience supporting and developing data warehouses.
  2. 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 years 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 sectorfrom investigative services and IT strategy to systems work and next-generation engineering.

Our promise is simple: never stop solving our nations 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 - Minorities/Women/Veterans/Disabled and other protected categories.

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 contractors legal duty to furnish information. 41 CFR 60-1.35(c).

Industry

  • Information Technology

Jobs Rated Reports for Computer Programmer

Posted: 2020-09-20 Expires: 2020-10-20

With offerings in mission services, digital transformation and enterprise operations, our team of 14,000 engineers, analysts, investigators and architects work tirelessly to create innovative solutions. We have the expertise and experience not only to devise solutions, but to execute on them successfully.

Featured Job

Featured Employer

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Database Warehouse Analyst / Programmer

Perspecta
Fort Belvoir, VA 22060

Join us to start saving your Favorite Jobs!

Sign In Create Account
Computer Programmer
61st2018 - Computer Programmer
Overall Rating: 61/220
Median Salary: $82,240

Work Environment
Good
50/220
Stress
Very Low
17/220
Growth
Very Poor
211/220
Powered ByCareerCast