DMO Data Analyst

Responsible for descriptive/predictive data analysis and reporting within a division, business unit, and/or department. Acquires, analyzes, interprets, and disseminates data set(s) to optimize or create processes, programs, and/or fiscal solutions for complex organizational challenges. Participates in projects to improve data quality and/or improve workflow, process, and procedure.

• Collaborate with business units throughout the organization to conduct comprehensive analysis and reporting using both structured and unstructured data. Effectively communicate findings through various reporting methods and provide recommendations as needed.
• Maintains detailed knowledge of department function(s) and in areas of workflow and system data management.
• May consult with managers and possibly executives in the use of analytical and reporting tools to develop effective cost, quality, operational and customer satisfaction outcomes. May act as a liaison to collaborate with other operating groups to resolve problems or make recommendations for program/process changes.
• May partner with Technology Advancement Group (TAG), external vendors, and business partners in the development of reporting capabilities and resolution of issues relating to reporting applications, tools and data.
• Demonstrates compliance with all bank regulations for assigned job function and applies to designated job responsibilities - knowledge may be gained through coursework and on-the-job training. Keeps up to date on regulation changes.
• Follows all Bank policies and procedures, compliance regulations, and completes all required annual or job-specific training.
• Maintain a working knowledge of Bank’s written policies and procedures regarding Bank Secrecy Act, Regulation CC, Regulation E, Bank Security and other regulations as applicable to this job description.
• May be asked to coach, mentor, or train others and teach coursework as subject matter expert.
• Actively learns, demonstrates, and fosters the Columbia corporate culture in all actions and words.
• Takes personal initiative and is a positive example for others to emulate.
• Embraces our vision to become “Business Bank of Choice”.
• May perform other duties as assigned.

• Bachelor’s degree in Business, Accounting, Finance, Statistics, or a related field, or equivalent experience in data analysis or business intelligence. (Required)
• 2-4 years of related business experience with emphasis in banking, information systems controls, and/or data analysis/management. (Required)
• Develop and prepare recurring loan portfolio reports and dashboards as well as ad hoc credit analysis or reports as requested by management. (Preferred)
• Experience using SQL Server Management Studio (SSMS), Structured Query Language (SQL), and/or Snowflake. (Required)
• Experience with business intelligence tools & PowerBI. (Required)
• Experience with Data Reporting & Data Quality Monitoring such as Adhoc and Regulatory Reporting. (Preferred)
• Experience with Power Apps, Informatica, SQL Server Reporting Services (SSRS) etc. (Preferred)
• Experience within a financial services industry. (Preferred).

The pay range for this role is $80,000.00 to $95,000.00.

The pay rate for the selected candidate is dependent upon a variety of non-discriminatory factors including, but not limited to, job-related knowledge, skills, and experience, education, and geographic location. The role may be eligible for performance-based incentive compensation, and those details will be provided during the recruitment process., 201 B Avenue Suite 100 Lake Oswego OR 97034

Our Benefits:

We are proud to offer a competitive total rewards package including base wages and comprehensive benefits.

We offer eligible associates comprehensive healthcare coverage (medical, dental, and vision plans), a 401(k)-retirement savings plan with employer match for qualifying associate contributions, an employee assistance program, life insurance, disability insurance, tuition assistance, mental health resources, identity theft protection, legal support, auto and home insurance, pet insurance, access to an online discount marketplace, and paid vacation, sick days, volunteer days, and holidays. Benefit eligibility begins the first day of the month following the date of hire for associates who are regularly scheduled to work at least thirty hours weekly.