BUSINESS INTELLIGENCE (BI) ANALYST - 1

As a certified B Corp, Community Development Financial Institution (CDFI) and values-based bank, Sunrise Banks does banking differently – so our careers are also unique. 

POSITION SUMMARY 

As part of the Business Intelligence team, the analyst will be responsible for building automation processes and applications using Microsoft PowerApps, maintaining data workflows for Microsoft Power platform, building web portals through Microsoft Power Pages. Will involve working with SQL based data sources, including Azure SQL using Microsoft SQL Server and Snowflake. Report data may also come from sources such as spreadsheets or APIs making the ability to work with and integrate diverse data essential. This position will not typically be responsible for creating or maintaining ETL processes but may need to have the ability to create basic views, stage data, build queries and stored procedures. This role will be responsible for working with various data objects and should demonstrate an understanding of basic concepts of data integrity and relational data stores. The analyst will work with business units within the organization to provide data and reports to higher level management. Role will include administration of system used by the organization including QuickBooks Time. Good organizational skills are essential for managing a growing report library and properly navigating access to sensitive data. In addition, the analyst will maintain the service request dashboard platforms which will include backend hierarchy and organization chart updates, source data scrubs, aesthetic changes, as well as training and guiding users as part of the delivery of end products. 

ESSENTIAL FUNCTIONS

 

• Analyze and extract meaningful data from multiple sources, combine workbooks and develop essential data set reporting.
• Review data & reports (completeness of information, correct calculations, and proper execution).
• Assist analysts in obtaining/collecting all documents/information to complete assigned projects or tasks.
• Write procedures to document processes used by Business Intelligence staff.
• Perform data entry relevant to project or task.
• Interpret data as required by business lines (staffing analysis, business reports, forecasts), analyzing results using statistical techniques, creating clear reports with information displayed in a format useful to individuals without technical experience.

SUPERVISORY RESPONSIBILITIES

 None

COMPETENCIES

• Sunrise Core Values
• Adaptability
• Communication
• Compliance
• Dependability & Flexibility
• Initiative
• Integrity
• Judgement
• Organizational Skills
• Productivity
• Professionalism
• Quality Service
• Teamwork
• Technical /PC Skills
• Work Quality

EDUCATION & EXPERIENCE

• College degree in business, information technology or data sciences preferred.
• Two years of experience in information technology and/or data sciences preferred.
• Excellent analytical and problem-solving skills.
• Experience with relational and non-relational database structures preferred.
• Experience with statistical analysis preferred. Will be conducting practical statistical analysis of data sets.
• Knowledge of graphic design and/or website design preferred
• Experience with Business Intelligence software preferred. Will be using Microsoft Power Platform.
• Superior skill set in the use of the following software applications: Microsoft Excel, Word, PowerPoint, Access, and Outlook.
• Experience in SQL Server preferred
• High integrity and ethics.
• Growth mindset (naturally curious strong learning agility)