Data Access Layer Senior Data Engineer / Data Architect

CACI is seeking a highly skilled Senior Data Engineer / Data Architect to support a major modernization effort within a mission critical DoW environment. This position will lead the design and implementation of the data layer, enabling secure, scalable integration between databases such as Oracle and PostgreSQL.

Responsibilities:

• Lead data layer architecture, development, and implementation. Candidate will be responsible for working with data engineers / modelers to build efficient data structures to support transaction processing and reporting needs
• Architect and implement data exchanges between database systems such as Oracle and PostgreSQL. Tools that will be used include AWS DMS
• Design and implement replication using event streaming patterns. AWS MSK (Managed Kafka) can be used to support topic creation, consumer groups, etc
• Design and implement transformation functionality using cloud-native AWS services and integration utilities
• Analyze legacy stored procedures, triggers, constraints, and data dependencies to inform migration strategy
• Support incremental migration and soft cutover strategies that preserve operational continuity
• Lead implementation of secure REST/OpenAPI endpoints to support application data storage / retrieval requirements
• Use / establish SOPs for using CloudTrail to monitor API activity
• Support implementation of GovCloud compliant controls including, but no limited to, ICAM IDP/OAuth2/OIDC, ABAC, encryption-in-flow, encryption-at-rest
• Develop and implement data access standards and best practices for the project
• Work closely with solution architects, data modelers, cloud engineers, and DevSecOps teams
• Lead technical reviews, design sessions, and data modeling workshops
• Mentor junior engineers and drive best practices for secure, reliable data engineering

Requirements:

• Bachelor's degree in Computer Science, Engineering, or related technical field
• 10+ years of hands-on data engineering or data architecture experience
• Ability to obtain and maintain a DoD Secret clearance is required
• Demonstrated expertise with data transformation. (e.g. AWS DMS, AWS Glue, Debezium, etc.)
• Strong experience with AWS MSK (Managed Kafka): topic design, schema registry, event streaming patterns
• Proven experience migrating and systems from on-prem RDBS systems to cloud based database systems such as PostgreSQL
• Experience with schema refactoring, performance tuning, and operational cutover
• Experience designing and implementing high-performance APIs to support module application development and code reuse
• Hands-on experience with AWS GovCloud, including IAM, CloudWatch, CloudTrail, Lambda, and KMS
• Strong background in distributed data integration
• Active AWS Certified Data Engineer – Associate certification
• Experience modernizing data systems for DoW customers
• Familiarity with Zero Trust, IL5 boundary conditions, ICAM integration, and RMF compliance
• Experience working in Agile/SAFe environments with DevSecOps pipelines