Data Platform Specialist (Mid): PostgreSQL & ServiceNow Expert

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

Job summary

Compass, Inc. seeks a Mid-level Technical Data and Platform Specialist to support enterprise data and workflow solutions. You will work with PostgreSQL databases, ServiceNow, and RaptorDB, designing, implementing, and maintaining data-driven platforms across multiple locations, including the Washington Metro Area, St.

Louis, and Springfield. Candidates should have strong SQL, data modeling, and scripting skills, with cloud and ITSM familiarity.

Qualifications

• Master’s degree in a related field.
• Bachelor’s degree plus 2 years of experience.
• Associates degree plus 4 years' experience.
• Minimum of 6 years' experience in a related field.

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

Skills

PostgreSQL

SQL

Data modeling

Linux/Windows

Git

Scripting

Python

Education

Master’s degree

Bachelor’s degree + 2 years experience

Associates degree + 4 years experience

Minimum 6 years experience in a related field

Tools

ServiceNow

RaptorDB

APIs

AWS

Azure

Job description

Compass, Inc. seeks a Mid-level Technical Data and Platform Specialist to support enterprise data and workflow solutions. You will work with PostgreSQL databases, ServiceNow, and RaptorDB, designing, implementing, and maintaining data-driven platforms across multiple locations, including the Washington Metro Area, St.

Louis, and Springfield. Candidates should have strong SQL, data modeling, and scripting skills, with cloud and ITSM familiarity.