ZAC KNAUS

ENTERPRISE INTEGRATION | ETL / DATA ENGINEERING | ERP & BI | PRODUCTION AUTOMATION

PROFESSIONAL PROFILE

Technical leader with 20+ years across enterprise data engineering, federal program staffing and U.S. Air Force intelligence operations. As Amentum's Lead Developer for ETL and BI, owns integrations and production data delivery for a 2,500-user environment.

CURRENT ENTERPRISE IMPACT

  • Enterprise integration ownership. Serve as the sole data integration engineer for an approximately 2,500-user environment spanning Workday, Deltek Costpoint/T&E, the enterprise data warehouse and IBM Cognos Analytics.

  • Enterprise transition. Supported planning and phased testing for on-premises, hosted and cloud Costpoint migrations, plus Oracle Cloud and R12. On-premises moves crossed multiple Active Directory domains, including GCCH.

  • Workforce data pipeline. Built bidirectional employee demographics, leave and payroll ETLs; verified all 1,800 employee records in the first production load and established feedback loops with business teams to isolate and resolve data quality issues.

  • Data pipelines and Cognos administration. Built SOX-audited Python ETLs through CI/CD across up to 54 servers using Gitea, Jenkins, SFTP, SharePoint, SQL Server, SQLite, REST and SOAP APIs. Used Cognos to automate data deliveries and exception reporting; owned Cognos permissions, usage audits and SOX control preparation.

  • Procurement KPIs. Fed Global Supply Chain Management (GSCM) accounts payable, purchase order and vendor data through the enterprise data warehouse, enabling executive and VP-level purchasing and procurement officers to track current operational KPIs and trends.

  • Query performance. Researched performance constraints and added database maintenance and indexes; reduced a Revenue Operations query used more than 20 times per accounting period close from over two hours per run to under two minutes with identical results.

  • Remittance and period close. Used auditable Python scripts for weekly AP conversions and vendor remittance communications; reconciled period-close accounting data as it became system-formatted output, occasionally detecting material errors before external disclosure.

  • Costpoint upgrade. Coordinated network, database, certificate, Cognos validation and cutover work for the Costpoint 8.0-to-8.2 upgrade; migrated 2,500 daily active users from legacy servers to fully upgraded systems while preserving system access and user-facing URLs.

  • Migration scope and validation. Narrowed the Cognos migration inventory from roughly 8,000 reports to 113 repeatedly used reports; converted multiple functional business reports from PL/SQL to T-SQL, some with as many as 65 queries, to facilitate pre-migration validation.

CURRENT COMPANY | ROLE PROGRESSION

CONTINUOUS EMPLOYER LINEAGE | Sotera → KeyW → Jacobs → Amentum | Apr 2014–Present

  1. Lead Developer, ETL & Business Intelligence

    Jacobs → Amentum | Oct 2023–Present

  2. Software Developer / BI Analyst

    The KeyW Corporation → Jacobs | Apr 2019–Oct 2023

  3. Business Intelligence Analyst / Developer

    The KeyW Corporation | Jul 2017–Apr 2019

  4. Data Warehouse Architect / Analyst | Secondary

    The KeyW Corporation | Mar 2018–Apr 2019

  5. Integration Management Office (IMO) | Transition

    Sotera Defense Solutions → The KeyW Corporation | Feb–Dec 2017

  6. Resource Manager / Staffing Lead (PMO) | Primary

    Sotera Defense Solutions → The KeyW Corporation | Apr 2014–Jul 2017

  7. Junior Full-Stack Developer | Secondary

    Sotera Defense Solutions → The KeyW Corporation | Apr 2014–Jul 2017

EXPERIENCE | EARLIER IMPACT

Sotera Defense Solutions was acquired by The KeyW Corporation in April 2017. KeyW was acquired by Jacobs in June 2019, and that business unit was spun off to Amentum in September 2024. Highlights below cover earlier roles within that continuous tenure (Apr 2014–Present); prior employers follow.

EARLIER CONTRIBUTIONS WITHIN THE SAME LINEAGE

Earlier roles from the current-company chronology | Apr 2014–Apr 2019

  • Acquisition integration. Selected as one of two employees company-wide to help lead the integration; tracked more than 900 action items and delivered biweekly executive reporting as the program achieved $18.3M in annualized savings against a $7M–$10M target.

  • Global staffing. Led staffing across 55 worldwide locations, supporting 488 hires over 35 months and sustaining an average 96.4% fill rate—6.4 percentage points above the customer requirement.

  • Workflow application. Built SWARMS, a multi-user Microsoft SQL Server-backed application with business-process automation, candidate and requirement management, and cell-level auditing.

  • KeyW-Sotera reporting integration. During the merger, evaluated and consolidated 1,038 inherited reports into 317 production-ready reports through user prioritization; built two executive dashboards around KPIs defined with senior leaders.

  • Operational tracking. Supported requirements gathering, database development and testing for a web-based Army fielding tracker covering software and hardware configurations across approximately 80,000–100,000 deployed systems worldwide.

  • DHS data prototype. Developed a Microsoft Access collection-management database proof of concept later adopted into the division's standard operating procedures.

Database Manager

SAIC / LEIDOS | Feb 2013–Apr 2014

  • Program database. Designed and managed a 120+ table relational Microsoft Access database for a 900+ person program; translated user requirements into a functional tool and maintained redundancy and audit controls.

Staffing Manager

SAIC / LEIDOS | Dec 2011–Feb 2013

  • Large-scale proposal staffing. Supported federal proposals valued at up to $1.2B; evaluated more than 2,500 skills entries across 1,500+ candidates and mapped them to 949 positions.

UNITED STATES AIR FORCE

Mission Operations, Training & Technical Leadership | Feb 2002–Sep 2011

  • Mission operations. Supervised up to 18 operators across five mission types and supported software fielding that increased site geolocation capability by 50%.

  • Training systems. Authored a 46-page manual for space-based mission operations, covering orbital mechanics and related scientific principles; certified six operators, increasing available mission manning by 30%.

  • Combat deployments. Supported Army and Marine units on two deployments; coordinated 30+ liaisons across 13 organizations for 418 successful near-real-time targeting operations on one tour and provided intelligence support to Marine information operations.

  • Systems operations. Monitored dataflow across 135 networks and performed load balancing across multiple supercomputers.

PROFESSIONAL PROFILE

Technical leader with 20+ years across enterprise data engineering, federal program staffing and U.S. Air Force intelligence operations. As Amentum's Lead Developer for ETL and BI, owns integrations and production data delivery for a 2,500-user environment.

CURRENT ENTERPRISE IMPACT

  • Enterprise integration ownership. Serve as the sole data integration engineer for an approximately 2,500-user environment spanning Workday, Deltek Costpoint/T&E, the enterprise data warehouse and IBM Cognos Analytics.

  • Enterprise transition. Supported planning and phased testing for on-premises, hosted and cloud Costpoint migrations, plus Oracle Cloud and R12. On-premises moves crossed multiple Active Directory domains, including GCCH.

  • Workforce data pipeline. Built bidirectional employee demographics, leave and payroll ETLs; verified all 1,800 employee records in the first production load and established feedback loops with business teams to isolate and resolve data quality issues.

  • Data pipelines and Cognos administration. Built SOX-audited Python ETLs through CI/CD across up to 54 servers using Gitea, Jenkins, SFTP, SharePoint, SQL Server, SQLite, REST and SOAP APIs. Used Cognos to automate data deliveries and exception reporting; owned Cognos permissions, usage audits and SOX control preparation.

  • Procurement KPIs. Fed Global Supply Chain Management (GSCM) accounts payable, purchase order and vendor data through the enterprise data warehouse, enabling executive and VP-level purchasing and procurement officers to track current operational KPIs and trends.

  • Query performance. Researched performance constraints and added database maintenance and indexes; reduced a Revenue Operations query used more than 20 times per accounting period close from over two hours per run to under two minutes with identical results.

  • Remittance and period close. Used auditable Python scripts for weekly AP conversions and vendor remittance communications; reconciled period-close accounting data as it became system-formatted output, occasionally detecting material errors before external disclosure.

  • Costpoint upgrade. Coordinated network, database, certificate, Cognos validation and cutover work for the Costpoint 8.0-to-8.2 upgrade; migrated 2,500 daily active users from legacy servers to fully upgraded systems while preserving system access and user-facing URLs.

  • Migration scope and validation. Narrowed the Cognos migration inventory from roughly 8,000 reports to 113 repeatedly used reports; converted multiple functional business reports from PL/SQL to T-SQL, some with as many as 65 queries, to facilitate pre-migration validation.

CURRENT COMPANY | ROLE PROGRESSION

CONTINUOUS EMPLOYER LINEAGE | Sotera → KeyW → Jacobs → Amentum | Apr 2014–Present

  1. Lead Developer, ETL & Business Intelligence

    Jacobs → Amentum | Oct 2023–Present

  2. Software Developer / BI Analyst

    The KeyW Corporation → Jacobs | Apr 2019–Oct 2023

  3. Business Intelligence Analyst / Developer

    The KeyW Corporation | Jul 2017–Apr 2019

  4. Data Warehouse Architect / Analyst | Secondary

    The KeyW Corporation | Mar 2018–Apr 2019

  5. Integration Management Office (IMO) | Transition

    Sotera Defense Solutions → The KeyW Corporation | Feb–Dec 2017

  6. Resource Manager / Staffing Lead (PMO) | Primary

    Sotera Defense Solutions → The KeyW Corporation | Apr 2014–Jul 2017

  7. Junior Full-Stack Developer | Secondary

    Sotera Defense Solutions → The KeyW Corporation | Apr 2014–Jul 2017

ZAC KNAUSPAGE 1 OF 2

EXPERIENCE | EARLIER IMPACT

Sotera Defense Solutions was acquired by The KeyW Corporation in April 2017. KeyW was acquired by Jacobs in June 2019, and that business unit was spun off to Amentum in September 2024. Highlights below cover earlier roles within that continuous tenure (Apr 2014–Present); prior employers follow.

EARLIER CONTRIBUTIONS WITHIN THE SAME LINEAGE

Earlier roles from the page-one chronology | Apr 2014–Apr 2019

  • Acquisition integration. Selected as one of two employees company-wide to help lead the integration; tracked more than 900 action items and delivered biweekly executive reporting as the program achieved $18.3M in annualized savings against a $7M–$10M target.

  • Global staffing. Led staffing across 55 worldwide locations, supporting 488 hires over 35 months and sustaining an average 96.4% fill rate—6.4 percentage points above the customer requirement.

  • Workflow application. Built SWARMS, a multi-user Microsoft SQL Server-backed application
    with business-process automation, candidate and requirement management, and cell-level
    auditing.

  • KeyW-Sotera reporting integration. During the merger, evaluated and consolidated 1,038 inherited reports into 317 production-ready reports through user prioritization; built two executive dashboards around KPIs defined with senior leaders.

  • Operational tracking. Supported requirements gathering, database development and testing for a web-based Army fielding tracker covering software and hardware configurations across approximately 80,000–100,000 deployed systems worldwide.

  • DHS data prototype. Developed a Microsoft Access collection-management database proof of concept later adopted into the division's standard operating procedures.

Database Manager

SAIC / LEIDOS | Feb 2013–Apr 2014

  • Program database. Designed and managed a 120+ table relational Microsoft Access database for a 900+ person program; translated user requirements into a functional tool and maintained redundancy and audit controls.

Staffing Manager

SAIC / LEIDOS | Dec 2011–Feb 2013

  • Large-scale proposal staffing. Supported federal proposals valued at up to $1.2B; evaluated more than 2,500 skills entries across 1,500+ candidates and mapped them to 949 positions.

UNITED STATES AIR FORCE

Mission Operations, Training & Technical Leadership | Feb 2002–Sep 2011

  • Mission operations. Supervised up to 18 operators across five mission types and supported software fielding that increased site geolocation capability by 50%.

  • Training systems. Authored a 46-page manual for space-based mission operations, covering orbital mechanics and related scientific principles; certified six operators, increasing available mission manning by 30%.

  • Combat deployments. Supported Army and Marine units on two deployments; coordinated 30+ liaisons across 13 organizations for 418 successful near-real-time targeting operations on one tour and provided intelligence support to Marine information operations.

  • Systems operations. Monitored dataflow across 135 networks and performed load balancing across multiple supercomputers.