Data Architect/Engineer

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: $80k-$135k -depending upon experience.

Work Location: Hybrid remote/in-office (see onsite requirements below).

 

On-Site Requirements: On-boarding will require 1-2 visits to Patuxent River, MD. Position requires onsite work 1 day per week at Patuxent River, MD. 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.


• Other duties as assigned or required.

Qualifications and Experience:





Required:

• Experience with data architecture/engineering, data analysis, database design/development and 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.

Desired:

• Experience with AWS ETL tasking/tools preferred.


• Experience with Business Objects, Informatica, TOAD, and JavaScript preferred.


• Experience providing support to NAVAIR IT applications/projects desired.


• Experience with JSON and APIs desired.


• Experience with data / database migration from on-prem to cloud (AWS) desired.


• CompTIA Security+ certification preferred.

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.

Education:

BS/BA degree and 3 years related experience OR AA/AS degree and 7 years related experience OR HS and 9 years related experience.

Spalding Consulting, Inc. is committed to providing equal employment opportunities to all applicants and employees. We will not discriminate against any employee or applicant on the basis of race, color, ethnic origin, national origin, creed, religion, political belief, sex (including pregnancy), sexual orientation, gender identity, marital status, age, military status, physical or mental disability, or any other legally protected basis, in accordance with applicable federal, state or local laws. Spalding Consulting, Inc. is an Affirmative Action/Equal Opportunity Employer and encourages minorities, women, disabled, and veterans to apply for job openings within our company.