freehire launches on Product Hunt on 26 August.

Follow →

Ab Initio Architect & Subject Matter Expert (SME)

Summary

Design and implement ETL workflows in Ab Initio to modernize a legacy Army system, optimizing data flow and ensuring compliance with federal security standards.

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 implement 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!

Requirements

    • 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!

Benefits

  • Health Care Plan (Medical, Dental & Vision)
  • Retirement Plan (401k, IRA)
  • Life Insurance (Basic, Voluntary & AD&D)
  • Paid Time Off (Vacation, Sick & Public Holidays)
  • Family Leave (Maternity, Paternity)
  • Short Term & Long Term Disability
  • Training & Development
  • Wellness Resources

What this application asks

workable

First name, Last name, Email, Headline, Please list your full legal first and last name (e.g., John L. Smith II), Please provide your preferred first name, Phone, By providing a phone number and submitting this form you consent to receive SMS text messages from Credence LLC in accordance with our SMS Privacy Policy (https://credence-llc.com/careers/sms-privacy/) Message and data rates may apply. Message frequency may vary. Reply No, to STOP and opt out., Address, Photo, Education, Experience, List any work related certifications or licenses you currently possess, Please comment on how your prior education and experiences qualify you for the type of employment you are seeking., Summary, Resume, Please indicate which active clearances you have, If you have a security clearance not listed, please fill in., Cover letter, Type of work desired, What is your annual salary expectation? (Ranges are welcomed- non-answers may delay your consideration), What date are you available to join Credence as a new hire?, Are you legally authorized to work in the U.S. as a U.S. citizen or Fully Naturalized U.S. Citizen?
, Do you currently or will you in the future, require an immigration sponsorship and/or a host for a work visa authorization (e.g., F1 or H-1B)?  (if hired, verification will be required consistent with federal law.)
, Are you at least 18 years old?  (if no, you may be required to provide authorization to work)
, How did you hear about us? Was it a job board or an employee? Do tell...., Have you ever worked for Credence before?
If yes, what year and in what role?, Credence honors our Service Members and wonder if you are a Veteran or have Veteran status?, Credence honors our Service Members and their spouses, have you ever been a Military Spouse?, Do you have any relatives employed by this organization?, I have disclosed all information that is relevant and should be considered applicable to my candidacy for employment. 

I understand, where permissible under applicable state and local law, I may be subject to a pre-employment drug test after receiving a conditional offer of employment, and must receive a negative result for illegal drug use before being permitted to commence work with Company. I understand, where permissible under applicable state and local law, I may be subject to a pre-employment medical examination after receiving a conditional offer of employment, and must meet the qualifications for the position, with or without reasonable accommodation, before being permitted to commence work with Company. I understand, where permissible under applicable state and local law, I may be subject to a pre-employment background check after receiving a conditional offer of employment to investigate my criminal background and other matters related to my suitability for employment. Initial to agree., I hereby certify that the information given by me is true in all respects. I authorize Company and its representatives to contact my prior employers and all others (with the exception of my current employer, only if I have marked "May we contact your present employer" on this application as "No") for the purpose of verification of the information I have supplied and release same from any liability resulting from the information released. I authorize employers, schools and other persons named on this application to provide any information or transcripts requested. Initials to agree, I understand employment with Company is also contingent on my providing sufficient documentation necessary to establish my identity and eligibility to work in the United States. 

If employed, I understand that as a condition of employment that I may be required to agree to and sign a non-solicitation, non-disclosure, and/or other similar agreements. I also agree to notify the organization during the pre-employment process of any non-solicitation, non-disclosure, and/or other similar agreements that I may have already signed with current and former employers. 

I expressly understand and agree that, if employed, my employment, having no specified term, is based upon mutual consent and may be terminated at-will, with or without cause, by either party (Company or me) without prior notice to the other, unless otherwise prohibited by law. 

I understand that no representation, whether oral or written, by any representative or agent of Company, at any time, can constitute an implied or express contract of employment. I further understand no representative or agent of Company has the authority to enter into an agreement for employment for any specified period of time or to make any change in any policy, procedure, benefit or other terms or condition of employment other than in a document signed by an authorized representative. 

I understand that the technical processing and transmission of the application, including my personal information, may involve (a) transmissions over various networks, including the transfer of this information to the United States and/or other countries for storage, processing and use by Company, its affiliates, and their agents; and (b) changes to conform and adapt to technical requirements of connecting networks and devices. Accordingly, I agree to permit such parties to make such transmissions and changes, and hereby provide the necessary consent for the same. Initial to agree., Do you currently meet the worksite location requirements for being On-site or Hybrid as defined in the job description?, If “No”, are you willing to relocate to meet this requirement? Please note that candidates who are unable to work onsite or relocate will not meet the position requirements.

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

See also

Tailor your CV for this role?

We couldn't check your fit for this role — add a CV to your profile to see it next time.

A new version of freehire is available