Ab Initio Architect & SME — DoD Data Modernization Lead

Credence Management Solutions, LLC; Dayton (OH); On-site; USD 130,000 - 140,000; Full time

Benefits offered by this job

Health Care Plan (Medical, Dental &amp

Job summary

Credence Management Solutions, LLC seeks an Ab Initio Architect and SME to modernize Army data systems using Ab Initio. The role supports cross-functional teams, defines data process designs, and ensures DoD compliance.

Requirements include a Bachelor's degree, 10+ years in data integration with Ab Initio, and strong ETL expertise. On-site with onboarding planned for Sept 2026 in either VA or OH.

Qualifications

• Bachelor's degree is required.
• 10+ years of enterprise data integration, especially Ab Initio.
• 7+ years in data integration/ETL architecture; 5+ years with Ab Initio.
• Proven modernization experience on Federal government systems.
• Strong understanding of data pipelines, ETL processes, and governance.
• Experience with cloud-based Ab Initio platforms and AWS/Azure.
• Must be eligible for security clearance; Secret preferred.

Responsibilities

• Create high-level data process designs for migration to Ab Initio.
• Lead end-to-end ETL workflows to optimize data flow and integration.
• Gather requirements and develop System/Functional Requirement Documents for Ab Initio solutions.
• Analyze legacy workflows and optimize performance and scalability.
• Lead ETL design using Ab Initio, Oracle SQL, and related tools.
• Document design specs and perform functional/unit testing of ETL code.
• Participate in peer reviews; ensure SDLC and ETL standards compliance.
• Design automated job schedules to ensure timely ETL execution.
• Ensure DoD security/compliance standards (FISMA, NIST).
• Provide on-call support to troubleshoot ETL issues.

Skills

Communication

Agile

Security clearance

Education

Bachelor's degree

Ab Initio certifications desirable

Tools

Ab Initio

Unix Shell Scripting

Oracle SQL

Control-M

GDE

Co>Operating System

EME

Job description

Credence Management Solutions, LLC seeks an Ab Initio Architect and SME to modernize Army data systems using Ab Initio. The role supports cross-functional teams, defines data process designs, and ensures DoD compliance.

Requirements include a Bachelor's degree, 10+ years in data integration with Ab Initio, and strong ETL expertise. On-site with onboarding planned for Sept 2026 in either VA or OH.