BI Analytics Developer: Oracle Cloud & OAS/OAC — Onsite/Hybrid

Spatial Front, Inc; Arlington (VA); Hybrid; USD 100,000 - 130,000; Full time

Job summary

Spatial Front, Inc. is seeking a BI Analytic Developer to advance modernization of enterprise analytics, focusing on Oracle Analytics Server (OAS) and Oracle Analytics Cloud (OAC), SQL reporting, and data structures for its federal government customers.

The role converts business requirements into technical BI solutions, designs semantic models, and migrates on-premises BI to the cloud, while collaborating with leadership, data engineers, and developers in an Agile/SAFe environment at Crystal

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field.
• 3+ years of hands-on BI, analytics, reporting, or data development experience in complex enterprise environments.
• Strong SQL skills and experience with Oracle databases, relational schemas, views, joins, aggregations, and complex enterprise data structures.
• Hands-on experience with Oracle Analytics Server (OAS) and Oracle Analytics Cloud (OAC), OBIEE, or related Oracle analytics technologies.
• Experience designing semantic models, subject areas, logical/physical data models, metadata layers, dimensional models, or star schemas.
• Experience troubleshooting report logic, performance, data discrepancies, and production BI issues through structured analysis and validation.
• Strong written and verbal communication skills and ability to collaborate with BI, data, application, infrastructure, and business teams.

Responsibilities

• Design, develop, enhance, and support reports, analyses, dashboards, and data visualizations using Oracle Analytics Server (OAS) and Oracle Analytics Cloud (OAC).
• Translate business and analytical requirements into technical BI solutions, including semantic models and dashboards.
• Design and maintain database views, schemas, reporting structures, metadata, and data relationships to support analytics.
• Develop and optimize SQL for reporting, data analysis, reconciliation, validation, and troubleshooting across Oracle databases and warehouse structures.
• Support modernization of on-prem BI and data warehouse to Oracle cloud analytics, including migration and validation of reports and dashboards.
• Analyze existing OAS and legacy BI content and recommend rationalization or migration to OAC while preserving business logic.
• Collaborate with data engineers and DBAs to understand source-to-target mappings, pipelines, transformations, and warehouse dependencies.
• Perform data validation and reconciliation between sources and BI outputs; investigate discrepancies and root-cause BI issues.
• Design analytics solutions for performance, scalability, usability, maintainability, and secure access.
• Participate in testing, defect resolution, migration, release, and change-management activities across environments.
• Create and maintain technical documentation including report specs, data mappings, and deployment procedures.
• Collaborate with BI leadership, Product Owners, analysts, data engineers, developers, and stakeholders in an Agile/SAFe environment.

Skills

Oracle Analytics Server (OAS)

Oracle Analytics Cloud (OAC)

SQL

BI Reporting

Data Visualization

Education

Bachelor's degree in Computer Science or related field

Tools

OBIEE

Oracle BI

Job description

Spatial Front, Inc. is seeking a BI Analytic Developer to advance modernization of enterprise analytics, focusing on Oracle Analytics Server (OAS) and Oracle Analytics Cloud (OAC), SQL reporting, and data structures for its federal government customers.

The role converts business requirements into technical BI solutions, designs semantic models, and migrates on-premises BI to the cloud, while collaborating with leadership, data engineers, and developers in an Agile/SAFe environment at Crystal