Data & Reporting Analyst

Columbia Bank•Tigard, OR

22h•$80,500 - $86,500•Onsite

About The Position

Serves as subject matter expert 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 process, program, and/or fiscal solutions for moderately complex organizational challenges. Acquires primary and secondary data from varied sources and analyze data extracts and reports to identify trends and data points. Utilizes databases and information systems to research and identify areas for improvement and/or new products. Interprets data and makes recommendations. Establishes and utilizes key indicators and solutions for use by management and business unit associates via strategic and tactical analytics as shown in dashboards and data summaries. Maintains detailed knowledge of department function(s) and in areas of workflow and system data management. Prepares timely and accurate progress reports utilizing multiple databases and software applications, ensuring consistency, standardization and compliance. May consult with colleagues in the use of analytical and reporting tools to develop efficient cost, quality, operational and customer satisfaction outcomes aligned with the business priorities. May partner with Technology Advancement Group (TAG), external vendors, and business partners in the development of advanced/complex 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

2-6 years — of related business experience with emphasis in banking, information systems controls, and/or data analysis/management.
Intermediate knowledge of business analysis, business management data systems, IT risk management, project management and technical problem resolution.
Advanced data mining, performance metrics and reporting, vendor management, change management and report writing.
Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS, etc).
Superior attention to detail.
Ability to translate large and complex data sets into understandable conclusions and, where applicable, actionable solutions.
Demonstrated knowledge of banking products, systems, procedures, regulations, business acumen and ability to interpret data to make recommendations for improvements as necessary.
Ability to work with individuals and teams at all levels across the organization and with external company representatives and vendors.
Strong communication, interpersonal and influencing skills.
Technical expertise with automatic data collection and reporting systems, including capacity for program troubleshooting and system controls.

Nice To Haves

Experience with reporting packages (Business Objects etc), databases (SQL etc), and programming (XML, Javascript, or ETL frameworks) preferred.

Responsibilities

Acquires primary and secondary data from varied sources and analyze data extracts and reports to identify trends and data points.
Utilizes databases and information systems to research and identify areas for improvement and/or new products.
Interprets data and makes recommendations.
Establishes and utilizes key indicators and solutions for use by management and business unit associates via strategic and tactical analytics as shown in dashboards and data summaries.
Maintains detailed knowledge of department function(s) and in areas of workflow and system data management.
Prepares timely and accurate progress reports utilizing multiple databases and software applications, ensuring consistency, standardization and compliance.
May consult with colleagues in the use of analytical and reporting tools to develop efficient cost, quality, operational and customer satisfaction outcomes aligned with the business priorities.
May partner with Technology Advancement Group (TAG), external vendors, and business partners in the development of advanced/complex 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.

Benefits

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
paid vacation
sick days
volunteer days
holidays