Senior Data Engineer (Full Scope Poly)

Concept Plus; Reston (VA); On-site; USD 140,000 - 180,000; Full time

Benefits offered by this job

Competitive pay

Health, dental, vision insurance

Paid life insurance

Paid time off

11 paid holidays

Performance bonuses

Tuition reimbursement

Unlimited training

Collaborative, flexible, innovative环境

Job summary

Concept Plus is seeking a highly experienced Senior Data Engineer to lead the Oracle data architecture for a cloud-native data platform supporting mission-focused applications. You will design and own database schemas, data models, and data standards to ensure secure, reliable data products for Phoenix and related efforts.

The role requires 8+ years in data engineering and a TS/SCI clearance with Polygraph, strong Oracle expertise, and hands-on experience with ETL, SQL, and data governance.

Qualifications

• Must possess a TS/SCI security clearance with Polygraph.
• Minimum 8+ years of experience in data engineering, Oracle database development, data architecture, or database management.
• Strong expertise in Oracle Database technologies.
• Experience designing, implementing, and owning data models, schemas, tables, and references for enterprise Oracle databases.
• Proficiency in PL/SQL, SQL, stored procedures, packages, partitioning, indexing, and performance tuning.
• Knowledge of data warehousing concepts, data governance, and data lifecycle management.
• Familiarity with ETL, data transformation, and validation for large-scale systems.
• Experience with secure, scalable Oracle database solutions, including RBAC, encryption, auditing, backup/recovery.
• Automation skills with shell scripting or Python for DB admin and deployment.
• Experience with CDC technologies like Oracle GoldenGate.
• Ability to collaborate with developers, cloud/ security engineers, and analysts to translate mission needs into durable data solutions.

Responsibilities

• Design, implement, and own Oracle data architecture, schemas, and data standards for mission-ready data products.
• Develop secure, scalable Oracle database solutions with proper access controls and data protection.
• Collaborate with cross-functional teams to translate requirements into durable data solutions.
• Define data standards, naming conventions, data quality controls, and retention requirements.
• Support ETL design and data validation for large-scale systems.
• Contribute to Oracle GoldenGate or similar CDC/data integration efforts.

Skills

Oracle

PL/SQL

Data modeling

Data warehousing

ETL

Shell scripting

Python

Agile

Security clearance TS/SCI

Communication

Education

Bachelor's Degree in engineering/computer science/related

Master's degree preferred

Tools

Oracle GoldenGate

CI/CD pipelines

Oracle Database

Job description

About Concept Plus

Concept Plus is a mission-focused technology solutions provider that transforms IT concepts into impactful solutions for federal agencies. Headquartered in Fairfax, VA, we bring the agility, responsiveness, and customer intimacy of a small business combined with the quality and infrastructure of a larger firm.

Recognized as an award-winning Oracle partner, we have delivered innovative solutions across Defense, Intelligence, Civilian, Health IT, and Tribal sectors. Our highly certified experts build systems that drive efficiency, accelerate modernization, and ensure mission outcomes with certainty.

• We offer competitive pay
• comprehensive health, dental, and vision insurance
• paid life insurance
• paid time off
• 11 paid holidays
• performance bonuses
• tuition reimbursement
• unlimited training
• the opportunity to thrive in a collaborative, flexible, and innovative environment

Concept Plus is seeking a highly experienced and motivated Senior Data Engineer for an exciting new contract. This role is fully onsite in Reston, VA (5 days per week required).

What you'll do

The Senior Data Engineer will be part of a team of Application, Cloud, and Security engineers delivering a cloud-native, centralized data platform that provides end-to-end budget traceability. This role will design, implement, and own the Oracle data architecture, database schemas, tables, and data standards that enable reliable, secure, and mission-ready data products for Phoenix.

Required Qualifications

• Must possess a TS/SCI security clearance with Polygraph.
• Minimum 8+ years of experience in data engineering, Oracle database development, data architecture, or database management.
• Strong expertise in Oracle Database technologies
• Demonstrated experience designing, implementing, and owning logical and physical data models, database schemas, tables, views, keys, constraints, and reference data for enterprise Oracle databases.
• Proven experience with PL/SQL, SQL, stored procedures, packages, Oracle partitioning, indexing, query optimization, and performance tuning.
• Deep understanding of relational data modeling, normalization, dimensional modeling, data warehousing concepts
• Experience defining and enforcing data standards, naming conventions, data quality controls, business rules, retention requirements, and data lifecycle management.
• Strong knowledge or experience of ETL pipeline design, data transformation, reconciliation, and validation for large-scale data systems.
• Experience designing secure and scalable Oracle database solutions, including role-based access controls, encryption, auditing, backup and recovery considerations, and sensitive-data handling.
• Proficiency in shell scripting, Python, or comparable automation tools for database administration, deployment, monitoring, and operational support.
• Experience with Oracle GoldenGate or similar change data capture (CDC), replication, or data integration technologies.
• Familiarity with data governance, metadata management, master/reference data, data lineage, and cataloging practices.
• Ability to work with application developers, cloud engineers, security engineers, and business analysts to translate mission needs into durable data solutions.
• Strong verbal and written communication skills for documenting data architecture, schemas, standards, and implementation decisions.
• Experience working in an Agile framework.
• 8+ years of experience relevant to this position.
• Bachelor's Degree in engineering, computer science, business, or related discipline. Master's degree preferred.

Preferred Qualifications

• Experience integrating Oracle databases with cloud-native services, big data platforms, or data lakes.
• Familiarity with Oracle Autonomous Database and Oracle Analytics
• Experience with Oracle Cloud Infrastructure (OCI), including database, storage, networking, and data integration services.
• Experience implementing database schema migrations and database change management through DevOps and CI/CD pipelines.
• Knowledge of federal data security, privacy, and compliance requirements relevant to mission systems.
• Oracle certifications, such as Oracle Certified Professional, Oracle Database Administration, or Oracle Data Integration certification.

Concept Plus is an Equal Opportunity Employer. As such, we will give your application full consideration without regard to your race, color, religion, sex, age, national origin, disability, veteran status, sexual orientation, gender identity, or any other classification protected by federal, state, or local law.