Business Intelligence Analyst
Job Description:
ESSENTIAL JOB FUNCTIONS
- Business Intelligence – Gather, integrate, and analyze data from data warehouse, CRM system and other sources to generate comprehensive reports, dashboards, and visualizations. Work with internal teams to understand data integration needs and develop reports and dashboards based on user requests and business needs.
- Reporting – Use BI tools (SQL, Power BI, SSRS, etc.) to automate reporting processes, create and maintain reports, dashboards, and methodologies, including user training for recurring reporting needs.
- Knowledge Maintenance – Participate in training to further knowledge related to job responsibilities.
- Documentation – Develop and maintain essential documentation for job functions.
ESSENTIAL RESPONSIBILITIES
- Data Warehouse – Primary usage of internal data warehouse system for development of reporting, dashboards, analytics, metrics and decisioning
- CRM (Sales & Service) System – System management duties including, but not limited to, administration, configuration, reporting and training as needed. Expansion of data-related opportunities to further strategic analysis and reporting
- Integrate and cleanse data from various internal and external sources using SQL and BI tools to develop dashboards, screens, and reports for efficient decision-making.
- Working knowledge of database management to support database administrator
- Development of related business intelligence initiatives through analytical projects, providing strategic insights and opportunities to the organization.
- Collaborate with teams across the organization to discuss data collection, trending, and business function analysis and deliver insights that improve operational and strategic decisions.
- Interaction with all levels of management and staff toward providing technical guidance in the areas of application usage and problem resolution.
- Strong desire and ability to continuously improve data analysis strategies to enhance operational efficiencies.
- Ensure organizational security standards are met as it relates to system and data security operations, policies, and procedures.
- Attend user and training opportunities to build industry relationships and technical expertise.
- Assist and/or train staff as directed.
- Documentation of procedures, supporting information and system configurations to ensure ongoing operational continuity and efficiency.
BASIC REQUIREMENTS
- Strong communication skills with the ability to work professionally and tactfully, especially with confidential information.
- Functional knowledge of Microsoft Office suite including Excel, Word, Teams, and Outlook.
- Working knowledge of database management, data source integrations, and analytics development.
- Strong organizational skills and the ability to work independently.
- Ability to coordinate, set priorities, and manage tasks with changing business needs.
- High attention to detail and accuracy; proficient verbal and written communication abilities, including ability to teach and explain ideas and concepts to co-workers and clients with varying levels of technical knowledge.
- Willing to work irregular hours including weekends and nights.
- Must be bondable.
MINIMUM QUALIFICATIONS
- 3+ years of related database/analysis experience. BS/BA in a data related field preferred.
- Report/dashboard development in a data warehouse environment using T-SQL, SSRS, Tableau, Power BI or other reporting software required.
- Working knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) preferred.
- API experience and/or additional programming languages like Python are a plus.
- Proven competencies in analytical skills and attention to detail.
- Keyboard proficiency: Ability to hear by telephone and in person.
- Ability to read English by sight; and both speak and write English.
ESSENTIAL MENTAL, PHYSICAL & ENVIRONMENTAL DEMANDS
- General – The physical demands described here are representative of those that must be to successfully perform the essential functions of this position. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this position, the employee is regularly required to talk or hear. The employee frequently is required to use hands or fingers, handle, or feel objects, tools or controls. The employee is occasionally required to stand, walk, sit, reach with hands and arms, climb or balance, and stoop, kneel, crouch, or crawl.
- Physical – Office mobility required. Approximately 20% standing, 70% sitting, 10% walking, as needs demands. Possess sufficient manual dexterity to skillfully operate standard office equipment including a computer or typewriter keyboard, 10-key calculator, facsimile machine, photocopier, and telephone. Other demands include talking, handling & reaching, seeing (corrected vision) and hearing in normal range. Specific vision abilities required by this position include close vision, distance vision, color vision, peripheral vision, and the ability to adjust focus. A telephone device to enhance hearing will be provided if needed. Occasional light lifting. The employee must occasionally lift and/or move up to 30 pounds. Periodic inter-branch or interdepartmental access may be required, including distribution and access to various materials, equipment, meetings, etc. Storage and retrieval of materials, maximum reach required is 84 inches.
- Mental – Mental effort required involving considerable organization, planning and analytical efforts with superior communication. General demands include alertness, memory, observation, empathy, ingenuity, learning ability, problem solving, patience, initiative, memory, objectivity, creativity, speaking ability, reading, and writing ability, judgment, persuasiveness, concentration, flexibility, precision, and auditory discrimination.
- Environmental – Minimal discomfort from heat, dust, air conditioning. The noise level is usually moderate, including external road noise. Transport within remote branch and/or main office/facility may be single or multilevel (as required) including a variety of stairways, elevators, etc. Exposure to computers and other electronic equipment. Lunch/break area exposed to microwave and is in basement at main office. Facility is 100% free of tobacco smoke.
- Equipment – Essential equipment used includes but may not be limited to telephones, personal computers, other on-line computer terminal(s), calculator, and office security systems. Non-essential equipment generally includes paper shredder, typewriter, photocopy machine, facsimile (fax) machine, etc.
EEO/AAEmployer/Vets/Disabled/Race/Ethnicity/Gender/Age