BI Analytic Developer

Jobtailor

Virginia (MN)

On-site

USD 110,000 - 140,000

Full time

3 days ago

Be an early applicant

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Jobtailor is seeking a seasoned BI/Analytics Developer to design and support Oracle Analytics Server (OAS) and Oracle Analytics Cloud (OAC) based reporting solutions in a DoD-friendly environment. You will translate business requirements into scalable analytics, develop complex SQL, and collaborate across BI, data engineering, and product teams.

Join a team that values data-driven decision making and modern cloud analytics migrations, with opportunities to optimize dimensional models and data

Qualifications

Bachelor's degree in a related field or equivalent experience.
3+ years of hands-on BI/analytics in complex enterprise environments.
Hands-on experience with Oracle Analytics Server (OAS) and Oracle Analytics Cloud (OAC).
Strong SQL skills with Oracle databases, schemas, views, joins, and data structures.
Experience with semantic models, star schemas, metadata layers, and dimensional modeling.
Experience modernizing or migrating BI to OCI/OAC or cloud analytics platforms.
Experience in secured federal or DoD environments is preferred.

Responsibilities

Design and develop BI solutions using OAS/OAC, including dashboards and data visualizations.
Translate requirements into technical BI solutions and reusable reporting components.
Develop and optimize SQL for reporting, validation, and troubleshooting.
Collaborate with data engineers and stakeholders in an Agile/SAFe environment.
Participate in testing, migration, and release activities.
Create and maintain technical documentation.

Skills

SQL Development

Agile/Safe Collaboration

Data Validation and Reconciliation

Strong Communication

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or related field

Tools

Oracle Analytics Server (OAS)

Oracle Analytics Cloud (OAC)

OBIEE

Oracle BI Publisher

PeopleSoft Query

Azure DevOps

Oracle Databases

Data Pipelines

Job description

Responsibilities

Design, develop, enhance, and support reports, analyses, dashboards, and data visualizations using OAS and OAC
Translate business and analytical requirements into technical BI solutions, including subject areas, semantic models, calculations, filters, prompts, KPIs, dashboards, and reusable reporting components
Design and maintain database views, schemas, reporting structures, metadata, and data relationships for enterprise analytics and self-service reporting
Develop and optimize SQL for reporting, data analysis, reconciliation, validation, and troubleshooting
Support migration of on-premises BI and data warehouse environments to Oracle cloud analytics
Assess, redesign, consolidate, rationalize, and migrate legacy BI content to OAC
Work with data engineers and database teams on mappings, pipelines, transformations, dimensional models, data marts, and warehouse dependencies
Perform data validation and reconciliation and investigate reporting and data-quality issues
Design analytics solutions for performance, scalability, usability, maintainability, and secure access
Participate in testing, defect resolution, migration, release, and change-management activities
Create and maintain technical documentation
Collaborate with BI leadership, Product Owners, analysts, data engineers, developers, and stakeholders in an Agile/SAFe environment
Perform other duties as assigned

Requirements

Must be a U.S. Citizen
Must have an active Secret security clearance
Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field; equivalent relevant experience may be considered
3+ years of hands-on business intelligence, analytics, reporting, or data development experience in complex enterprise environments
Hands-on experience with Oracle Analytics Server (OAS), Oracle Analytics Cloud (OAC), OBIEE, or related Oracle analytics technologies
Strong SQL skills and experience with Oracle databases, relational schemas, views, joins, aggregations, and complex enterprise data structures
Experience with 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 effectively with BI, data, application, infrastructure, and business teams
Experience modernizing or migrating enterprise BI, reporting, or data warehouse capabilities to OCI, OAC, or another cloud analytics platform is desired
Knowledge of ETL/ELT, data pipelines, transformations, orchestration, source-to-target mappings, data quality, and warehouse loading patterns is desired
Experience with Oracle BI semantic modeling, including RPD concepts, subject areas, logical business models, physical layers, calculations, hierarchies, and security is desired
Experience with data warehouse and dimensional modeling concepts is desired
PeopleSoft HCM reporting, analytics, queries, interfaces, or related HR data structures experience is a plus
Experience with BI Publisher, PeopleSoft Query, XML Publisher, or similar tools is a plus
Experience working in Agile or SAFe environments and using Azure DevOps or similar tools is desired
Experience in secured federal or DoD environments is preferred
Oracle Analytics, OCI, database, data engineering, or related BI/data certification is a plus

Core Competencies

Demonstrates expertise in designing and developing business intelligence solutions using Oracle Analytics Server (OAS) and Oracle Analytics Cloud (OAC), with strong SQL skills for data analysis and reporting. Proven ability to collaborate in Agile environments and effectively communicate with cross-functional teams to deliver high-quality analytics solutions.

Highest-signal resume keywords