Technical Analyst IV

BOK Financial•Tulsa, OK

3d•Hybrid

About The Position

The Technical Analyst IV role performs complex analysis on financial data ensuring integrity, confidentiality, and full regulatory compliance. Acts as a conduit for bridging IT with the line of business. Possesses excellent written and oral communication skills. Excels in the ability to thoroughly understand business requirements and implement best-in-class technical solutions.

Requirements

Bachelor’s degree in Information Technology, Computer Science, Computer Engineering, Electronics Engineering, or a related field, or foreign equivalent and 5 years relevant experience in Assistant Manager – IT, Technology Analyst, IT Analyst, Senior Consultant, or closely related position.
5 years of experience with Oracle Fusion ERP, including modules such as General Ledger (GL), Project Accounting (PA), Fixed Assets (FA), Accounts Payable (AP), Expenses, and Human Capital Management (HCM)
5 years of experience with Oracle business intelligence (BIP, OTBI, OBIEE, OAC, and Smart View), bursting, optimizing BIP queries to create dashboards, infolets, reports, and data for integrations.
5 years of experience with software integration, system integration, and technology used: Oracle Cloud Infrastructure (OCI), Oracle Integration Cloud and Oracle’s REST APIs, SOAP UI, Postman products for API utilization, and integration with both internal and external applications
5 years of experience with Oracle Integration Cloud (OIC) development, including creating and managing integrations, connections, lookups, libraries, packages, adapters, and monitoring integration processes, as well as migration and testing in this platform
5 years of experience with complex joins, subqueries, temporary tables, window functions and indexes and query optimization for performance tuning as well as dynamic SQL and stored procedures along with transactional controls
5 years of experience with IT and IS standards and concepts: Software as a Service (SaaS), Integrations and Middleware, Analytics, Agile and Waterfall Project Methodologies.
Ability to confidently utilize REST APIs, SOAP web services, Postman, SOAP UI, RTF templates, Excel, and e-text templates as needed for data manipulation, solutioning, and reporting.

Responsibilities

Design, develop, and maintain OIC inbound/outbound integrations for Oracle Cloud Applications
Create interactive dashboards and infolets for data visibility and process improvements
Build Data Models, OTBI Reports, and BIP Reports to meet data requirements for audit, regulatory, controllers, and management
Performs functional tasks and configurations for Oracle Cloud ERP and HCM Application modules
Optimize complex SQL BIP and bursting queries to enhance reporting performance and system efficiency
Conduct data cleansing and robust data analysis
Thoroughly understand Disaster Recovery processes
Utilization of Agile and/or Waterfall Project Methodology for managing workload, prioritizations, and understanding deliverable expectations
Develop and maintain application documentation
Duties will require “on-call” support during non-business hours.