Business Intelligence and Reporting Analyst (Oracle Analytics)

HRsmart; Fairfax (VA); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical coverage

401(k) with employer match

Life insurance

Disability insurance

Paid time off & holidays

Parental leave

Certification reimbursement

Tuition assistance

Job summary

SPN Solutions in Fairfax, Virginia is hiring a Business Intelligence and Reporting Analyst to move reports from OBIEE to Oracle Analytics Server and Oracle Analytics Cloud. The role focuses on data quality visibility, migration, and end-to-end reporting for inventory, orders, deployments and operations.

The candidate will build dashboards, collaborate with users to gather requirements, and validate results against the source of truth. Hybrid work with core hours in Eastern time is offered.

Qualifications

• 4+ years of Oracle BI development (OBIEE, OAS, OAC) including RPD and subject area modeling.
• Data quality dashboards and metrics reporting experience; data quality visualization practice.
• Strong SQL against Oracle databases and understanding of ERP data.
• U.S. citizenship and ability to obtain an HHS Tier 2 public trust determination.

Responsibilities

• Develop and maintain reports, subject areas and dashboards in OBIEE, OAS and OAC for inventory, orders, deployments and operations.
• Build data quality dashboards and metrics reporting with clear visualization to show discrepancies and trends.
• Migrate reporting from the legacy platform to Oracle Analytics; validate results against source of truth.
• Gather reporting requirements from users, model data, tune queries, and document.
• Support ad hoc analysis for the program and the customer, including audit and inventory reconciliation evidence.

Skills

Oracle BI development

SQL

Data quality dashboards

ERP data understanding

RPD modeling

Education

Bachelor's Degree

Tools

OBIEE

Oracle Analytics Server

Oracle Analytics Cloud

Oracle E-Business Suite

Job description

Business Intelligence and Reporting Analyst (Oracle Analytics) - (152)

Share this job as a link in your status update to LinkedIn.

Job Title

Business Intelligence and Reporting Analyst (Oracle Analytics)

Job Type

Full-time

Category

Information Technology

Location

FAIRFAX - , VA 22030 US (Primary)

Education

Bachelor's Degree

Travel

0 - 10%

Job Description

You build the reports and dashboards the Stockpile runs on, moving them from OBIEE to Oracle Analytics Server and Oracle Analytics Cloud, and you make data quality visible to the people who have to act on it. Full time, W-2, based in Fairfax, Virginia with some telework, starting October 2026.

Why this job exists

SPN Solutions has won a new contract to operate and modernize the information systems behind the Strategic National Stockpile, part of HHS's Administration for Strategic Preparedness and Response (ASPR). The Stockpile holds the nation's reserve of medicines and medical supplies for public health emergencies. When a hurricane, an outbreak or another emergency calls for those supplies, the systems this team runs are how the country knows what it has, where it is and how fast it can move. The platform is Oracle E-Business Suite, and the program is moving it to Oracle Cloud while raising the quality of the inventory data and tightening the integration with the warehouse partners that hold the stock. You would join at the start, on a new team, with real work to own from the first week.

Why people take this job

• A mission you can explain at the dinner table: the nation's emergency medical supplies
• Hybrid in Fairfax, Virginia with some telework, sensible core hours and federal holidays off
• A modern Oracle stack and a real cloud migration, not a maintenance backwater
• A new team being built now: early hires shape how the work is done and grow with it
• Certifications and training paid for, with time set aside to earn them
• A company small enough that the people who run it know your name and answer your messages

What you will do

• Develop and maintain reports, subject areas and dashboards in OBIEE, Oracle Analytics Server and Oracle Analytics Cloud for inventory, orders, deployments and operations.
• Build data quality dashboards and metrics reporting with clear visualization practice, so discrepancies and trends are seen early.
• Migrate reporting from the legacy platform to Oracle Analytics; validate results against the source of truth.
• Gather reporting requirements from users, model data, tune queries, and document.
• Support ad hoc analysis for the program and the customer, including audit and inventory reconciliation evidence.

What you need

• 4 or more years of Oracle business intelligence development (OBIEE, Oracle Analytics Server or Oracle Analytics Cloud), including RPD and subject area modeling.
• Data quality dashboard and metrics reporting experience, and data quality visualization practice.
• Strong SQL against Oracle databases and an understanding of ERP data.
• U.S. citizenship and the ability to obtain an HHS Tier 2 public trust determination.

What sets a candidate apart

• Power BI alongside Oracle Analytics.
• Section 508 accessible reporting.
• Supply chain or inventory analytics.

Pay is discussed with you directly when we speak. These are the benefits every full-time SPN employee receives.

• Medical and prescription coverage, dental and vision, with employer-subsidized premiums for employees and dependents
• 401(k) with employer match
• Group life insurance at no cost to you
• Short-term and long-term disability
• Paid time off, 11 federal holidays, paid sick leave, bereavement leave
• Parental leave
• Certification reimbursement (Oracle, OCI, AWS/Azure, PMP, ITIL, Security+, CISSP and others), an annual training budget and tuition assistance

• Full time, W-2, salaried (exempt), employed by SPN Solutions
• Target start: October 2026
• Hybrid: based at SPN's office in Fairfax, Virginia, with some telework; occasional days at the customer's Atlanta, Georgia campus when the work requires it
• Core hours 9:00 a.m. to 3:30 p.m. Eastern, Monday to Friday, with flexible start between 6:00 and 9:00 a.m. Eastern; federal holidays off
• You must be a U.S. citizen and obtain and keep an HHS Tier 2 (moderate risk) public trust determination; no security clearance is required
• You complete HHS security, privacy and records management training before access, and cGMP training shortly after you start
• Work is done on customer-furnished or SPN-furnished equipment under HHS security rules

SPN Solutions is an Equal Opportunity Employer. All qualified applicants are considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status. SPN participates in E-Verify.

Keywords: BI Analyst, Reporting Analyst, OBIEE, Oracle Analytics Server, OAS, Oracle Analytics Cloud, OAC, RPD, dashboards, data quality dashboards, SQL, Oracle EBS, inventory analytics, Section 508, public trust, Fairfax VA, Northern Virginia, hybrid