DMO Data Analyst

Columbia Bank•Lake Oswego, OR

5d•Onsite

About The Position

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.

Requirements

Bachelor’s degree in Business, Accounting, Finance, Statistics, or a related field, or equivalent experience in data analysis or business intelligence.
2-4 years of related business experience with emphasis in banking, information systems controls, and/or data analysis/management.
Experience using SQL Server Management Studio (SSMS), Structured Query Language (SQL), and/or Snowflake.
Experience with business intelligence tools & PowerBI.

Nice To Haves

Develop and prepare recurring loan portfolio reports and dashboards as well as ad hoc credit analysis or reports as requested by management.
Experience with Data Reporting & Data Quality Monitoring such as Adhoc and Regulatory Reporting.
Experience with Power Apps, Informatica, SQL Server Reporting Services (SSRS) etc.
Experience within a financial services industry.

Responsibilities

Develop and prepare recurring loan portfolio reports and dashboards as well as ad hoc credit analysis or reports as requested by management.
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.
Consult with managers and possibly executives in the use of analytical and reporting tools to develop effective cost, quality, operational and customer satisfaction outcomes.
Act as a liaison to collaborate with other operating groups to resolve problems or make recommendations for program/process changes.
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.
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.

Benefits

Comprehensive healthcare coverage (medical, dental, and vision plans)
401(k)-retirement savings plan with employer match for qualifying associate contributions
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
Paid vacation
Sick days
Volunteer days
Holidays