System Analyst - Oracle ERP

First Interstate BancSystem, Inc.•Sioux Falls, SD

55d•Hybrid

About The Position

Develop, implement, enhance, document, and support the organization's most complex, multifaceted software applications, critical to the day-to-day functions of the bank. This position is responsible for serving as the primary contact between the vendor and business unit and will report to various levels of management across multiple divisions of the organization on the status of the systems, including any outstanding issues and successes. Primary system responsibilities include Oracle Enterprise Resource Planning (ERP), Oracle Enterprise Planning and Budgeting (EPBCS) and. Enterprise Data Management (EDM).

Requirements

Bachelor's degree (B.A.) from a four-year college or university and five or more (5+) years' related experience and/or training; or equivalent combination of education and experience
Four or more years' experience working with Oracle ERP in a banking/financial services environment required
Strong understanding of database design and integration
Experience with bank applications and software administration experience
Experience with Java (Java script, Groovy)
SQL Programming experience and understanding of database concepts
Excellent communication skills, both written and oral.
Strong conflict resolution skills and the ability to remain objective and professional at all times.
Must be a self-starter
Ability to work independently or with a team
Ability to properly prioritize workload as well as the workload of subordinates and remain adaptable under pressure
Must have strong organizational and analytical skills and possess a solid balance of technical and business knowledge.
Must possess strong problem-solving skills and possess skill mastery and aptitude to easily take on new applications outside of area of expertise.
Must have the ability to provide oversight and guidance to the System Administration team on applications they support.
Ability to read, analyze, and interpret common scientific and technical journals, financial reports, and legal documents.
Ability to respond to common inquiries of complaints of customers, regulatory agencies, or members of the business community.
Ability to write speeches and articles for publication that conform to prescribed style and format.
Ability to effectively present information to top management, public groups, and/or boards of directors.
Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals.
Ability to compute rate, ratio, and percent and to draw and interpret bar graphs.
Ability to define problems, collect data, establish facts, and draw valid conclusions.
Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.

Nice To Haves

Solid understanding of bank finance
Understanding of PowerShell
Experience administrating EPM applications and environments
Oracle ERP and/or EPM certifications
Experience with Enterprise Performance Reporting (EPRCS) and Financial Consolidations and Close (FCCS).

Responsibilities

Monitor ERP system health and performance, ensuring high availability and reliability
Ensure the reliability, performance, and security of our Oracle ERP environment.
Manage integrations between Oracle ERP and other enterprise systems (e.g., CRM, HRIS, financial platforms)
Research, test, schedule and deploy upgrades and releases while adhering to documented change management process and procedures
Create and maintain system documentation including desktop procedures, end user procedures, system diagrams, Service Level Agreements (SLAs), Business Continuity Planning (BCPs), disaster recovery plans, user access audits and test plans
Analyze, evaluate, and recommend system changes, configuration and enhancements based on business requirements of critical processes and applications and expertise related to system construction and areas of efficiency
Independently make decisions based on mastery knowledge level of supported applications and related business processes
Lead meetings and deliver presentations to small and large groups of various levels of management across the organization
Gather, interpret, and report system performance issues to vendor, business unit(s) and management and document performance trends
Establish performance measures, goals, and objectives for the software based on the business requirements
Implement and maintain security protocols, user roles, and access controls
Develop, test, and execute scripts to translate business requirements into system enhancements.
Access relevant system servers and databases to develop and maintain business requirements.
Stay current with new ERP and EPM technologies and features and provide recommendations for process improvements and automation.
Provide support and troubleshoot issues for ERP and EPM applications
Provide technical guidance and training to internal teams and end-users
Work closely with Oracle support and vendors to resolve issues and implement best
Collaborate with business stakeholders to gather requirements and translate them into functional specifications
Develop reports and dashboards using ERP reporting tools, such as OTBI
Ensure data quality, security, and privacy through data validation and access controls
Develop and maintain workflows, automation, and data integrations using platform-specific tools and APIs
Customize and integrate third-party applications and services into existing solutions.
Provide tier two help desk assistance to issues escalated from First Support on critical applications
Provide subject matter expertise to assist in the development and delivery of training for end users
Participate in system testing, user acceptance testing, and training
Create user documentation, training materials, like how-to guides to enable self-service
Assist System Administrator I, II and III team members with the process of converting business requirements into system requirements as needed
Lead medium to large project efforts and independently support project work
Understand in-depth, the business requirements of critical applications while differentiating requirement vs. process. Convert business requirements into system requirements and maintain ongoing communication with the vendor
Understand, monitor, and maintain data integrations with source systems at an in-depth level to ensure accurate and timely processing of financial and/or critical data
Develop, maintain, and monitor data validation routines and understand the business impact of data exceptions or delays
Develop, maintain, schedule, and monitor reports for end users
Utilize SQL Developer to read and update PL/SQL scripts currently running on the EPM Automate server

Benefits

Accrue and use your paid time off (PTO) immediately - no waiting period - plus paid federal holidays in addition to PTO.
To assist employees in paying down student loan debt, we will make monthly payments of $100 directly to eligible loan service providers on behalf of our employees until the loan is paid off.
Our retirement plan is one of the best in the region, including a 6% employer match on your 401(k). Employees (including temporary) scheduled to work 20 or more hours per week are automatically enrolled day one.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume