Job Title:
Credit Portfolio Analyst II

Location:
CityScape

What you'll do:
The Credit Portfolio Analyst II works in Credit Administration and supports the institution's LFI aligned risk, credit, and data ecosystem by managing analytical workflows, enhancing system functionality, and contributing to scalable and controlled processes appropriate for a Category IV bank. This role places strong emphasis on Python, SQL for troubleshooting data issues, validating results, and understanding data transformation logic. This role also requires familiarity working with API's and integrated data sources to support analytics requests that span multiple systems and require data integration or automation. Critical to success in this position is the ability to display a high level of independent problem solving, prioritization, adaptability, on-time implementation and the ability to support diverse projects/problems.

• Responsible for supporting the Credit Portfolio leadership in creating or using various database objects, reporting tools, or other Bank approved technology in the execution of regular duties and proposing improvements to processes, gains approval, documents and implements upgrades. Partner with IT and Business Data Governance as required.
• Complete assigned projects, which may be individual or team projects and include acquiring new data sources, defining and documenting transformations required to load, writing load scripts and testing. Independently frame requirements for moderately complex data and business processes. Develop reporting dashboards, monitoring concentration limits, KRIs, RCSA or other projects.
• Apply technical expertise and software knowledge to address complex projects and manage a pipeline of data, reporting, and process related projects, identifying and elevating road blocks and executing within designated time frames.
• Participate in the development of relevant policies, procedures, methodologies and training and collaborate with Credit Administration group. Collaborate cross functionally on projects.

What you'll need:

• 3+ years of related experience in Accounting, Finance, Economics or similar field

• Bachelor's degree in related field required.
• Intermediate knowledge of general banking operations, including deposit operations, loan administration, treasury management and/or other commercial banking products and services.
• Intermediate knowledge of applicable regulatory and legal compliance obligations, rules and regulations, industry standards and practices.
• Intermediate to advanced experience in application testing skills to be able to create test cases and for documentation.
• Intermediate to advanced MS Excel skills and the ability to create pivot tables, perform XLOOKUPs, use conditional logic, compare data, and banking applications.
• Intermediate to advanced Python experience. Specifically relating to data analytics with a solid understanding of common data science libraries. Experience developing Python-based solutions in Databricks and Microsoft Fabric environments is a plus.
• Intermediate to advanced SQL experience with knowledge of advanced syntax (window functions, common table expressions, etc) and an understanding of data structures.
• Intermediate ability to independently problem solve, adapt to changing priorities, act with a sense of urgency, on-time delivery and support diverse projects.
• Experience navigating and searching codebases in version control systems to support data troubleshooting and data quality validation.
• Intermediate speaking and writing communication skills.

Benefits you'll love:
We offer all the important things you'd want - like competitive salaries, an ownership stake in the company, medical and dental insurance, time off, a great 401k matching program, tuition assistance program, an employee volunteer program, and a wellness program. In addition, you'll have the opportunity to bolster your business knowledge, learning the ins and outs of how successful companies operate and manage their finances, giving you invaluable hands-on experience to help grow your career!