What are the responsibilities and job description for the Business Intelligence Analyst (In office work required) position at Red Canoe Credit Union?
Red Canoe Credit Union hires passionate, knowledgeable, and dependable individuals who are committed to making a difference. As a not-for-profit financial institution owned by our members, we believe in the value of people over profit. If you’re looking for a place to start a rewarding career you can be proud of, then Red Canoe might be the place for you.
We’ve been a cooperative since 1937. That means any money we earn goes back to our members, not into the pockets of stockholders like a bank. For more than 80 years, we’ve held the traditions of credit unions near and dear to our hearts. We are not for profit, but for people.
Red Canoe Credit Union has 10 branches spread across Washington and Oregon. We even have members living in all 50 states. But Red Canoe is still a local credit union at its core. For us, being local means an ongoing commitment to go beyond serving our members and giving back to the communities we call home. At Red Canoe, we strive to make a difference in the lives of our neighbors.
Hybrid scheduled will require in office work monthly at a minimum.
POSITION PURPOSE - The Business Intelligence (BI) Analyst will focus on data integration, analysis, and presentation to support strategic decision-making and operational efficiency. This role requires combining data from various sources, using SQL for querying and integrating datasets, and leveraging BI tools to create actionable insights that drive business improvements across departments. Additionally, the Analyst will assist with training, system configuration, and maintaining documentation for processes and systems.
ESSENTIAL JOB FUNCTIONS
- Business Intelligence - Gather, integrate, and analyze data from data warehouse, CRM system and other sources to generate comprehensive reports, dashboards, and visualizations. Work with internal teams to understand data integration needs and develop reports and dashboards based on user requests and business needs.
- Reporting - Use BI tools (SQL, Power BI, SSRS, etc.) to automate reporting processes, create and maintain reports, dashboards, and methodologies, including user training for recurring reporting needs.
- Knowledge Maintenance - Participate in training to further knowledge related to job responsibilities.
- Documentation - Develop and maintain essential documentation for job functions.
ESSENTIAL RESPONSIBILITIES
- Data Warehouse – Primary usage of internal data warehouse system for development of reporting, dashboards, analytics, metrics and decisioning
- CRM (Sales & Service) System – System management duties including, but not limited to, administration, configuration, reporting and training as needed. Expansion of data-related opportunities to further strategic analysis and reporting
- Integrate and cleanse data from various internal and external sources using SQL and BI tools to develop dashboards, screens, and reports for efficient decision-making.
- Working knowledge of database management to support database administrator
- Development of related business intelligence initiatives through analytical projects, providing strategic insights and opportunities to the organization.
- Collaborate with teams across the organization to discuss data collection, trending, and business function analysis and deliver insights that improve operational and strategic decisions.
- Interaction with all levels of management and staff toward providing technical guidance in the areas of application usage and problem resolution.
- Strong desire and ability to continuously improve data analysis strategies to enhance operational efficiencies.
- Ensure organizational security standards are met as it relates to system and data security operations, policies, and procedures.
- Attend user and training opportunities to build industry relationships and technical expertise.
- Assist and/or train staff as directed.
- Documentation of procedures, supporting information and system configurations to ensure ongoing operational continuity and efficiency.
.
MINIMUM QUALIFICATIONS
- 3 years of related database/analysis experience. BS/BA in a data related field preferred.
- Report/dashboard development in a data warehouse environment using T-SQL, SSRS, Tableau, Power BI or other reporting software required.
- Working knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) preferred.
- API experience and/or additional programming languages like Python are a plus.
- Proven competencies in analytical skills and attention to detail.
- Keyboard proficiency: Ability to hear by telephone and in person.
- Ability to read English by sight; and both speak and write English.
Red Canoe Credit Union provides the following benefits to all employees.
- Medical, Dental & Vision Insurance
- Employee Assistance Program
- Life Insurance
- 401K with employer match
- Wellness Program
- Flexible Spending Account
- PTO leave
- Paid Jury Duty Leave
- Paid volunteer time
A few more perks
- Annual logo wear allowance
- Gym Reimbursement
- Tuition Reimbursement for full time employees
- Employee loan discount
EEO/AAEmployer/Vets/Disabled/Race/Ethnicity/Gender/Age