Business Systems Analyst III

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

Job Title: Business Systems Analyst IV

Location: Remote (preferably PST Time)

Duration: 12 Months with possibility to extend up to 30 months

Summary:

• Business Analyst with 6-7 years of experience in SQL, data modeling, pipeline development, and operational analytics, who can own and improve the data systems supporting all Enterprise Support pillars rather than only maintain them.
• Day to day this covers building and maintaining data pipelines, Hive tables, SQL queries, and dashboards. Beyond that, the role is expected to bring its own judgment: proposing better data models, applying AI and LLM tooling to accelerate data work and extract signal from unstructured support data, improving documentation and governance standards, and identifying reporting gaps.
• Priorities and direction are set with the Client manager, but the contractor owns how the work gets done and is expected to identify and recommend improvements.

Compliance Requirements:

• Must follow Client data handling and privacy standards, including appropriate data classification, least privilege access to sensitive datasets, and no storage of confidential or personally identifiable data outside approved internal systems. Must apply sound judgment about the appropriate use of AI and LLM tooling on internal data. Experience working within enterprise data governance and access control processes is required.

Must-Have HARD Skills:

1. Advanced SQL, including hands-on experience with large scale distributed query engines such as Presto and Hive
2. Demonstrated experience building and maintaining production data pipelines (ETL/ELT), including scheduling, backfills, and failure monitoring
3. Data modeling and warehouse design: table schema design, partitioning, and documentation

Nice-to-have Skills:

1. Python or similar scripting for data transformation and automation
2. Experience supporting an IT, enterprise support, or technical operations organization
3. Experience building dashboards and maintaining operational metrics or SLA reporting

Years of Experience: 5-7 years (Level III)

• Level four preferably

Degrees/Certifications Required:

• Bachelor's degree in a quantitative, analytics, computer science, or information systems field, or equivalent practical experience. No specific certifications required.

Candidate Disqualifiers

Are there any types of candidate profiles or skills that may not be the right fit for this team?

• Candidates whose experience is limited to using dashboards or BI tools without writing their own SQL. Pure business or process analysts with no hands-on data engineering work. Candidates who have only worked in small, spreadsheet-driven datasets and have not operated production pipelines. Candidates who require constant direction, since this role works largely independently from written requirements.

Are there any immediate disqualifiers or red flags that stand out?

• No demonstrable advanced SQL on the resume. No experience owning or maintaining production data pipelines. Inability to explain past pipeline or data modeling work in technical detail. Poor written communication, since status, documentation, and blockers are communicated in writing. Unable to work core hours overlapping PST.

What are some difficulties that the candidate should be aware they may face in the role and need to be able to handle to be successful?

• This is a single-person function, so the contractor owns the data systems end to end and is the first responder when a pipeline fails or a number looks wrong.
• Client's internal data tooling has a learning curve, and source systems are numerous and inconsistent, so data quality work is ongoing.
• Requirements arrive from the Client manager and must be executed with limited hand-holding, and the role must balance recurring reporting deadlines against ad hoc requests.
• Remote, so self-direction and proactive written communication are essential.

Skillsets/Qualifications:

Helpful qualifications include:

• Advanced SQL, ideally with Presto and Hive against large datasets
• Building and maintaining production data pipelines: scheduling, dependency management, backfills, and monitoring
• Data modeling and warehouse design: schema design, grain, partitioning, and documentation
• Practical use of AI and LLM tooling in data work, and judgment about where it is and is not appropriate
• Data governance practice: documented metric definitions, clear table ownership, schema change management, and retiring stale datasets
• Python or similar scripting for data transformation and automation
• Dashboarding and data visualization
• Prior experience supporting an IT, enterprise support, or operations organization
• Self-directed: able to take a loosely defined problem, propose an approach, and execute it
• Bachelor's degree in a quantitative, analytics, computer science, or information systems field, or equivalent practical experience

Responsibilities:

• Own the 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, proposing the approach rather than receiving a specification
• Maintain a documented source of truth for Enterprise Support metrics: definitions, ownership, and freshness
• Apply AI and LLM tooling to accelerate data work and to extract signal from unstructured support data such as ticket notes and resolution summaries
• Improve pipeline reliability and reduce manual effort over time through automation
• Monitor pipeline health, resolve failures and data quality issues, and run backfills
• Deliver recurring reporting (weekly, monthly, quarterly) and ad hoc analysis
• Apply and maintain standards for naming, documentation, and schema change management
• Proactively surface data quality, governance, and coverage gaps

Minimum qualifications:

• 6-7 years of experience in data analytics, business analytics, or analytics engineering
• Advanced SQL skills, including experience with large scale distributed query engines such as Presto and Hive
• Demonstrated ownership of production data pipelines and data models, including design decisions rather than only maintenance
• Practical experience applying AI or LLM tooling within data workflows
• Experience with data modeling and dashboard development
• Ability to work independently and communicate status, recommendations, and blockers clearly in writing

Preferred qualifications:

• Data governance experience: metric catalogs, lineage, table ownership, and schema change management
• Experience supporting an IT, enterprise support, or technical operations organization
• Python or similar scripting experience for data automation
• Experience maintaining operational metrics and SLA reporting

Interview Process: Interview Duration:

• Round 1: 45 minutes. Round 2: 45-60 minutes.