Ab Initio Architect & Subject Matter Expert (SME)

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