Job Type: Full-time, Remote
Description: Optimized Technical Solutions (OTS) is currently searching for a qualified Oracle Fusion Finance Architect with a financial background to join our industry-leading, Oracle Cloud computing team and provide support.
This position will be remote. The selected Oracle Fusion Finance will be responsible for but not limited to the following:
- Requesting customize financial dashboards for budget tracking, encumbrance monitoring, and expense approvals for reports, dashboards, and workflows using Oracle BI Publisher, OTBI, and FBDI.
- Define and configure financial modules such as General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA), Cash Management, and Tax Management. Align system architecture with financial reporting, consolidation, and compliance requirements.
- Expertise in writing complex reports, working with APTP (Accounts Payable, Treasury, and Procurement) tables, developing dashboards, and troubleshooting advanced technical and functional issues beyond the scope of a Business Analyst.
Requirements
- Candidate must have a bachelor's degree or an additional 8 years of experience in lieu of a degree.
- Candidate must be a U.S. citizen.
- Knowledge and understanding of all aspects of database tuning: software configuration, memory usage, data access, data manipulation, SQL, and physical storage
- Experience in developing complex financial reports, dashboards, and data extracts.
- Ability to provide accurate and realistic effort estimates, commit and deliver accordingly.
- Ability to work productively in a team environment and participate as a positive and cooperative team member.
- Strong verbal, written, organizational and documentation skills.
Desired Knowledge, Skills, Abilities - Must have Senior level experience of Oracle Cloud System Development
- Sr level experience in coding capabilities and a deep financial background
- 8+ years of experience in Oracle Fusion Financials development.
- Experience around managing hierarchies' approval groups, rules on finance.
- Organization structures, they are called financial reporting structures or structures. Chart of accounts, approval groups, creating value sets (all ex of financial reporting structures)
- Need to be able to help with closing periods and troubleshooting issues during closing periods between GL and projects and grants.
- Write and troubleshoot complex financial reports, resolve discrepancies in encumbrances and funds available, year end carry forwards, year in period close and ensure financial workflows function smoothly.
- Should have strong understanding of Oracle Integration Cloud (OIC) components & capabilities including all major OIC adapters and different orchestration integration patterns
- Strong expertise in PL/SQL, APTP table structures, BI Publisher, OTBI, and FBDI.
- Strong troubleshooting skills for both functional and technical finance-related issues.
- Ability to write and debug code to resolve complex financial module problems.
- Know about integration with web services and APIs - Strong in experience in API
- In-depth knowledge and experience SQL, PL/SQL, J-Query, HTML, and java Script
Work Environment Office environment. Requires ability to provide clear, concise, accurate and timely communication, both verbally and in writing (100%). Requires ability to interact professionally with co-workers, management, and client (100%). Occasional business travel may be required. Only requested and approved expenses will be covered by OTS.
EEO Statement OTS is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity/Affirmative Action-Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or protected veteran status. U.S. Citizenship is required for most positions.