DMO Data Analyst

About the Role:

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.

About You:

• 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.

Primary Location: Ability to work fully onsite at posted location(s).

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.

Our Commitment to Diversity:

Columbia Bank is an equal opportunity and affirmative action employer committed to employing, engaging, and developing a diverse workforce. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, age, sexual orientation, gender identity, gender expression, protected veteran status, disability, or any other applicable protected status or characteristics. If you require an accommodation to complete the application or interview(s), please let us know by email: careers@columbiabank.com.

To Staffing and Recruiting Agencies:

Our posted job opportunities are only intended for individuals seeking employment at Columbia Bank. Columbia Bank does not accept unsolicited resumes or applications from agencies and Columbia Bank will not be responsible for any fees related to unsolicited resume submissions. Staffing and recruiting agencies are not authorized to submit profiles, applications, or resumes to this site or to any Columbia Bank employee and any such submissions will be considered unsolicited unless requested directly by a member of the Talent Acquisition team.