Business Intelligence Developer II

POSITION DESCRIPTION: FUNCTION: The Business Intelligence (BI) Developer works collaboratively with end users to develop reporting systems that provide accessible information for decision-making. The BI Developer uses warehouse data to solve organizational problems through reports, analysis, and data visualization. The BI Developer will provide enterprise-wide data warehouse expertise with emphasis on data design, access, usage, security, and quality of information assets. This position occasionally requires work to be performed outside of normal Bank hours. GENERAL DESCRIPTION OF DUTIES: Data Modeling BI and Data Warehousing solutions Develops and maintains Power BI reports, dashboards, and data visualizations that support business analysis and decision-making Designs, develops, and maintains Power BI semantic models, including data model relationships, measures, hierarchies, and reusable datasets to support consistent enterprise reporting Performs technical troubleshooting, code debugging, and problem solving for custom built data warehousing solutions Assists in implementing effective business analytics practices that drive improved decision making, efficiency and performance Communicate with nontechnical business users to determine specific business requirements for reports and business intelligence solutions Communicates regularly with technical, applications and operational staff to ensure database integrity, security and optimized performance at the application and database level Identifies, communicates, and resolves data quality and data reconciliation issues Participates in and supports all planning and problem resolution Develops and enforces standards and procedures for the storage and retrieval of institutional data Works collaboratively with institutional staff and reporting officials to resolve data discrepancies and/or to clarify reporting procedures Maintains an accurate and comprehensive inventory of data, data systems, and data storage Processes data extracts using data retrieval and management tools Protects confidential information DIGITAL LITERACY: The ability to use data, information, and communication technologies to find, evaluate, create, and communicate information, requiring both cognitive and technical skills Information, data, and content Teaching learning and self-development Communication, collaboration, and participation Digital identity, safety, and security Technical proficiency with all bank products Awareness and interest in new technology Creation, innovation, and research POSITIONS SUPERVISED: none BASIC KNOWLEDGE & TRAINING REQUIRED FOR MAXIMUM PROFICIENCY: Possesses strong analytical and troubleshooting skills Knowledge of SQL and data warehousing concepts Ability to use presentation, word processing, and database or spreadsheet software Demonstrated attention to detail on ensuring the accuracy and efficiency of the data warehouse and the individual work units …