Oracle OTBI Consultant / BI Publisher Reports Developer
Staffxpert LLC
Position: Oracle OTBI Consultant / BI Publisher Reports Developer
Location: Remote + Travel
Travel: 2 consecutive weeks onsite at the client warehouse every month until project completion
Position Summary
STAFFXPERT is seeking an experienced Oracle OTBI Consultant / BI Publisher Reports Developer with strong hands-on experience in Oracle Fusion Cloud ERP, OTBI, BI Publisher, XML Publisher, Oracle SQL, PL/SQL, and Oracle EBS R12 .
The consultant will design, develop, enhance, optimize, and support enterprise reporting solutions across Oracle Fusion Cloud ERP and EBS R12 , with a strong focus on GL, AP, AR, Procurement, reporting security, SQL/PLSQL development, and production support .
Key Responsibilities
- Develop and maintain reports using Oracle Fusion OTBI and BI Publisher .
- Design and develop BI Publisher/XML Publisher reports and templates .
- Build reporting solutions across GL, AP, AR, Procurement , and related Oracle ERP modules.
- Develop and optimize complex Oracle SQL queries for reporting and data extraction.
- Perform SQL/database performance tuning .
- Develop and maintain PL/SQL packages, procedures, functions, and triggers .
- Support database objects/packages utilized by Oracle Integration Cloud (OIC) interfaces.
- Develop and maintain reporting solutions within Oracle EBS R12 .
- Work with Fusion Analytics Warehouse (FAW) when applicable.
- Configure and support Fusion reporting security , including roles and data access sets.
- Troubleshoot reporting, SQL, PL/SQL, and production issues.
- Implement data validation, exception handling, and data-integrity controls.
- Gather requirements from functional/business teams and translate them into technical reporting solutions.
- Prepare technical documentation and provide ongoing production support.
- Collaborate with functional consultants, developers, business stakeholders, and project teams.
Required Technical Skills
Oracle Reporting
- Oracle Fusion Cloud ERP Reporting
- OTBI Mandatory
- BI Publisher Mandatory
- XML Publisher
- Fusion Analytics Warehouse (FAW)
Database Development
- Oracle SQL Strong
- Oracle PL/SQL Strong
- Complex SQL queries
- SQL optimization/performance tuning
- PL/SQL Packages
- Procedures
- Functions
- Triggers
Oracle ERP
- Oracle Fusion Cloud ERP
- Oracle EBS R12
- General Ledger ( GL )
- Accounts Payable ( AP )
- Accounts Receivable ( AR )
- Procurement
Security & Integration
- Fusion Reporting Security
- Roles and Data Access Sets
- Oracle Integration Cloud ( OIC )
- Database packages supporting OIC interfaces
- Data validation and exception handling
Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Oracle OTBI Consultant / BI Publisher Reports Developer in Virginia vacancy
$105.1k - $231.1k
...Senior HCM Analytics & BI DeveloperJob... ...HCM Analytics & BI Developer to support a large... ...initiative deploying Oracle Fusion Cloud HCM... ..., dashboards, and reporting solutions that... ...Responsibilities:Develop OTBI analyses and... ...Analytics Cloud or BI Publisher certification....OTBIContract workWork experience placementImmediate startRemote workFlexible hours- ...Job Description Job Title: Oracle HCM Functional/Technical Consultant Location: Hybrid Work Model Reporting to Vienna, VA Pay Rate:... ...recurring automated audits using OTBI, BI Publisher, and other reporting tools... ...control breaches • Develop dashboards and reporting...OTBIContract work
System One
Vienna, VA23 days ago - ...Tableau Developer Location: Reston, VA Duration: 12+ Months (With further... ...) Notes: Senior BI developer role Must have expertise in reporting, dashboarding and visualization with... ...Tableau Must have SQL experience - Oracle(Desired)/Postgres/Redshift etc......Suggested
Samprasoft
Reston, VA20 hours ago - ...and consumer. Join rockITdata as a BI / Dashboard Developer supporting one of the nation's largest... ...you'll develop interactive dashboards, reports, and data visualizations that provide... ...Experience with Azure, AWS, SQL Server, Oracle, PostgreSQL, Snowflake, or similar...SuggestedFull time
rockITdata
Arlington, VA6 days ago - ...Title: Senior Power BI Developer We are KBR When you become part of our KBR team, your... ...of enterprise business intelligence and reporting solutions. This role serves as a... ...tuning skills. Experience working with Oracle and Microsoft SQL Server databases. Experience...SuggestedFull timeTemporary workLocal areaRelocation packageFlexible hours
KBR
Chantilly, Loudoun County, VAmore than 2 months ago - ..., VALooking for Agentic AI Engineer / AI Developer with Business Intelligence & ReportingDescription... ...making through business intelligence and reporting solutions. Responsibilities include... ...and reports using tools such as Power BI, Tableau, or similar BI platforms.[KN5.1]...
- ...Business Systems Inc. is a quickly developing worldwide System Integrator,... ...Data Warehousing, SharePoint Consulting and IT Infrastructure. Our... ...Job Description Job Title: Reports Developer Location: Fairfax-... ...more business intelligence (BI) reporting tools, including SQL...Contract workLocal areaRemote workWorldwideFlexible hours
- ...GCyber is seeking a BI Developer / Dashboard Developer to transform mission and operational data into clear, trusted, role-aware dashboards... ...and leaders. You will build data models, visualizations, reports, metrics, and interactive experiences that help users understand...
GCyber
Arlington, VA1 day ago - ...Translate Business Needs into BI Solutions Turn stakeholder... ...High Quality BI Products Develop analytical products aligned to... ...such as dashboards and reports to enable stakeholders to make... ...Platform partners External consultants (where applicable) Essential...Local area
MAXIMUS
McLean, VA4 days ago - ...Reporting Analyst Oracle Health Government Services is seeking a skilled Reporting Analyst to join our mission-driven organization. The Reporting... ...Manager, JIRA, Data Management, CGS Analytics, Power BI, Apex) to ensure reporting updates align with deployment milestones...Contract workTemporary workWork at officeFlexible hours
Hackajob
Arlington, VA2 days ago - ...Data Warehouse/BI Developer Supplement division staff by executing existing metric procedures for statutory and ad hoc reporting as well as data discrepancy assessment and resolution. Develop?end-to-end automation framework and documentation to load data and...Work experience placement
3B Staffing LLC
Richmond, VA4 days ago $89.6k - $194k
Business Intelligence Reports Developer Mid-Level TS/SCI with Poly REQUIRED Position Description... ...the U.S. Intelligence Community. The BI/Digital Reporting Specialist is an... ...technical guidance and mentorship to junior consultants in BI best practices. . Engage with...Local areaChantilly, Loudoun County, VAa month ago- ...can shape data strategy, deliver trusted reporting, and partner with senior stakeholders to... ...delivery. • Create and enhance Power BI dashboards and semantic models, with attention... ...Python skills, with proven experience developing production solutions on a cloud-based data...For contractors
Robert Half
Reston, VA15 days ago - ...Senior ERP Developer JOB-10047594 Anticipated... ..., environmental, and consulting solutions firm, based... ...ERP solutions within Oracle E-Business Suite... ...customizations, integrations, reporting, and operational... ...& Analytics BI Publisher OTBI XML Publisher Oracle...OTBIFull timeContract workLocal area
- ...Job Description Job Description Oracle Cloud EPM Consultant Hybrid Vienna, VA Pay Rate: $50/hr.... .../PBCS, Essbase, PCM, ARCS, Narrative Reporting, Reporting, EDM). Build and maintain... ...using Essbase, Groovy, and MDX. Develop and support data integrations using Data...Contract workFor contractorsImmediate start
System One
Merrifield, VA23 days ago - ...Oracle EPM Cloud Consultant Vienna, VA – hybrid (3 days a week onsite) Pay Rate: Open to Both C2... .../PBCS, Essbase, PCM, ARCS, Narrative Reporting, Reporting, EDM). • Build and maintain... ...using Essbase, Groovy, and MDX. • Develop and support data integrations using...Contract workTemporary workFor contractorsLocal areaImmediate start3 days per week
System One
Vienna, VA16 days ago - ...SQL BI Developer **Onsite in Richmond, VA Tuesday/Wednesday; Remote Monday, Thursday, Friday** Scope: Team is seeking an experienced... .../Tableau Development Support - Create new or enhance existing reports to meet business needs defined within the quarterly projects....Remote workMonday to Friday
Software Technology Inc
Richmond, VA4 days ago - ...Description We are looking for a Senior Power BI Developer to develop and build a capacity... ...a strategy, technology, and management consulting firm, founded in 1992, and located in Reston... ...the solutions via queries, dashboards, reports and advanced visualizations that align...Full timeFlexible hours
SiloSmashers
Arlington, VA12 days ago - ...We are seeking an experienced Power BI Developer to design, build, and maintain high-impact reporting and analytics solutions. You will work closely with cross-functional teams to transform complex data into actionable dashboards and actionable business insights....Local areaRemote work
Stellar Professionals
Richmond, VA2 days ago $40 - $80 per hour
...Job Title: Power BI Developer (Hybrid) Duration (Contract): 12 Months Client Location: Richmond, VA 23219 Location Preference... ..., you will design, develop, and maintain enterprise reporting and analytics solutions that enable business users to make informed...Hourly payContract workSmart IMS Inc
Richmond, VA2 days ago- Power BI Developer The State Corporation Commission's (SCC) Enterprise Technology Services ("ETS") Division seeks a contract Power BI Developer to design, build, and maintain reporting and analytics solutions supporting business divisions across the agency. This...Full timeContract work
Akaasa Technologies
Virginia1 day ago - ...Description Description: We are looking for an experienced Power BI Developer to join our team. This is a remote-friendly role based in... ...data sources, developing queries and creating PowerBI reports and dashboards. These reports should deliver actionable insights...Remote work
DCS Corp
Alexandria, VA12 days ago - VDOT Senior Power BI DeveloperLocation: 1401 E. Broad St. Richmond... ...is seeking a Power BI Developer with strong business analysis... ...creating visualizations and reports for requested projects.• Design... ..., updating data sources, and publishing to on-prem and cloud report servers...For contractorsWork at officeLocal area2 days per week3 days per week
$49 - $69 per hour
...Job Description Job Description Job Title : SCC - Power BI Developer Work Type: Hybrid Location: Richmond, VA Salary:... ...Power BI Developer to design, develop, maintain, and enhance reporting and analytics solutions supporting business divisions and...Hourly payFull timeContract workLocal areaTOMORROW HIRE
Richmond, VA3 days ago- ...Job Title: Oracle PL/ SQL Developer / Developer DBA Locations: McLean, VA Type: Full-Time... ...to support application functionality, reporting, system integrations, and business operations... ...intelligence platforms such as Power BI, Tableau, or Amazon QuickSight....Full time
Rishabh RPO
McLean, VA2 days ago $90k - $160k
...Engineering is seeking a cleared Senior Oracle Database and Data Integration... ...enterprise applications. Develop and maintain PL/SQL procedures, schemas... ...and application users. Support reporting and data visualization using Oracle BI, Power BI, Tableau, or comparable...Contract workRemote workAltus
Arlington, VA3 days ago- BI Developer / Data Analyst ProSidian is a Management And Operations Consulting Services firm that focuses on providing value to clients through tailored solutions based... ...role-based analytics solutions (dashboards, reports, data products) that support executive, managerial...Full timeContract workH1bWork at officeFlexible hours
- SAP Business Intelligence Consultant Job Summary: Genesis Consulting has... ...SAP technology to configure, develop, deliver and support applications... ...for their needs. The SAP BI Consultant will work with clients... ..., conversion programs, reports, and enhancements Develop and...Immediate start
- ...remote position. McBride Consulting has an exciting opportunity for an Oracle CLM Technical Consultant to develop, customize, and maintain... ...SQL, integration APIs, and reporting tools within Oracle ERP... ...generation architectures using BI Publisher and Oracle Analytics ....Contract workRemote work
McBride
Vienna, VA23 days ago - ...with future considerations for Oracle Cloud Infrastructure (OCI) as... ...will be a self-sufficient developer capable of designing, building... ...customizations, interfaces, reports, conversions, and extensions... ...Interface, Integration Broker, SQR, BI Publisher/XML Publisher, and SQL....
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Oracle OTBI Consultant / BI Publisher Reports Developer. Be the first to apply!
