> Markdown version of [/jobs/ext/254468-data-analyst-i](https://www.wearedevelopers.com/jobs/ext/254468-data-analyst-i). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst I - **Company:** Fremont Bank - **Location:** Livermore, CA, United States - **Experience:** Experienced - **Salary:** $74,984.0 - $84,968.0 - **Contract:** Permanent contract - **Skills:** Microsoft Word, Microsoft Excel, Data Analysis, Data Cleansing, Data Visualization, Data Warehousing, IBM Cognos Business Intelligence, Python (Programming Language), Microsoft Office, Microsoft PowerPoint, Productivity Software, Reverse Engineering, SQL Databases, Tableau (Software), Information Technology, Data Analytics - **Published:** May 31, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=e4a468f7c4709642 ## About the Role Do you have experience in Productivity software?, Do you have a Bachelor's degree?, * 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 are representative of those that must be met to successfully perform the essential functions 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. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the position. ## Description 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. ## Related Videos - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Developing the Rich Text Editor for DeepL.com](https://www.wearedevelopers.com/videos/1172-developing-the-rich-text-editor-for-deepl-com) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Pioneering AI Assistants in Banking](https://www.wearedevelopers.com/videos/1627-pioneering-ai-assistants-in-banking) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)