Technical Data and Platform Specialist - Mid #2076

Compass is looking for a motivated individual to provide operational services to the Intelligence Community (IC), the Department of War (DoW), and Federal communities. Our goal is to hire talented and passionate team members who desire to grow their skill sets, as well as the reputation of the company with our partners, clients, and stakeholders. We are looking for an individual to join an innovative team supporting mission critical/mission essential activities. Professional IT certification training opportunities and assistance are available through Compass.

Position Title: Technical Data and Platform Specialist (Mid)
Clearance: Active Top Secret/SCI
Locations: Washington Metropolitan Area, St. Louis, MO, Huntsville, AL

Position Description

The Mid-Level Technical Data & Platform Specialist will support the development, administration, and integration of enterprise data and workflow solutions. Leveraging their experience with PostgreSQL databases, the candidate should have a strong understanding of data management principles, and experience supporting application and platform environments. Experience with ServiceNow and RaptorDB is highly desirable.
This Technical Specialist will work closely with system architects, system administrators, and solution developers to design, implement, maintain, and optimize data-driven solutions supporting enterprise business operations.

Key Duties:

Administer and maintain PostgreSQL databases and related data services.
Develop SQL queries, views, stored procedures, and database reports.
Monitor system performance and resolve database and application issues.
Support data migrations, integrations, and ETL processes.
Configure and support ServiceNow applications, workflows, and integrations.
Assist with RaptorDB administration, data modeling, and query development.
Develop APIs and data interfaces between enterprise systems.
Create technical documentation and maintain operational procedures.
Support software deployments, testing, and system upgrades.
Collaborate with cross-functional teams to deliver data-driven solutions.
Ensure data security, integrity, and compliance with organizational standards.
Provide technical support and troubleshooting for enterprise users and applications.
RaptorDB database administration with experience in the ServiceNow Platform data layer, shifting away from traditional relational DBA skills towards optimizing high-speed, multi-node, and AI-ready enterprise workflows
HTAP (Hybrid Transactional and Analytical Processing): Proficiency in managing single-engine databases where live transactional updates and deep analytics run concurrently on the same data without pipeline delays.
Advanced Indexing Management: Experience in working with RaptorDB's integrated column-store indexes and parallel processing frameworks, which require specialized knowledge to map and accelerate specific reporting workloads.
Elastic Scalability & Resource Balancing: The ability to configure multi-node clusters and balance workloads, including prioritizing real-time enterprise queries against heavy background operations like generative AI.
Customization vs. Platform Alignment: Apply smart customization, avoiding instance sprawl and unnecessary data partitioning while leveraging out-of-the-box system capabilities.
Platform-Level Troubleshooting: Integrate ServiceNow's performance monitoring tools with RaptorDB's unique architecture to eliminate workflow bottlenecks.

Required Qualifications:

PostgreSQL database administration and development.
SQL query development and optimization.
Database schema design and data modeling.
Linux and/or Windows server environments.
Git or other version control systems.
Data troubleshooting and root cause analysis.
Basic scripting skills (Python, PowerShell, Bash, or similar).

Desired Qualifications:

Experience with ServiceNow Administration or Development.
Experience with RaptorDB database technologies and architectures.
Knowledge of IT Service Management (ITSM) processes.
Experience working in cloud environments (AWS, Azure, or Google Cloud).
Familiarity with Agile development methodologies.
Experience with data analytics and reporting tools.
Understanding of cybersecurity and data governance principles.

Work Level:

Self-guided individual work
Proactive team member
Task lead

Guidance Required:

Requires guidance only when dealing with new, uncertain, undefined or undeveloped tasks

Skills and Tasks:

Able to develop & use complex concepts & processes
Conduct root cause problem analysis
Guide & support Junior level personnel

Education:

Master's degree,
Bachelor's degree plus 2 years of experience,
Associates degree plus 4 years' experience, or
Minimum of 6 years' experience in a related field

Certifications:

PostgreSQL Professional Certification (Desired)
ServiceNow Certified System Administrator (CSA) (Desired)

Details:
Target Salary Ranges:

$90,700 - $150,600 WMA

$80,000 - $132,800 St. Louis, MO

$80,200 - $133,100 Huntsville, AL

These represent the typical salary ranges for this position. Salary is determined by various factors, including but not limited to, the scope and responsibilities of the position, the individual's experience, clearance, education, knowledge, skills, and competencies, as well as geographic location and business and contract considerations.

EEO: Equal Opportunity Employer, including disability and protected veterans, or other characteristics protected by law.

Compass, Inc. (Compass) is a Small Business (SB) headquartered in Winchester, VA as a Defense and Intelligence solutions provider to the United States Government. We provide Systems Engineering and Technical Assistance (SETA), Advisory and Assistance Services (A&AS), and Systems Engineering and Integration (SE&I) to our government and business partner customers. As a premier Defense and Intelligence solution provider, we employee a diverse, agile, highly trained and extremely talented staff