Business Intelligence Developer II

Business Intelligence Developer

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

Demonstrated detailed knowledge of BI areas including ETL design, Power BI development, analytics, reporting, data visualization, and semantic model design

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, Power BI, and enterprise reporting platforms

Demonstrated experience designing and maintaining Power BI semantic models, including dimensional/star-schema design, relationships, DAX measures, hierarchies, and reusable enterprise reporting datasets

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

Experience:

Three to five years of similar or related experience.

Hands-on experience developing Power BI solutions and designing semantic models for business intelligence and analytical reporting.

Experience in the banking field desired.

Education: Requires a four-year college degree in Information Technology, business intelligence, mathematics or software development or equivalent specialized training.

Certification or expertise with cybersecurity is a plus.

Compensation: Compensation is based on our market pay structures. However, individual salaries are determined by a variety of factors including, but not limited to business considerations, local market conditions, and internal equity, as well as candidate qualifications, such as skills, education, and experience.

Ascend Bank is an equal opportunity employer and offers equal opportunity to all applicants for all positions without regard to race, color, religion, national origin, age, disability, and veteran status.

Applicants requiring reasonable accommodation in the application process should notify Human Resources.

Ascend Bank participates in E-Verify.

EOE/AA/M/F/D/V