Business Intelligence Developer (Onsite)

Overview The Business Intelligence Developer is responsible for assisting BI management in creating, maintaining, optimizing, and setting up recovery for Frontwave’s data warehouse. The role responds to reporting needs and daily functions, including review of backups, reports, SQL queries, data extracts, and database capacity needs. It supports BI analysis efforts by providing access to data resources and performs upgrades and updates to systems during off hours to ensure 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.8billion in assets. We focus on creating consumer solutions that enhance the quality of life for our members through exceptional service and progressive 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. 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 Qualifications 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. Salary Range: $34.56 - $51.84 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. #J-18808-Ljbffr Frontwave Credit Union