System Analyst – Oracle ERP/EPBCS
First Interstate Bank
If you are a current FIB employee, please apply through the Career Worklet in the Employee Portal. 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 reporti g 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… For full info follow application link. Our company is an equal opportunity employer. Employment here is based solely upon an individuals merit and qualifications directly related to the position. We do not discriminate on the basis of race, color, religion, national origin, ancestry, pregnancy status, sex, age, marital status, disability, medical condition, or any other characteristics protected by law. We make all reasonable accommodations to meet the obligations set forth under the Americans with Disabilities Act (ADA) and state disability laws.