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.
GENERAL DESCRIPTION OF DUTIES:
Data Modeling BI and Data Warehousing solutions
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
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
Demonstrated detailed knowledge of BI areas including ETL design, analytics and reporting
Possesses strong oral and written communication skills, clearly and accurately communicating complex and/or technical information to both technical and nontechnical audiences
Self-motivated; able to work within a project-based environment
Ability to work in a team environment
MS SQL Server, Integration Services and Reporting Platform(s)
Strong TSQL scripting abilities and understanding of complex stored procedures, views, data aggregation/manipulation through table joins/queries, database design, normalization and de-normalization techniques
Demonstrated experience in data extraction and manipulation, ETL techniques required
Here at GSB, your achievements are recognized. We provide the tools and support to ensure that our employees develop their skills, attain their goals, and reach their full potential. Find out why our employees call us “an employer of choice.”
BENEFITS:
Competitive salary
Comprehensive Benefits Package including:
Medical Insurance w/Employer HSA Contributions
Dental Insurance
Vision Insurance
401(K) w/ generous company match
Annual Incentive Program
And More!
