Job description

Department: Internal Support Reports To: Software Engineering Manager Classification: Exempt About Rogue Credit Union : Rogue Credit Union is a member-owned, not-for-profit financial cooperative headquartered in the Rogue Valley located in beautiful southern Oregon. Providing services to our members in select Oregon, California and Idaho counties. We strive to make an impact in the communities we serve by living, giving, and supporting local. Our mission is to provide exceptional member experiences that build mutually beneficial relationships to create the most loyal members in the nation. Here at Rogue, we believe in having a culture of happy team members who feel supported, have the chance to grow their careers, and LOVE where they work! Role: The Senior Software Engineer will leverage expertise with PL/SQL and Python to design, develop, test and optimize database driven applications to augment Rogue's core banking platform (Fiserv DNA). Collaborate with business stakeholders, end-users and technical teams to understand business requirements and deliver elegant, scalable, member-centric solutions within committed timelines and budgetary constraints. Maintain involvement in the full Systems Development Life Cycle (SDLC). Assist with solutions architecture design, optimization, product evaluation and buy vs. build recommendations. Essential Functions & Responsibilities: E 50% Utilize PL/SQL, Python, and other technologies as needed to develop, document and maintain database driven applications, DBOs, APIs, scripts, libraries and tools to augment functionality of the Fiserv DNA Core-Banking platform, interface the core database layer with in-house or third-party applications, and develop batch processes, ETL and automation workflows related to core-facing business processes. E 25% Perform SQL profiling, query-tuning, implement database hints, suggest improvements to factor and simplify queries. Write custom SQL reports and queries to provide business intelligence to end-users. Troubleshoot/resolve issues with code, queries, stored procedures, functions. Evaluate pull/merge requests from other team-members. Create and maintain thorough documentation related to developed code, architecture and solution designs. E 20% Collaborate with analysts, project teams, end-users and leadership to comprehend business requirements and assess scope of work. Augment team competencies by providing guidance and subject matter expertise related to application, database and schema design. Lead efforts related to developing Oracle custom schemas, database-facing application architecture and optimization. N 5% Proactively performs other duties as needed or assigned. Knowledge and Skills: Experience 5+ years of back-end programming experience utilizing Oracle PL/SQL and Python 3 (or similar scripting language) or 5+ years of experience working with financial Core Banking platforms in a technical capacity. Expert working knowledge of Oracle PL/SQL, RDBMS fundamentals, database application design, SQL querying, tuning and optimization. Expert-level knowledge of Python or similar language, fundamental programming concepts, paradigms, frameworks, architecture and design patterns. Comprehensive understanding of SDLC, Agile software development concepts, CI/CD, change management, information security and best practices. Strong working knowledge of finance/banking industry, relevant lines of business and operations (deposits/loans, payments, cards, P2P, ACH, wire, GL, etc.). Education BS in Information Technology, Computer Science, related field OR equivalent work experience (5+ years) in Software Engineering. Interpersonal Skills Courtesy, tact, and diplomacy are essential elements of the job. Work involves much personal contact with others inside and/or outside the organization for purposes of giving or obtaining information, building relationships, or soliciting cooperation. Other Skills Excellent written/verbal communication skills, ability to work independently with minimal supervision, ability to independently troubleshoot/resolve complex issues across multiple technologies, excellent problem-solving, team collaboration, and time management skills. Willingness to learn new or additional programming languages and technologies as needed. Possess the ability to analyze and effectively troubleshoot technical problems. Must be able to deal well with ambiguity and exercise judgment in selecting methods, techniques and evaluation criteria for obtaining results. Work with management in providing departmental leadership and guidance in technical issues, introducing and implementing industry best practices. Must provide consistent high levels of service, quality and productivity, is resourceful and proactive in gathering information and sharing ideas. Must be highly productive, with the ability to automate systems and technologies to maximize efficiency and up time. Self-motivated and able to prioritize work, and reconcile competing schedules Physical Requirements Some lifting required (up to 30 pounds), continuous sitting, occasional standing and occasional walking. Finger dexterity while using computer. Occasional talking and hearing in person and on the telephone. Continuous clarity of vision at 20 inches or less and continuous clarity of vision at 20 feet or more. Work Environment This job is an exempt position that requires flexibility in scheduling tasks and projects. The employee must independently monitor hours and judge the time needed to be spent on applicable duties. Employee must be capable of adjusting to unpredictable schedules proactively. As a direct representative of the credit union, the employee must conduct and present themselves courteously and professionally. Exposed to potentially hazardous conditions, i.e., robbery. Travel to all credit union regions may be required. Disclaimer: Job descriptions are not intended, and should not be construed to be exhaustive lists of all responsibilities, skills, efforts, or working conditions associated with a job. They are intended to be accurate reflections of those principal job elements essential for making fair pay decisions about jobs. Note: Rogue Credit Union is a drug free workplace and requires a drug screening test within 48 hours of employment offer. Rogue Credit Union is an Equal Opportunity Employer and makes employment decisions without regard to race, color, national origin, religion, sex, age, disability, veteran status, or any other protected class. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process, or are limited in the ability or unable to access or use this online application process and need an alternative method, please call (541) 622-7295. This Job Description is not a complete statement of all duties and responsibilities comprising the position.

Requirements

Must-haves

Department: Internal Support
Reports To: Software Engineering Manager
Classification: Exempt
Proactively performs other duties as needed or assigned.
5+ years of back-end programming experience utilizing Oracle PL/SQL and Python 3 (or similar scripting language) or 5+ years of experience working with financial Core Banking platforms in a technical capacity.
BS in Information Technology, Computer Science, related field OR equivalent work experience (5+ years) in Software Engineering.
Interpersonal Skills
Other Skills
Physical Requirements
Work Environment

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpythonagileci/cd

Platform: adp-workforce-now
Effort: medium

Benefits

Benefits detected in the listing.

Vision