What are the responsibilities and job description for the Business Intelligence Developer (Onsite) position at Frontwave Credit Union?
Overview
The Business Intelligence Developer is responsible for assisting Business Intelligence (BI) management in creating, maintaining, optimizing, and setting up recovery for Frontwave’s data warehouse. Responds to reporting needs and daily functions, including review of backups, reports, SQL queries, data extracts, and database capacity needs. Supports BI analysis efforts by providing access to data resources. Supports and performs upgrades and updates to systems during off hours to support uninterrupted use during production times.
About Frontwave Credit Union
Frontwave Credit Union is a member-owned not-for-profit financial institution serving San Diego, Riverside, San Bernardino and Imperial counties. Founded in 1952, we have grown to 18 branches with 125,000 members and manage over 1.8 billion in assets. At Frontwave Credit Union, we are focused on creating consumer solutions to provide our members and the communities we serve with products and services that enhance the quality of life for our members through exceptional service and the progressive application of technology.
What’s In It For You:
Competitive pay, 401k matching, mortgage and auto discounts.
9-27 days of PTO per year (based on tenure), VTO and 11 paid holidays.
Affordable medical, dental, vision health plans, and Flexible Spending Account.
Employee Assistance Program with a variety of services.
Career development, training, and coaching, mentoring; tuition reimbursement up to $4,000/year.
Culture of excellence and continuous improvement.
We strive to be the best place you’ve ever worked!
Responsibilities
Essential Duties and Responsibilities:
Includes the following non-inclusive list. Other duties may be assigned. All duties are to be performed in compliance with applicable laws, regulations and Credit Union policies and procedures.
Education and/or Experience:
Bachelor’s Degree in a STEM field (Computer Science, Math / Statistics, Data Science) or related field (MIS) preferred. Knowledge in MS SQL Database and SQL query writing required (2 years preferred). Experience in cloud data warehouses strongly preferred.
Additional Knowledge, Skills and Abilities:
Service Excellence Standards
When joining Frontwave Credit Union, you can expect to be a part of a workforce committed to the following Service Excellence standards:
The Business Intelligence Developer is responsible for assisting Business Intelligence (BI) management in creating, maintaining, optimizing, and setting up recovery for Frontwave’s data warehouse. Responds to reporting needs and daily functions, including review of backups, reports, SQL queries, data extracts, and database capacity needs. Supports BI analysis efforts by providing access to data resources. Supports and performs upgrades and updates to systems during off hours to support uninterrupted use during production times.
About Frontwave Credit Union
Frontwave Credit Union is a member-owned not-for-profit financial institution serving San Diego, Riverside, San Bernardino and Imperial counties. Founded in 1952, we have grown to 18 branches with 125,000 members and manage over 1.8 billion in assets. At Frontwave Credit Union, we are focused on creating consumer solutions to provide our members and the communities we serve with products and services that enhance the quality of life for our members through exceptional service and the progressive application of technology.
What’s In It For You:
Competitive pay, 401k matching, mortgage and auto discounts.
9-27 days of PTO per year (based on tenure), VTO and 11 paid holidays.
Affordable medical, dental, vision health plans, and Flexible Spending Account.
Employee Assistance Program with a variety of services.
Career development, training, and coaching, mentoring; tuition reimbursement up to $4,000/year.
Culture of excellence and continuous improvement.
We strive to be the best place you’ve ever worked!
Responsibilities
Essential Duties and Responsibilities:
Includes the following non-inclusive list. Other duties may be assigned. All duties are to be performed in compliance with applicable laws, regulations and Credit Union policies and procedures.
- Assists in managing multiple databases across disparate platforms, including Databricks, Microsoft SQL Servers, Azure, and DB2.
- Supports BI and Business Units by writing SQL queries and reports.
- Supports BI Management by ensuring the overall performance, tuning, and recovery of all MS SQL instances.
- Work with IT Server Team to back up all databases in compliance with the credit union Backup policy. Assist management in proactive maintenance of all database instances (upgrades, patching, integrity check, and security control) during normal business hours and/or, off hours to reduce the impact on business operations.
- Work with management to implement data retention policies for operational and sensitive data stores.
- Evaluate, recommend and implement database management and monitoring tools.
- Troubleshoot and maintain various scheduled jobs for maintenance, monitoring, and specific business needs. Escalate when needed.
- Help design and implement redundant systems for high availability.
- Assist in creating policies and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets for compliance and audit.
- Assist in planning, documenting, implementing, and managing custom database structure, including data import and validation.
- Consistently perform data steward functions to safeguard Credit Union data integrity.
- Appropriately document issues and resolutions in BI ticketing system.
- Partner with Information Technology Team and other departments to review implementation requests, provide feedback, and deploy and maintain t
Education and/or Experience:
Bachelor’s Degree in a STEM field (Computer Science, Math / Statistics, Data Science) or related field (MIS) preferred. Knowledge in MS SQL Database and SQL query writing required (2 years preferred). Experience in cloud data warehouses strongly preferred.
Additional Knowledge, Skills and Abilities:
- Knowledge in SQL, stored procedures, triggers, views, replication, and performance tuning.
- Demonstrated knowledge of Python (PySpark)
- Detail-oriented and accepts ownership of a task until completion.
- Ability to reason and anticipate the outcome of repeated processes to assist in daily processing.
- Is organized, thorough, and has a respect for quality control.
- Has strong time management skills and ability to juggle priorities.
- Ability to be autonomous with minimal supervision.
- Ability to maintain composure and learn quickly on the fly.
- Maintains strong verbal and written communication.
Service Excellence Standards
When joining Frontwave Credit Union, you can expect to be a part of a workforce committed to the following Service Excellence standards:
- We see it. We own it. We get it done.
- We ignite positive experiences.
- We do things right every time.
- We are collaborators - united, cohesive and engaged
- We innovate and evolve.
- We create memorable experiences for life.
- We starts with me.