Role

The Business Intelligence Analyst Intern supports the development of accurate, timely, and meaningful data visualizations in partnership with key stakeholders. This role contributes to the department’s mission of understanding and meeting member needs through data driven insights.

The intern applies developing analytical skills, foundational knowledge of the financial or business environment, and emerging technical abilities to assist in researching, collecting, analyzing, and interpreting data from internal and external sources. This position helps prepare and organize large, varied datasets, supports the design of analytical or reporting environments, and contributes to communicating findings in a clear, accessible way for business partners.

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