Senior BI Developer: Power BI & Data Warehousing

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

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.