Data Analyst I

Job Title: Data Analyst

Location: Livermore, CA

Hiring Salary Range: $36.05 - $40.85 per hour

Position Summary

Fremont Bank - one of the Bay Area's most respected and long-standingfinancial institutions - is seeking a strategic, hands-on professional to joinand help advance our Data and Analytics team. This is a high-impactopportunity to contribute to the success of a mission-driven organizationcommitted to excellence, community service, and strong client relationships.

If you're energized by purpose-driven work, collaboration, and deliveringmeaningful results, we'd love to connect.

Why Fremont Bank?

Founded in 1964, Fremont Bank is one of the oldest independently ownedbanks in the Bay Area and has been consistently recognized as a Top Workplacefor the past 15 consecutive years. Our foundation is built on relationships -with our clients, our associates, and our communities.

We offer:

• A people-first culture grounded in inclusion and excellence
• Deep community involvement and local reinvestment
• A mission-driven workplace where values and performance go hand in hand

The Fremont Bank Way

• Full-Service Banking with comprehensive financial solutions, advanced technology, and exceptional service
• No-Compromise Approach - we help clients get to "yes"
• Core Values:
  o Go above and beyond for clients
  o Foster a supportive and empowering environment for associates
  o Deeply invest in the well-being of our local community

Position Overview

The Data Analyst serves as a core contributor within the bank's Data Analytics group, strengthening enterprise analytics by producing consistent, governed, and trusted reporting used across all business units.

This role goes beyond report development and focuses on deep analytical work - understanding and blending data sources, ensuring accuracy and consistency, and delivering meaningful insights that drive business decisions across the enterprise.

The analyst will clean, prepare, validate, and analyze data from multiple banking systems, develop trusted enterprise reporting, and communicate key metrics and insights to business units and executive leadership.

Role and Responsibilities

Enterprise Analytics & Insight Generation

• Support enterprise-wide analytics including loan portfolio and deposit trends, pipeline dynamics, production drivers, efficiency metrics, and growth analysis.
• Move beyond surface-level reporting to interpret results and provide actionable insights.

Data Preparation, Quality & Validation

• Extract, clean, transform, and validate data from multiple source systems to ensure accuracy, consistency, and reliability.
• Identify data quality issues, investigate root causes, and partner with data owners to resolve discrepancies.
• Develop reconciled datasets that serve as a single source of truth for enterprise reporting.

Enterprise Reporting & Metric Standardization

• Design and maintain consistent, repeatable, enterprise-aligned reporting across all business units.
• Create clear, concise, and visually engaging dashboards and reports using data visualization tools (e.g., Tableau).
• Establish and document standardized metric definitions, calculation logic, and assumptions to eliminate conflicting or duplicated reports.

Reporting Modernization & Automation

• Contribute to a multi-year initiative to migrate legacy reports (e.g., IBM Cognos and manual Excel processes) into scalable datasets and Tableau dashboards.
• Reverse-engineer and validate legacy reporting logic to ensure accuracy prior to migration.

Business Partnership & Enterprise Collaboration

• Work cross-functionally with leaders and staff across business lines and members of the data warehouse team.
• Develop a strong understanding of how different areas of the bank operate and how their activities impact enterprise performance.

Executive & Leadership Support

• Deliver accurate, well-documented reporting and analysis to support weekly, monthly, and quarterly leadership reporting.
• Build data models and reporting structures that enable rapid, ad hoc analysis without extensive manual rework.
• Communicate findings clearly to both technical and non-technical audiences.
• Perform other duties and responsibilities as assigned.

Essential Skills and Experience

Education & Experience

• Bachelor's degree in Data Science, Statistics, Economics, Finance, Computer Science, or a related quantitative field.
• Minimum 3 years of experience in data analytics, business intelligence, or data-focused roles (banking or financial services experience preferred).

Technical & Analytical Skills

• Strong analytical skills with the ability to investigate, clean, and interpret complex datasets.
• Active user of Tableau Prep and Tableau Desktop, including understanding and experience in data preparation, creating calculated fields and parameters, and dashboard design.
• Intermediate user of Microsoft office (PowerPoint, Excel, Word)
• Experience with IBM Cognos, Python, and SQL is a plus.

Banking & Business Acumen

• Understanding of banking operations, including commercial and residential lending, deposits, treasury management, and financial services along with their associated key performance metrics.

Communication & Collaboration

• Ability to explain complex analytical findings in a clear, concise, and business-relevant manner, both written and verbally.
• Demonstrated experience building trusted reporting, improving data quality, and delivering enterprise-level analytics.

Physical Requirements

The physical requirements described below arerepresentative of those that must be met to successfully perform the essentialfunctions of this position, with or without reasonable accommodation.

• Ability to remain in a stationary position for extended periods (e.g., sitting or standing).
• Frequent use of a computer and other office equipment.
• Ability to communicate effectively with colleagues and customers.
• Occasionally move or lift items up to 10-15 pounds.

Reasonableaccommodations may be made to enable individuals with disabilities to performthe essential functions of the position.

What Makes Fremont Bank AssociatesThrive?

• Team Players who go above and beyond to support their colleagues
• Action-Oriented professionals who challenge the status quo and seek improvement
• Purpose-Driven individuals who understand and champion the bank's community impact

Benefits Snapshot

Health & Wellness

• Medical, dental, and vision insurance
• Flexible Spending Accounts (FSA, Dependent Care, Health Savings)

Financial & Retirement

• Employee Stock Ownership Plan (ESOP)
• 401(k) with employer match
• Performance-based bonuses or incentives

Work-Life & Perks

• Paid holidays, vacation, and sick time
• Free personal checking and savings accounts
• Home loan rate discounts
• Tuition reimbursement and professional development resources
• On-site gym and discounted health club memberships
• Employee Assistance Program (EAP)

Equal Opportunity Employer

Fremont Bank is proud to be an Equal Opportunity Employer. We arecommitted to creating an inclusive environment for all employees, regardless ofrace, color, religion, sex, gender identity, sexual orientation, nationalorigin, age, disability, veteran status, or any other protected classification.

Salary Range

The hiring salary range for this position is $36.05 - $40.85 per hour,based on factors such as experience, skills, education, and internal equity.Compensation decisions are made in consideration of these factors and inalignment with Fremont Bank's compensation philosophy.

Employee Stock Ownership Plan (ESOP)

The Employee Stock Ownership Plan (ESOP) is a way for Fremont Bank tocontribute to the financial well-being of associates by making a contributionto their retirement account. In addition, the ESOP provides associates anopportunity to share in the growth and prosperity of Fremont Bank.

Note to Search Firms:

Fremont Bank does not accept unsolicited resumes from search firms oragencies without a signed service agreement. Unsolicited resumes will beconsidered the property of Fremont Bank, and no fees will be paid.