Data Analyst: Fremont Bank

Fremont Bank, one of the most successful lenders in the East Bay Area and an award winner of one of the Best Places to Work in the Bay Area has an immediate opening for a Data Analyst.

The Data Analyst will be responsible for gathering and translating business requirements into queries, models and tools to allow for insightful data analysis and forecasting back to the business. The Data Analyst works with business users to develop and interpret reports in the proper context, create complex data queries, reconcile data from sources with varying degrees of accuracy and granularity, develop ad-hoc queries to augment/pilot new reports, perform data cleansing and auditing to identify idiosyncrasies and compensate for deficiencies, create data extract transformation and load processes. Data Analyst uses deployed business intelligence capabilities to help business users analyze data and create customized reports and analytics.

Responsibilities Include:

· Develop a strong working relationship with the appropriate business users to understand the key business drivers and priorities

· Lead and facilitate sessions with cross-functional teams to reach consensus on data definitions.
Develop data models to cleanse, interpret and reconcile information from various sources

· Develop data models to distill actionable information by excluding noise in the data.

· Develop detailed functional specifications and requirements for new reports.

· Audit and measure data quality and take actions to reconcile.

· Create ad-hoc queries to augment existing reports using SQL and other tools e.g. Excel

· Perform ad-hoc data cleansing, match, merge & debug operations.

· Create and maintain documentation

· Provide analytical support and create reports for the Cognos BI / MS SSRS user community

· Educate user community on data mining techniques, tools, and best practices

· Ensure quality delivery of BI reports and operational enhancements

· Perform QA on new reports against underlying data for accuracy.

· Perform end user training on reports and reporting environment

· Maintains data integrity and standards

· Use audit techniques to obtain, analyze and appraise data, transactions, and records as a basis for providing an objective opinion on the performance of the business and the effectiveness of key management activities

· Design and execute tasks to cleanse data to support various initiatives

Requirements:

• Strong hands-on technical experience with MS SQLServer, TSQL, and VB.net
• Extensive experience with data extraction, and validation, experience with transactional systems
• Reporting and business intelligence experience
• Experience in medium to large scale reporting environments so to understand the unique challenges in scale
• Experience with Banking, Financial Services, Retail and Commercial Lending data
• Experience with ITI Premier Prime data warehouse is highly desirable
• 6+ years of experience as an IT data analyst
• 4+ years exp in the field of Business Intelligence
• 4+ years of exp in the field of data mining and analytics
• Must be skilled in SQL design/development, strong in MS SQL Server, Excel
• Experience with IBM Cognos
• Bachelors of Science degree in Computer Science, Information Systems, Electrical Engineering or related field