Ab Initio Architect & Subject Matter Expert (SME)

Credence

Illinois

On-site

USD 130,000 - 140,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Health Care Plan (Medical, Dental &amp

Retirement Plan (401k, IRA)

Life Insurance (Basic, Voluntary &

Paid Time Off (Vacation, Sick &)

Family Leave (Maternity, Paternity)

Short Term & Long Term Disability

Training & Development

Wellness Resources

Job summary

Credence is seeking an Ab Initio Architect and SME to support the modernization of an Army system using the Ab Initio platform. The role is based in Credence’s Tyson’s Corner, McLean, VA or Dayton, OH offices with onboarding planned for September 2026.

The ideal candidate has 10+ years in data integration, deep Ab Initio expertise, and a track record delivering federal-scale projects. You will design ETL workflows, optimize performance, and ensure compliance with DoD standards.

Qualifications

10+ years in enterprise data integration with Ab Initio and related tools.
7+ years in data integration architecture and ETL development, 5+ years with Ab Initio.
Proven track record leading modernization efforts for federal systems or large data platforms.
Strong knowledge of system architecture, data modeling, ETL, and integration strategies.
Experience in designing data workflows, pipelines, and transformation logic.
Experience with Ab Initio, Unix Shell Scripting, Oracle SQL, and Control-M.
Security clearance eligibility; DoD security standards (FISMA/NIST) familiarity.

Responsibilities

Develop and document high-level data process designs for migration to Ab Initio.
Lead end-to-end ETL workflows and optimize data flow and performance.
Gather requirements with analysts and stakeholders; draft System/Functional Requirements.
Analyze legacy workflows and propose performance improvements within Ab Initio.
Design and implement ETL processes; document and test code; prepare handover artifacts.
Participate in peer reviews; ensure adherence to coding standards and SDLC.
Design automated job schedules; enhance ETL automation and scheduling.
Ensure security/compliance with DoD requirements (FISMA/NIST).
Provide on-call support and monitor data integration jobs for stability.

Skills

Ab Initio

ETL design

Oracle SQL

Unix Shell

Control-M

Data integration

Cloud integration

Security/compliance

Education

Bachelor's degree

Tools

Ab Initio

Oracle SQL

Control-M

AWS

Azure

GDE

Job description

Overview

Join a team where innovation meets mission. Our AI, cloud, cyber, and modernization solutions save agencies thousands of hours, safeguard national security, and strengthen health and humanitarian missions worldwide. With more than 1,700+ team members, 1,500+ AI & data experts, and 100+ prime contracts, we deliver at scale and with purpose.

We’ve been recognized as a Top Workplace by The Washington Post for six consecutive years and named to the Inc. 5000 list of Fastest-Growing Private Companies in 13 of the past 14 years. Credence is a welcoming environment for those looking to grow and make a meaningful impact. We encourage employees to push boundaries and help solve critical, world-changing federal challenges.

Position Summary

Credence has an upcoming need for a Ab Initio Architect and Subject Matter Expert (SME) to join our team supporting the modernization of an existing Army system to the Ab Initio platform. This position will work closely with cross-functional teams to provide strategic direction, technical expertise, and ensure the solution meets the specific needs of the government. This position is based in Credence’s corporate offices located in Tyson’s Corner in McLean, VA or Dayton OH. This role is slated to begin onboarding in September 2026.

Responsibilities include, but are not limited to the duties listed below:

Develop and document high-level conceptual data process designs for the migration and modernization of legacy systems to the Ab Initio platform. Write efficient, maintainable, and scalable ETL code for data extraction, transformation, and loading processes.
Lead the design and implementation of end-to-end ETL workflows within the Ab Initio platform to optimize data flow, system integration, and performance. Work closely with project teams to ensure seamless migration of data from legacy systems to modernized environments
Work with business analysts, technical teams, and stakeholders to gather and analyze system and data requirements. Develop System Requirement and Functional Requirement Documents to guide the design and implementation of Ab Initio-based data solutions.
Analyze existing legacy data workflows and propose improvements for performance, scalability, and efficiency within the Ab Initio environment. Address any performance bottlenecks and optimize processing times
Lead the extraction, transformation, and load (ETL) process design, ensuring the accurate transfer of data from legacy systems into a modernized environments. Utilize Oracle SQL, Ab Initio, and other technologies to facilitate data conversion and integration
Create and document design specifications for ETL processes to ensure code auditability and maintainability. Perform functional and unit testing of ETL code to identify and resolve errors. Document testing results prior to code handover to testing teams
Participate in technical peer reviews to ensure adherence to coding standards, design principles, and performance best practices. Ensure compliance with Enterprise Informatics software development life cycle and ETL code standards
Design and implementation automated job schedules to ensure timely execution of ETL jobs. Work to improve ETL process automation and enhance the efficiency of job scheduling
Ensure that all designs and solutions meet the necessary security and compliance standards required in a DoD environment, including FISMA, NIST, and other applicable regulations
Provide on-call support on a rotational basis to troubleshoot and resolve issues in the ETL processes. Proactively monitor and maintain data integration jobs to ensure system stability and optimal performance.

Please join us, as together we build a better world one mission at a time powered by Technology and its People!

Bachelor’s degree is required
10+ years of experience in enterprise data integration, specifically with Ab Initio and related tools.
Minimum of 7 years of experience in data integration, architecture, and ETL development, with at least 5 years focused on Ab Initio.
Proven track record of leading and executing similar modernization efforts for Federal government systems or large-scale enterprise data platforms.
Strong understanding of system architecture, data modeling, ETL processes, and integration strategies.
Experience in designing and implementing complex data workflows, data pipelines, and transformation logic.
Proven expertise in designing, developing, and implementing complex ETL solutions using Ab Initio, Unix Shell Scripting, Oracle SQL, and Control-M.
Strong ability to troubleshoot, optimize, and maintain Ab Initio-based solutions.
Excellent problem-solving skills, with the ability to think strategically and solve complex technical challenges.
Up-to-date with the latest trends in data integration, governance, and Ab Initio technologies.
Strong communication skills with experience in interacting with senior stakeholders, technical teams, and clients.
Experience with cloud-based Ab Initio platforms and integration with AWS, Azure or similar environments.
Extensive experience across the Ab Initio suite, particularly with GDE, Co>Operating System, and EME for development and metadata management
Familiarity with orchestration components like Conduct> are highly preferred
Familiarity with Agile methodologies and working in an Agile development environment.
Knowledge of Federal government regulations and compliance standards related to data systems and security.
Certifications in Ab Initio are highly desirable
Must be eligible for security clearance; an active Secret clearance is preferred

Salary Range

$130,00 to $140,000 annually. Actual compensation will be determined based on the selected candidate's experience, education, skills, and overall qualifications.

Please join us, as together we build a better world one mission at a time powered by Technology and its People!