Sign Up Sign Up Log In Sign Up
This job has expired and you can't apply for it anymore. Start a new search.

DOJ BI Solutions Architect


Every day at Perspecta, we enable hundreds of thousands of people to take on our nation’s most important work.  We’re a company founded on a diverse set of capabilities and skills, bound together by a single promise: we never stop solving our nation’s most complex challenges.  Our team of engineers, analysts, developers, investigators, integrators and architects work tirelessly to create innovative solutions.  We continually push ourselves—to respond, to adapt, to

 go further.  To look ahead to the changing landscape and develop new and innovative ways to serve our customers.  Perspecta works with U.S. government customers in defense, intelligence, civilian, health care, and state and local markets. Our high-caliber employees are rewarded in many ways—not only through competitive salaries and benefits  packages, but the opportunity to create a meaningful impact in jobs and on projects that matter.    Perspecta’s talented and robust workforce—14,000 strong—stands ready to welcome you to the team. Let’s make an impact together. 

We at Perspecta are currently seeking a Business Intelligence Solutions Architect in Washington DC - Public Trust

The Business Intelligence Specialist will be responsible for:
  • Gather requirements from non-technical business stakeholders
  • Using Agile development methodologies to support project development
  • Analyze client Data Lakes for building Data Marts
  • Design and deploy data table structures, reports, and queries, and worked with the database and data loading development team on an as-needed basis to influence the structure of database tables and indexes to better support the reporting needs
  • Develop and maintain T-SQL based procedures that pre-process and pre-summarize data to organize data for faster, easier, and repeatable use within reports.
  • Design, build, implement SSRS reports to replace SAS system reporting
  • Design and implement database to migrate historical data from retired systems
  • Design and implement ETL to move System of Record (SOR), Oracle 12C, data to reporting system database
  • Design network account infrastructure to support BI Tools (ETLs, SSRS)
  • Perform upgrades, patch maintenance and integration with customer software

Education and Experience Required:
  • 15+ years of professional experience
  • Bachelors degree in computer science or related area of study
Knowledge and Skills Required:

Knowledge and experience in the following applications:

  • SQL Server 2016
  • SSMS 2017
  • SSDT 2015
  • Sharepoint
  • ERWin
  • Microsoft Visio
  • Oracle 12C
  • Entellitrak
EEO Tagline: Perspecta is an AA/EEO Employer - Minorities/Women/Veterans/Disabled and other protected categories
Company Name:
Security Clearance:
Washington, District of Columbia
United States
Not Specified
Job Number:

Send me email alerts for similar jobs