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:
Advanced SQL, including hands-on experience with large scale distributed query engines such as Presto and Hive
Demonstrated experience building and maintaining production data pipelines (ETL/ELT), including scheduling, backfills, and failure monitoring
Data modeling and warehouse design: table schema design, partitioning, and documentation
Nice-to-have Skills:
Python or similar scripting for data transformation and automation
Experience supporting an IT, enterprise support, or technical operations organization
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.
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.
Applicant Notices & Disclaimers
For information on benefits, equal opportunity employment, and location-specific applicant notices, click here
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws.This position's pay range is $70.00/hr - $75.00/hr.
