1+ months

Software Solutions Architect

Lansing, MI 48933
Apply Now
Apply on the Company Site
Peraton Overview

Peraton drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the worlds leading mission capability integrator and transformative enterprise IT provider, we deliver trusted and highly differentiated national security solutions and technologies that keep people safe and secure. Peraton serves as a valued partner to essential government agencies across the intelligence, space, cyber, defense, civilian, health, and state and local markets. Every day, our 22,000 employees do the cant be done, solving the most daunting challenges facing our customers.

We are an Equal Opportunity/Affirmative Action Employer. We consider applicants without regard to race, color, religion, age, national origin, ancestry, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, veteran status, disability, genetic information, citizenship status, or membership in any other group protected by federal, state, or local law.

As a government contractor, Peraton 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).


Bachelors Degree in Computer Science, Information Systems or other Information Technology major or equivalent work experience


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.


  • Information Technology
Posted: 2021-06-28 Expires: 2023-10-30

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.

Sponsored by:
ADP Logo

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:

Software Solutions Architect

Lansing, MI 48933

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast