Data Access Layer Senior Data Engineer / Data Architect
About The Position
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. The ideal candidate has expertise in AWS DMS, AWS Managed Kafka (MSK), large‑scale data migration, and multi‑system integration patterns, and the ability to support replication through Change Data Capture. The architect will be responsible for designing and exposing appropriate APIs to support business needs.
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.
Nice To Haves
- 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.
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.
- Design and implement replication using event streaming patterns.
- 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.
Benefits
- healthcare
- wellness
- financial
- retirement
- family support
- continuing education
- time off benefits
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
