Job Title: Data Scientist / Business Intelligence Analyst
Location: San Diego, CA
Overview:
Rivet Operations Company is seeking a highly skilled Data Scientist to support Business Intelligence (BI), data warehousing, reporting, and Business Objects Enterprise (BOE) operations for Fleet Readiness Center Southwest (FRC SW). This position plays a key role in data modeling, dashboard development, testing, documentation, and system optimization in support of enterprise reporting and analytics.
Responsibilities:
Business Intelligence & Data Modeling
• Assess and optimize the BI environment to support information discovery and cross‑FRC integration.
• Develop, test, and deploy interactive data dashboards using performance metrics.
• Deliver as‑built technical architecture and a comprehensive Technical Design Document (TDD).
• Analyze business processes and develop logical/physical data models.
• Identify data elements, metadata, and data sources to support reporting requirements.
BOE / Data Warehouse Support
• Maintain day‑to‑day operations of BOE, Corporate Reporting System (CRS), and related BI systems.
• Develop technical specifications for converting Discoverer/Oracle reports to BOE.
• Collaborate with data modelers, ETL teams, and developers to ensure accurate data integration.
• Create Universes, reports, charts, and coordinated changes with Universe Designers.
Conduct SQL‑based analysis to troubleshoot data issues and support lifecycle documentation.
Functional SME & User Support
• Produce System Design Documents and maintain BOE security access.
• Facilitate Enterprise User Groups and maintain Report User Group (RUG) priority lists.
• Train users in BOE ad‑hoc reporting and provide enterprise‑wide customer support.
• Maintain data dictionary of 6,000+ BOE reporting fields.
• Attend and document OneNDMS requirements meetings; deliver reports within one business day.
System Administration
• Monitor BOE application servers and cluster environments.
• Troubleshoot BOE, IBM HTTP IHS, and proxy server issues.
• Document installation and patching processes.
Testing & Quality Assurance
• Develop Project Plans, Test Plans, and Implementation Plans.
• Establish test criteria and participate in system acceptance testing.
• Develop and execute integration test protocols for configuration changes and updates.
• Analyze test results, initiate corrective actions, and update technical documentation.
Development & Troubleshooting
• Develop efficient BOE Universes, dashboards, reports, and regression test scripts.
• Perform cross‑database data analysis to identify and resolve data anomalies.
• Update ETL mapping specifications and assist with stored procedure revisions.
• Provide LOE estimates, schedule inputs, and ensure compliance with government standards.