Data Analyst I
About The Position
Fremont Bank is seeking a strategic, hands-on professional to join and help advance their 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. 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.
Requirements
- 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).
- 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)
- Understanding of banking operations, including commercial and residential lending, deposits, treasury management, and financial services along with their associated key performance metrics.
- 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.
- 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.
Nice To Haves
- Experience with IBM Cognos, Python, and SQL is a plus.
Responsibilities
- 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.
Benefits
- Medical, dental, and vision insurance
- Flexible Spending Accounts (FSA, Dependent Care, Health Savings)
- Employee Stock Ownership Plan (ESOP)
- 401(k) with employer match
- Performance-based bonuses or incentives
- 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)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
