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.
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.
- 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
