Senior Data Engineer (Full Scope Poly)
Concept Plus, LLC3 months ago
Reston, VA, USASenior
Responsibilities
- Design, implement, and own Oracle data architecture, logical and physical data models, schemas, tables, views, keys, constraints, and reference data.
- Develop and optimize PL/SQL, SQL, stored procedures, packages, partitioning, indexing, queries, and database performance.
- Define and enforce data standards, naming conventions, data quality controls, business rules, retention requirements, and data lifecycle management.
- Design ETL pipelines and perform data transformation, reconciliation, and validation for large-scale data systems.
- Design secure and scalable Oracle database solutions with access controls, encryption, auditing, backup and recovery considerations, and sensitive-data handling.
- Use shell scripting, Python, or comparable automation tools for database administration, deployment, monitoring, and operational support.
- Implement change data capture, replication, or data integration using Oracle GoldenGate or similar technologies.
- Collaborate with application developers, cloud engineers, security engineers, and business analysts and document architecture and implementation decisions.
Requirements
- US citizenship is required.
- A TS/SCI security clearance with polygraph is required.
- At least 8 years of experience in data engineering, Oracle database development, data architecture, database management, or a related area is required.
- A bachelor’s degree in engineering, computer science, business, or a related discipline is required.
- Strong Oracle Database expertise and experience with relational modeling, dimensional modeling, data warehousing, governance, metadata, lineage, and cataloging are required.
- Experience with secure, scalable Oracle database design, ETL, data quality, replication, automation, and operational support is required.
- Experience working with cross-functional engineering and business teams and documenting technical decisions is required.
- Experience with Agile frameworks is required.
- Preferred qualifications include a master’s degree, Oracle Autonomous Database, Oracle Analytics, Oracle Cloud Infrastructure, cloud-native and data lake integration, database migrations, DevOps and CI/CD pipelines, federal security and compliance, and Oracle certifications.
Benefits
- The role is fully onsite in Reston, Virginia, five days per week.
- Benefits include health, dental, and vision insurance, paid life insurance, paid time off, and 11 paid holidays.
- The company offers performance bonuses, tuition reimbursement, unlimited training, and a collaborative, flexible, and innovative work environment.
About Concept Plus, LLC
Concept Plus, LLC is an IT services and consulting firm delivering Oracle-based solutions, cloud engineering, data analytics, and health IT for government and commercial clients. It implements and supports Oracle E‑Business Suite and Fusion Middleware, systems integration, and application modernization, with notable work supporting the U.S. Department of Defense and Defense Health Agency. Founded in 2008 and headquartered in Fairfax, Virginia, it is an Oracle Partner with ISO 9001/20000-1/27001 certifications and a CMMI Level 3 appraisal.