Business Intelligence Developer (Onsite)

Frontwave Credit Union; Oceanside (CA); On-site; USD 70,000 - 105,000; Full time

Benefits offered by this job

Competitive pay

401k matching

PTO and paid holidays

Affordable health plans

Tuition reimbursement up to $4,000/year

Job summary

Frontwave Credit Union is looking for a Business Intelligence Developer in Oceanside, California. This role involves managing multiple databases, supporting BI analysis efforts, and implementing data retention policies. Candidates should have a Bachelor's degree in a STEM field and expertise in SQL and Python.

In addition to competitive pay, we offer a comprehensive benefits package including health plans, PTO, and career development opportunities. Join us in enhancing member experiences through innovative technology.

Qualifications

• Bachelor’s degree in a STEM field preferred.
• Knowledge in MS SQL Database and SQL query writing required (2+ years preferred).
• Experience in cloud data warehouses strongly preferred.

Responsibilities

• Assists in managing multiple databases across platforms.
• Supports BI and Business Units by writing SQL queries and reports.
• Work with IT Server Team to back up all databases.
• Evaluate, recommend and implement database management tools.
• Assist in creating policies for disaster recovery.

Skills

SQL

Python (PySpark)

Detail-oriented

Time management

Education

Bachelor’s Degree in a STEM field (Computer Science, Math / Statistics, Data Science)

Tools

MS SQL Database

Databricks

Azure

DB2

Job description

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.8 billion 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.