Remote Senior Data Systems Analyst - End-to-End Pipelines

Spectraforce Technologies, Inc.; Raleigh (NC); Remote; USD 90,000 - 150,000; Full time

Job summary

Spectraforce Technologies, Inc. is seeking a Business Systems Analyst IV to own the data systems supporting Enterprise Support. The role emphasizes building and maintaining data pipelines, Hive tables, and dashboards while applying AI/LLM tooling to accelerate data work and improve governance.

Required 5-7 years of experience, strong SQL with Presto/Hive, and experience delivering production data pipelines. Bachelor’s degree in a quantitative field is expected.

Qualifications

• Advanced SQL including Presto and Hive.
• Production data pipelines (ETL/ELT) ownership and monitoring.
• Data modeling and warehouse design with clear documentation.

Responsibilities

• Own day-to-day health of the Enterprise Support data layer: pipelines, Hive tables, SQL, and dashboards.
• Design and build data models for new reporting needs; propose approaches.
• Maintain source of truth for metrics: definitions, ownership, freshness.

Skills

Advanced SQL

Production data pipelines

Data modeling

AI/LLM tooling

Dashboarding

Education

Bachelor's degree

Tools

Presto

Hive

Python

Job description

Spectraforce Technologies, Inc. is seeking a Business Systems Analyst IV to own the data systems supporting Enterprise Support. The role emphasizes building and maintaining data pipelines, Hive tables, and dashboards while applying AI/LLM tooling to accelerate data work and improve governance.

Required 5-7 years of experience, strong SQL with Presto/Hive, and experience delivering production data pipelines. Bachelor’s degree in a quantitative field is expected.