System Analyst – Oracle ERP/EPBCS

This position may be located at any of the offices within First Interstate Banks fourteen state footprint, including Arizona, Colorado, Idaho, Iowa, Kansas, Minnesota, Missouri, Montana, Nebraska, North Dakota, Oregon, South Dakota, Washington and Wyoming.

Whats Important to You

We know your career is just one aspect of a meaningful, complex, and demanding life. Thats 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 organizations 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:

• Design and implement Oracle EPM solutions, including Hyperion Planning, Essbase, and Financial Management
• Develop and maintain EPM application models, including data integrations, metadata management, security, and performance tuning
• 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
• 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 EPM and ERP technologies and features and provide recommendations for process improvements and automation
• Provide support and troubleshoot issues for EPM and ERP applications

System Development:

• Collaborate with business stakeholders to gather requirements and translate them into functional specifications
• Develop reports and dashboards using EPM reporting tools, such as Financial Reporting, Smart View, and OBIEE
• 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 and II 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:

• Bachelors 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
• Two or more years experience working with Oracle ERP and/or EPBCS 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 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 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.

COMPENSATION & BENEFITS

We offer a competitive total compensation package including base salary and benefits. The anticipated pay range for this position is $89,077 to $146,976 per year (in CO & WA), and depends on a variety of non-discriminatory factors including, but not limited to, job-related knowledge, skills and experience, education, and geographic location. Additionally, this role is eligible to receive annual discretionary cash bonuses. Benefits available for this position include, but are not limited to, medical, dental, vision, short-term and long-term disability benefits and life insurance, flexible spending accounts, health savings account, employee assistance program, 401(k), Paid Time Off (new hires accrue at .069 per hours worked which equates to approximately 18 days per year inclusive of paid sick time) and up to 11 paid Federal holidays. Please note this information is provided for those hired in Colorado and Washington only, and this role is open to candidates outside of Colorado and Washington with compensation that aligns with your location. For more information regarding our benefits, please visit https://www.firstinterstatebank.com/company/about/employee-benefits.php.

If you are a current FIB employee, please apply through the Career Worklet in the Employee Portal.