System Analyst - Oracle ERP

Job Description:

This position can be remote or hybrid work model based in Bend, OR, Boise, ID, Omaha, NE, Sioux Falls, SD and Great West Center in Billings, MT.

What’s Important to You

We know your career is just one aspect of a meaningful, complex, and demanding life. That’s why we designed our compensation and benefits package to provide employees and their families with as much choice as possible.

• 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.
• The health and happiness of the places we call home matter to us. Learn a little more about what we do for the communities we serve and why we want YOU to be a part of it.

We encourage you to apply. Reach for what you want and tell us why your work ethic and willingness to learn make you a natural fit for #TeamFirstInterstate.

SUMMARY

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).

ESSENTIAL DUTIES & RESPONSIBILITIES:

System Administration:

• 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

System Development:

• 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.

User Support and Training:

• 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

Project Subject Matter Expert:

• 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

Data Management:

• 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

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

EDUCATION and/or EXPERIENCE

Required:

• 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

Preferred:

• 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).

OTHER SKILLS & REQUIREMENTS

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.

LANGUAGE SKILLS

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.

MATHEMATICAL SKILLS

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.

REASONING ABILITY

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.

PHYSICAL DEMANDS

While performing the duties of this job, the employee is regularly required to walk and talk or hear. The employee frequently is required to stand and sit. The employee is occasionally required to use hands to finger, handle, or feel; reach with hands and arms; and stoop, kneel, crouch, or crawl. The employee must frequently lift and/or move up to 50 pounds. Specific vision abilities required by this job include close vision.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the work environment is usually moderate.