15 hours

Database Architect

Lansing, MI 48933
Apply Now
Apply on the Company Site
Business Group Highlights

Civilian, State and Local

Perspectas Civilian, State and Local segment partners with the U.S. Federal Civilian State and Local governments to provide infrastructure services, business solutions, and digital transformation services that help them achieve policy objectives and integrate citizen-centric services.


As a member of the data warehouse team (DTW) will work with the customer and other stakeholders to understand the current technical environment and support the customer in the development of a data warehouse. Will be responsible for performing and documenting technical tasks in support of this effort. Will perform ETL job development, data modeling, and data architecture -related tasks. Will use expertise and best practice knowledge in developing the approach and actual development to meet the technical requirements. Will work in conjunction with and under direction from the customer.

Will significantly contribute to a data warehouse environment that allows the customer to track high level information and associations on sites, facilities, and locations over time. As a data warehouse professional on the DTW team the scope of work for this position includes, but is not limited to, designing SQL database, building SQL Data Quality Services processes, loading data into the data warehouse and developing reports on the data. Work includes: (1) SQL database design, (2) building a load process for a spreadsheet template from a variety of data sources and formats to include from network drives in Microsoft Access or Excel formats, (3) design and build load functionality for data, such that any source data in the template will be able to be loaded, (4) ensuring data loaded into the master table meets established standards (e.g. Corporation = Corp, ) and has validate or complete data to load, (5) develop a matching algorithms in order to combine data from multiple systems, (6) create a process that scores the likelihood of a match based on factors such as name, address, city, and zip, (7) build a mechanism to manually fix data, (8) evaluate and update data that isnt merged or loaded in order to pass the matching process, (9) develop a mechanism to make data fixes and reprocess the data, (10) build other transformation and load jobs, (11) build sequence and scheduler routines, (12) create a query and reporting interface using Power BI and other tools, (13) create a change data mechanism or interface to update data as errors that are found in the customer data warehouse, (14) design and develop audit / history tracking to track changes to data and see history of changes at sites or interests.


Requires 5 to 8 years with BS/BA or 3 to 5 years with MS/MA or 0 to 2 years with PhD.

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


  • Information Technology
Posted: 2021-04-14 Expires: 2021-05-13

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.

  • Salary Questions

    Find out how your paycheck compares by industry, function, location, and more.

    Check Right Now

  • Tips for ABLE Grads

    From creating the perfect resume to nailing the interview, this article is a must-read before you start your Job Hunt.

    Get Started Now

  • Set Up Your Job Alerts

    Be alerted when a job is posted that fits your professional criteria.

    Set Up Your Alerts Right Now

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 Architect

Lansing, MI 48933

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast