> Markdown version of [/jobs/ext/1742850-data-access-layer-senior-data-engineer-data-architect](https://www.wearedevelopers.com/jobs/ext/1742850-data-access-layer-senior-data-engineer-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Access Layer Senior Data Engineer / Data Architect - **Company:** Caci Inc - **Location:** United States - **Experience:** Expert - **Salary:** $114,600.0 - $252,100.0 - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Agile Methodology, Amazon Web Services, Audit Trail, Big Data, Code Reuse, Databases, Data Architecture, Information Engineering, Data Transformation, Data Security, Data Structures, Data Systems, Relational Databases, Distributed Data Store, Identity and Access Management, PostgreSQL, OAuth, OpenID, Oracle (Applications), Performance Tuning, Migration Manager, Data Access Layer, Zero Trust Network Access, Application Data, Software Engineering, SQL Stored Procedures, Openapi, Transaction Processing (Computing), Change Data Capture, Data Layers, Debezium, Information Technology, AWS Glue, Apache Kafka, Functional Programming, Cloudwatch, Code Restructuring, Devsecops - **Published:** July 3, 2026 - **Apply:** https://www.clearancejobs.com/jobs/9011108/data-access-layer-senior-data-engineer-data-architect ## About the Role Required: * 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. Desired: * 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. ## Description 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., * 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. ## Related Videos - [Keeping applications secure by evolving OAuth 2.0 and OpenID Connect](https://www.wearedevelopers.com/videos/100152-keeping-applications-secure-by-evolving-oauth-2-0-and-openid-connect) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [For the REST of us: API First and Conway’s Law](https://www.wearedevelopers.com/videos/1932-for-the-rest-of-us-api-first-and-conway-s-law) - [Get started with securing your cloud-native Java microservices applications](https://www.wearedevelopers.com/videos/123-get-started-with-securing-your-cloud-native-java-microservices-applications) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Contract-First Frontend: Scaling Reliable UIs with OpenAPI and AI](https://www.wearedevelopers.com/videos/1995-contract-first-frontend-scaling-reliable-uis-with-openapi-and-ai) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Dev Digest 162: AI careers, MCP, AWS best practices & floppy sweaters](https://www.wearedevelopers.com/magazine/571-dev-digest-162-ai-careers-mcp-aws-best-practices-floppy-sweaters) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)