Data Access Layer Senior Data Engineer / Data Architect
Caci•23h ago
United StatesRemote$114.6K–$252.1KFull-timeSenior Level10+ yrs exp
Top focus
Data EngineerSenior Data EngineerVp DataIdentity EngineerSenior Data Analyst
Job Title: Data Access Layer Senior Data Engineer / Data Architect Travel: Local * * * The Opportunity: 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
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
Qualifications
- 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. - What You Can Expect: A culture of integrity.
- At CACI, we place character and innovation at the center of everything we do.
- As a valued team member, you’ll be part of a high-performing group dedicated to our customer’s missions and driven by a higher purpose – to ensure the safety of our nation.
- An environment of trust.
- CACI values the unique contributions that every employee brings to our company and our customers - every day.
- You’ll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.
- A focus on continuous growth.
- Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground — in your career and in our legacy.
- Pay Range : There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications.
- Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives.
- We offer competitive compensation, benefits and learning and development opportunities.
- Our broad and competitive mix of benefits options is designed to support and protect employees and their families.
- At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.
- Since this position can be worked in more than one location, the range shown is the national average for the position.
- The proposed salary range for this position is: $114,600-$252,100 CACI is an Equal Opportunity Employer.
- All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran
- any other protected characteristic.
Required skills
AWS DMSAWS Managed Kafkadata migrationAPI designdata transformationAWS GlueDebeziumPostgreSQLschema refactoringperformance tuningAWS GovCloudIAMCloudWatchCloudTrailLambda