Business Intelligence Developer II

Ascend Bank • Wallingford, CT

41d

About The Position

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.

Requirements

• 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
• 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.

Nice To Haves

• Experience in the banking field desired.
• Certification or expertise with cybersecurity is a plus.

Responsibilities

• 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

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree