Data Warehouse Architect

US IT Solutions Inc

Apply to this job
Richmond, VA, us on site Until 8/23/2026 First posted March 27, 2025 Last posted March 27, 2025
Job description

We are from US IT Solutions, an ISO Certified, E-Verify, WMBE Certified organization established in 2005 in CA. Our company is serving various State, Local and County Departments for over 10 years. USITSOL has been helping clients innovate across all phases of the application lifecycle for over a decade. Some of our prestigious clients are State of CA, State of OR, State of FL, State of NC, State of GA, State of CO, State of VA, State of AR, State of MI, State of OH, State of IL, State of MO, State of MS, California State University, Sacramento Area Sanitation Department, SMUD, Sound Transit, LA Superior Courts, District of Columbia, UMAS, University of Central Florida and Hennepin County and many more.

  • PL/SQL and SQL developer with Oracle expereince 5
  • Understanding of Start Schema ata warehouses and data warehouse design 5
  • ETL script development and execution, including automation in a Linux / Oracle environment 5
  • Performance tuning and reconciliation of SQL quey execution 5
  • Familiar with Unix Shell Scripting 5
  • Experience developing report specifications from business requirements and executing the build to design 5
  • Experience with a mature data modelling tool such as ERWIN (preferred) 5
  • Experience with Oracle 12 enviornments 3

All your information will be kept confidential according to EEO guidelines.

About this role

Summary

Designs, develops, and optimizes data warehouses and ETL processes using SQL, Oracle, and scripting.

Job title

Data Warehouse Architect

Experience level

5+ years

Industry

it services

Location requirements

Richmond, VA, US, on-site work only

Salary

Not specified

Management role

No

Skills & keywords

Required skills

pl/sqloraclestart schemaetlunix shell scripting

Preferred skills

erwinoracle 12

Specializations

sqloracleetldata warehousingunix shell scripting
Locations

Structured locations inferred from the posting.

Richmond, VA, USA

On-site City