Overview SCCI is seeking a mid-level Database Developer to join our team! In this position you will support the design and implementation of a cohesive enterprise data ontology across a diverse portfolio of projects and systems. This role is central to transforming fragmented and unstructured data into a unified, well-modeled data ecosystem that supports analytics, interoperability, and long-term scalability. If you have strong database design expertise to support relating data across systems join our team and work closely with architects, data engineers, and domain stakeholders to define consistent data structures, normalize and map disparate datasets, and contribute to a shared enterprise data vision. This position is located in Dahlgren, VA.
SCCI offers a comprehensive and competitive benefits package including Health, Dental, Vision, Life and Disability benefits, 401k with Company Match, time off consisting of 2 weeks of paid vacation, 48 hours of sick/personal leave, and 11 paid Holidays.
Responsibilities:
- Database Design & Modeling
- Design, implement, and maintain relational and non-relational database schemas aligned with enterprise data standards
- Develop logical and physical data models that support scalability, performance, and maintainability
- Normalize and optimize table structures while balancing performance considerations
- Enterprise Data Ontology Development
- Contribute to the definition and evolution of an enterprise-wide data architecture
- Map data elements across systems into a unified conceptual model
- Define relationships, hierarchies, and semantic consistency across datasets
- Collaborate with stakeholders to standardize naming conventions and data definitions
- Structured & Unstructured Data Integration
- Analyze unstructured and semi-structured data (JSON, logs, documents, etc.) and design strategies to structure and integrate it
- Develop transformation pipelines to align disparate data sources into cohesive schemas
- Support metadata tagging and classification efforts
- Data Transformation & ETL Support
- Build and maintain a pipeline to extract, transform, load (ETL/ELT) and cleanse data
- Ensure data integrity, consistency, and traceability across systems
- Support data lineage and auditability requirements
- Cross-System Data Alignment
- Work across multiple project teams to reconcile differences in data structures and definitions
- Identify duplication, inconsistency, and gaps in existing data models
- Propose and implement standardized solutions
- Performance & Optimization
- Tune queries, indexes, and database configurations for performance and efficiency
- Monitor database health and implement improvements as needed
- Documentation & Governance
- Maintain clear documentation of schemas, data models, and ontology mappings
- Support data governance initiatives, including data quality standards and validation rules
- Contribute to best practices and development standards
Essential Skills and Experience:
- Must be a U.S. Citizen and be able to obtain and maintain an active Secret Security Clearance
- Bachelor's (BS) Degree in Information Systems, Computer Science, Engineering, or Math; Or five (5) years technical experience with information management in lieu of degree
- Three (3) - Six (6) years of experience in database development
- Strong proficiency in SQL and relational database design (e.g., PostgreSQL, SQL Server, Oracle, MySQL)
- Experience designing normalized schemas and understanding tradeoffs with denormalization
- Familiarity with handling semi-structured/unstructured data (e.g., JSON, XML, document stores)
- Experience with ETL/ELT processes and data transformation pipelines
- Solid understanding of data modeling concepts (ER diagrams, dimensional modeling, etc.)
- Ability to translate business/domain concepts into structured data representations
Preferred Skills and Experience:
- Active Secret Security Clearance
- Experience contributing to or working with data ontologies, semantic models, or knowledge graphs
- Familiarity with data cataloging, metadata management, or data governance tools
- Exposure to NoSQL databases (MongoDB, Cassandra, etc.) and hybrid data architectures
- Experience with cloud data platforms (AWS, Azure, GCP)
- Experience with Docker containerization
- Knowledge of data lineage, data quality frameworks, and master data management (MDM)
- Basic scripting or programming skills (Python, Bash Script, etc.) for data processing
SCCI is committed to providing a comprehensive and competitive benefits package to meet the needs of Employees and their families. EOE of Veterans and Disabilities.
|