What are the responsibilities and job description for the Data Architect / Engineer with Security Clearance position at Spalding Consulting, Inc., a Saalex company?
Description Spalding Consulting, Inc. is seeking a Data Architect / Engineer in Patuxent River, MD. Spalding Consulting, Inc. is a professional services company delivering cutting-edge solutions to the Department of Defense since 2001. Our expert-level solutions include software development, information technology, program management, financial management and business intelligence services. Spalding Consulting offers competitive compensation, career development, flexible work schedules and excellent benefits. Position Type : Full-Time Salary Range : $110k- $155k (depending on experience) Work Location : Hybrid remote / in-office (see on-site requirements below).
- On-site Requirements : On-boarding will require 1-2 visits to Patuxent River, MD. Additionally, this position requires on-site work at Patuxent River, MD 1 - 2 days per week. Future on-site / telework requirements / schedules may change as additional client direction is received. Essential Functions :
- Provide data architecture, database development, and DDL support to senior techs, functionals, and other developers in support of a large data warehouse.
- Provide technical advisement and expertise in DDL processes and procedures.
- Write and edit SQL scripts for creation, population, truncation, migration, or manipulation of data tables, views, and materialized views within schemas.
- Troubleshoot data warehouse errors and technical issues.
- Perform data collection, data analysis, testing, and troubleshooting on large quantities of data.
- Analyze data from source systems; designing and developing extraction programs / scripts; loading source data into target systems or data warehouse within various environments.
- Assist configuration management team with data, information, files, and document management.
- Apply roles to database tables, create database accounts.
- Develop data architectures.
- Develop Informatica Mappings.
- Create Application Programming Interfaces (APIs) to connect data sources. Requirements Required :
- Experience with data architecture / engineering, data analysis, database design / development and / or conducting data extraction and loading required.
- Proficiency with MS Excel, SQL, and Visual Basic required.
- Experience with AWS cloud native services / technologies for data architecture and engineering required.
- BS / BA degree and 3 years related experience OR AA / AS degree and 7 years related experience OR HS and 9 years related experience. Desired :
- Experience with Business Objects, Informatica, TOAD, and JavaScript preferred.
- Experience providing support to NAVAIR IT applications / projects desired.
- Experience with JSON and APIs preferred.
- Experience with data / database migration from on-prem to cloud (AWS) desired.
- Security certification preferred. Education / Experience : BS / BA degree and 3 years related experience OR AA / AS degree and 7 years related experience OR HS and 9 years related experience. Security Clearance : Must be eligible to obtain a Secret clearance. Active Secret clearance desired, interim Secret acceptable to start. Requirements to obtain a clearance include US Citizenship, security investigation, etc. Benefits
- Health Care Plan (Medical, Dental & Vision)
- Retirement Plan (401k, IRA)
- Life Insurance (Basic, Voluntary & AD&D)
- Paid Time Off (Vacation, Sick & Public Holidays)
- Short Term & Long Term Disability
- Training & Development
- Wellness Resources
Salary : $110,000 - $155,000
