Technical Data and Platform Specialist - Mid #2076

Compass, Inc; Springfield (VA); On-site; USD 90,700 - 150,600; Full time

Job summary

Compass, Inc. is seeking a Mid-level Technical Data & Platform Specialist to support the development, administration, and integration of enterprise data and workflows.

The role emphasizes PostgreSQL, ServiceNow, and RaptorDB expertise within a mission-critical environment. The position collaborates with system architects and developers to design, maintain, and optimize data-driven solutions across enterprise operations, ensuring security and compliance as part of a fast-paced team.

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).

Responsibilities

• 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 ServiceNow data layer expertise.
• HTAP: manage live updates and analytics on same data.
• Advanced indexing management for RaptorDB.
• Elastic scalability and resource balancing.
• Platform-level troubleshooting with ServiceNow and RaptorDB.

Skills

PostgreSQL

SQL

Data modeling

Linux/Windows

Git

Scripting

Education

Master’s degree

Bachelor’s degree + 2 years

Associates degree + 4 years

6+ years related experience

Job description

Job Openings >> Technical Data and Platform Specialist – Mid #2076

Summary

Title:

Title: Technical Data and Platform Specialist – Mid #2076

ID:

ID: 2076

Location:

Location: Huntsville, AL, St. Louis, MO, Chantilly, VA, Springfield, VA

Clearance Required:

Clearance Required: Top Secret/SCI

Description

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.

Guidance Required

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

Skills and Tasks

• Self-guided individual work
• Proactive team member
• Task lead

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

Details

Target Salary Ranges:

$90,700 - $150,600 WMA

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

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