Data & Reporting Analyst

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.

Education

Experience

• 2-6 years - of related business experience with emphasis in banking, information systems controls, and/or data analysis/management. (Required)

Skills

• 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).
• Experience with reporting packages (Business Objects etc), databases (SQL etc), and programming (XML, Javascript, or ETL frameworks) preferred.
• 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.

Travel Requirements

• Occasional

The pay range for this role is $80,500 to $86,500.

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