Data Analyst

Job Title:

Data Analyst

Location:

Livermore, CA

Hiring Salary Range: $36.05 – $40.85 per hour

Fremont Bank — one of the Bay Area’s most respected and long-standing financial institutions — is seeking a strategic, hands‑on professional to join and help advance our Data and Analytics team. This is a high‑impact opportunity to contribute to the success of a mission‑driven organization committed to excellence, community service, and strong client relationships.

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

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

We offer:

• People‑first culture grounded in inclusion and excellence
• Deep community involvement and local reinvestment
• Mission‑driven workplace where values and performance go hand in hand

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

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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.