Business Intelligence Analyst

Summary

Market Analysis RoleAnalyzes markets for new or existing products or services for one or more divisions, product lines, or market segments. Generally, uses in-house information systems or external metrics to collect, evaluate, and analyze data on customers, prospective customers, and competitors to determine market penetration. Prepares reports and evaluates potential markets, market conditions and advertising campaigns. Supports roadmap initiatives, existing platform feature enhancement projects, and technical changes to online and mobile banking platforms.Major Duties and Responsibilities25% POWER BI REPORTING:Meet with key stakeholders about current reports and desired functionalityDevelop user friendly dashboards leveraging COCCs Datamart and other data inputsProvide knowledge transfer of Microsoft Power BI to TotalVision power users as-neededDocument dataflow diagrams and conversion methodologyCreate a report library of new and converted reports and dashboards25% TOTAL VISION CONVERSION:Reach out to key stakeholders across departmentsCatalog existing Total Vision (Crystal) Reports for conversion to PowerBICreate a document library of all converted reports across departmentsProvide end-user training in COCC Datamart elements and difference between platforms15% COMMERCIAL/CONSUMER LENDING:Reach out to key stakeholders in loan origination, loan servicing and creditInquire on non-COCC Insight Applications and reporting requirementsLoanwriter, Encompass, LoanVantageDevelop knowledge in these applications and reporting / dashboarding optionsWork with key stakeholders to develop new centralized and user friendly reports and dashboards15% MARKETING:Assist Director of Marketing with scheduled and ad-hoc reporting across platformsDevelop automation of data-feeds and dashboarding for routine and board level reportingAssist with third party datamining and analytics such as Google Analytics, Segmint and MXMoneyInclude performance metrics from the Haberfeld program and the above to help gauge campaign performanceStudent survey at Massasoit Community CollegeCollaboration w/ Data Science Department (Professor Brown-Sederberg)Support with identifying cross-sales leads for Cash Management & NII opportunities15% ARTIFICIAL INTELLIGENCE:Microsoft Co-Pilot5% Any other duties/projects as assigned.RequirementsKnowledge and SkillsExperience: A minimum of one year up to three years of similar or related experience, including preparatory experience.Education/Certifications/Licenses: A high school degree or equivalent. Associate's degree in Business Intelligence (BI), Data Analytics or industry certification in Business Intelligence or Power BI preferred.Interpersonal Skills: A significant level of trust, credibility and diplomacy is required. In-depth dialogue, conversations and explanations with customers, direct and indirect reports and outside vendors can be of a sensitive and/or highly confidential nature. Communications may involve motivating, influencing, educating and/or advising others on matters of significance.ADA RequirementsPhysical Requirements: Is able to bend, sit, and stand in order to perform primarily sedentary work with limited physical exertion and occasional lifting of up to 10 lbs. Must be capable of climbing / descending stairs in an emergency situation. Must be able to operate routine office equipment including computer terminals and keyboards, telephones, copiers, facsimiles, and calculators. Must be able to routinely perform work on computer for an average of 6-8 hours per day, when necessary. Must be able to work extended hours or travel to site whenever required or requested by management. Must be capable of regular, reliable and timely attendance.Working Conditions: Must be able to routinely perform work indoors in climate-controlled shared work area with minimal noise.Mental and/or Emotional Requirements: Must be able to perform job functions independently or with limited supervision and work effectively either on own or as part of a team. Must be able to read and carry out various written instructions and follow oral instructions. Must be able to complete basic mathematical calculations, spell accurately, and understand computer basics. Must be able to speak clearly and deliver information in a logical and understandable sequence. Must be capable of dealing calmly and professionally with numerous different personalities from diverse cultures at various levels within and outside of the organization and demonstrate highest levels of customer service and discretion when dealing with the public. Must be able to perform responsibilities with composure under the stress of deadlines / requirements for extreme accuracy and quality and/or fast pace. Must be able to effectively handle multiple, simultaneous, and changing priorities. Must be capable of exercising highest level of discretion on both internal and external confidential matters.

Job Description

Market Analysis RoleAnalyzes markets for new or existing products or services for one or more divisions, product lines, or market segments. Generally, uses in-house information systems or external metrics to collect, evaluate, and analyze data on customers, prospective customers, and competitors to determine market penetration. Prepares reports and evaluates potential markets, market conditions and advertising campaigns. Supports roadmap initiatives, existing platform feature enhancement projects, and technical changes to online and mobile banking platforms.Major Duties and Responsibilities25% POWER BI REPORTING:Meet with key stakeholders about current reports and desired functionalityDevelop user friendly dashboards leveraging COCCs Datamart and other data inputsProvide knowledge transfer of Microsoft Power BI to TotalVision power users as-neededDocument dataflow diagrams and conversion methodologyCreate a report library of new and converted reports and dashboards25% TOTAL VISION CONVERSION:Reach out to key stakeholders across departmentsCatalog existing Total Vision (Crystal) Reports for conversion to PowerBICreate a document library of all converted reports across departmentsProvide end-user training in COCC Datamart elements and difference between platforms15% COMMERCIAL/CONSUMER LENDING:Reach out to key stakeholders in loan origination, loan servicing and creditInquire on non-COCC Insight Applications and reporting requirementsLoanwriter, Encompass, LoanVantageDevelop knowledge in these applications and reporting / dashboarding optionsWork with key stakeholders to develop new centralized and user friendly reports and dashboards15% MARKETING:Assist Director of Marketing with scheduled and ad-hoc reporting across platformsDevelop automation of data-feeds and dashboarding for routine and board level reportingAssist with third party datamining and analytics such as Google Analytics, Segmint and MXMoneyInclude performance metrics from the Haberfeld program and the above to help gauge campaign performanceStudent survey at Massasoit Community CollegeCollaboration w/ Data Science Department (Professor Brown-Sederberg)Support with identifying cross-sales leads for Cash Management & NII opportunities15% ARTIFICIAL INTELLIGENCE:Microsoft Co-Pilot5% Any other duties/projects as assigned.RequirementsKnowledge and SkillsExperience: A minimum of one year up to three years of similar or related experience, including preparatory experience.Education/Certifications/Licenses: A high school degree or equivalent. Associate's degree in Business Intelligence (BI), Data Analytics or industry certification in Business Intelligence or Power BI preferred.Interpersonal Skills: A significant level of trust, credibility and diplomacy is required. In-depth dialogue, conversations and explanations with customers, direct and indirect reports and outside vendors can be of a sensitive and/or highly confidential nature. Communications may involve motivating, influencing, educating and/or advising others on matters of significance.ADA RequirementsPhysical Requirements: Is able to bend, sit, and stand in order to perform primarily sedentary work with limited physical exertion and occasional lifting of up to 10 lbs. Must be capable of climbing / descending stairs in an emergency situation. Must be able to operate routine office equipment including computer terminals and keyboards, telephones, copiers, facsimiles, and calculators. Must be able to routinely perform work on computer for an average of 6-8 hours per day, when necessary. Must be able to work extended hours or travel to site whenever required or requested by management. Must be capable of regular, reliable and timely attendance.Working Conditions: Must be able to routinely perform work indoors in climate-controlled shared work area with minimal noise.Mental and/or Emotional Requirements: Must be able to perform job functions independently or with limited supervision and work effectively either on own or as part of a team. Must be able to read and carry out various written instructions and follow oral instructions. Must be able to complete basic mathematical calculations, spell accurately, and understand computer basics. Must be able to speak clearly and deliver information in a logical and understandable sequence. Must be capable of dealing calmly and professionally with numerous different personalities from diverse cultures at various levels within and outside of the organization and demonstrate highest levels of customer service and discretion when dealing with the public. Must be able to perform responsibilities with composure under the stress of deadlines / requirements for extreme accuracy and quality and/or fast pace. Must be able to effectively handle multiple, simultaneous, and changing priorities. Must be capable of exercising highest level of discretion on both internal and external confidential matters.