Business Intelligence Developer II

Ascend Bank; Wallingford (CT); On-site; USD 90,000 - 120,000; Full time

Job summary

Ascend Bank in Wallingford, CT is seeking a Business Intelligence Developer II to build and maintain Power BI reports and semantic models for enterprise reporting. You will work with end users to define requirements, design data models, and ensure data quality across the data warehouse.

The role emphasizes collaboration with IT and business teams, strong SQL/ETL skills, and a proactive approach to analytics and visualization.

Qualifications

• Strong analytical and troubleshooting skills.
• Knowledge of SQL and data warehousing concepts.
• Ability to use presentation, word processing, and database or spreadsheet software.
• Detail-oriented with focus on data accuracy.
• BI areas including ETL design, Power BI, analytics, reporting, data visualization, and semantic model design.
• Excellent verbal and written communication.
• Self-motivated and able to work in a team.
• Experience with Power BI semantic models and star schema.
• Strong TSQL scripting and complex queries.
• Experience in data extraction and ETL techniques.

Responsibilities

• Develops and maintains Power BI reports, dashboards, and visuals.
• Designs semantic models with star schema and relationships.
• Troubleshoots data warehousing solutions and code.
• Collaborates with users to gather requirements.
• Ensures data quality and security.
• Maintains data inventory and data storage practices.
• Supports planning and problem resolution.

Skills

SQL

Data Warehousing

Power BI

ETL Design

DAX Measures

Data Visualization

Communication Skills

Team Collaboration

Education

Four-year degree in IT/BI

Tools

MS SQL Server

SSIS

Power BI

Enterprise reporting tools

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Business Intelligence Developer II

Full Time Wallingford, CT, US

3 days ago Requisition ID: 1185

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

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