Business Intelligence Analyst

Role

The Business Intelligence Analyst is responsible for ensuring that, in partnership with key stakeholders, illustrations of data are accurate, timely, and represent the departments drive to support members needs through service that is highly related to their desires and requirements. Combines advanced analytical expertise, knowledge of the financial industry, and programming skills to research, collect, analyze, and interpret large data sets from internal and external sources to develop data-driven solutions to difficult business challenges. Integrates and prepares large, varied data sets, designs specialized data and computing environments and communicates results in a way that can be easily understood by business counterparts.

Major Duties and Responsibilities

• Develop new enterprise business intelligence (BI) service offerings, content creation, and value propositions to support and improve business processes.


• Collaborate with end users to identify needs and opportunities for improved data management and delivery.


• Provide ongoing development and maintenance of an operational data store and enterprise data warehouse using BI best practices, relational structures, dimensional data modeling, structured query language skills, data warehouse and reporting techniques.


• Enhances processes regarding data. Improves the quality, accuracy, visibility and usability of the data.


• Provide ongoing development and maintenance of a BI architecture that enables fact-based decision making and ad-hoc analysis and insight generation.


• Provide interactive real-time dashboards and key performance indicators using, for example, Microsoft Power BI, SQL Server Reporting Services, Tableau, Sisense, SAP Crystal Reports, IBM Cognos, Qlik, or newly identified BI tools.


• Provide end-user support and encourage user adoption. Act as Tier 1 support for end-users of BI tools. Train end-users in basic functionality. Direct users to training material and available resources.


• Under general direction, responsible for converting business requirements and high-level data collection needs into well-specified analyses, reporting and visualizations.


• Must comply with all company policies and procedures, applicable laws and regulations, including but not limited to, the Bank Secrecy Act, the Patriot Act, and the Office of Foreign Assets Control.

Knowledge and Skills

Experience: At least 3 - 5 years previous work experience in analytics and modeling environments of the financial or marketing industry.

Working knowledge of Enterprise Level Business Intelligence reporting tools such as SSRS, Tableau, Cognos, and database development required.

Working knowledge of web-based development required (e.g. may include any of Power BI, Python, SQL Reporting, JavaScript, C++, PHP, ASP, ColdFusion, Visual Basic, etc.)

Working knowledge of basic algebraic and financial equations and formulas is required.

Working knowledge of Microsoft Office macros (or Visual Basic) preferred as well as advanced Excel

Education/Certifications/Licenses: BA/BS in Mathematics or Statistics or BA/BS in business, finance, or related field with coursework in marketing and statistics.

Interpersonal Skills

Ability to analyze complex data, draw conclusions and make business recommendations using well-developed oral and written communication skills including the writing of executive reports.

Other Skills

Familiarity with coding languages like Python, Java, or R is often sought after in job listings.

Extensive knowledge of MS Office Products, i.e. Access, Excel, Word.

Expertise in Relational Database Software. Demonstrated ability to apply knowledge of databases (i.e. MSSQL, Oracle, Access).

Highly proficient in marketing database management.

Highly proficient in statistical analysis techniques.

Highly proficient in statistical software, including SPSS.

Demonstrated ability to apply knowledge of financial institution systems, including core processing, job scheduling, and data sets.

Ability to manipulate, query, and analyze large quantities of data and present it in simple, insightful, actionable summaries for a diverse audience.

Ability to create and organize reports that synthesize complex information.

Ability to create and effectively create and present relevant and readable graphs, charts, presentation materials, reports, business correspondence, and procedure manuals for a diverse audience.

Ability to research, read, analyze and interpret financial reports, procedure manuals, business periodicals and professional journals.

Ability to effectively present ideas and concepts verbally, including presentations to Senior Management and the Board of Directors.

Ability to manage multiple complex projects.

Benefits for Full time employees includes:

• 401(k) w/ up to 5% matching


• Medical insurance


• Dental insurance


• Vision insurance


• Life insurance


• Disability insurances


• FSA


• Paid Vacation, Sick & Holiday hour

An Equal Opportunity Employer Minorities/Females/Veteran/Disabled

Other details

• 
  Pay Type
  Salary
  
• 
  Required Education
  Bachelor’s Degree
  
• 
  Job Start Date
  Monday, January 27, 2025