Power BI & Data Warehouse Specialist

Ascend; Wallingford, Northern (CT, KY); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Ascend Bank in Wallingford, CT, is seeking a BI Developer II to design and implement enterprise BI solutions. The role focuses on building and maintaining Power BI reports, semantic models, and data visualizations to support decision-making across the organization.

The candidate will model data, optimize data warehouse processes, and collaborate with end users to extract requirements, while ensuring security, data quality, and performance across SQL Server-based environments.

Qualifications

• 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 knowledge of BI areas including ETL design, Power BI development, analytics, reporting, data visualization, and semantic model design.
• Strong oral and written communication skills with both technical and nontechnical audiences.
• Self-motivated; able to work within a project-based environment.
• Ability to work in a team environment.
• Proficiency with MS SQL Server, Integration Services, Power BI, and enterprise reporting platforms.
• Experience designing and maintaining Power BI semantic models, including star schema, relationships, and reusable datasets.
• Strong T-SQL scripting and understanding of stored procedures, views, and data manipulation.
• Experience in data extraction and ETL techniques.

Responsibilities

• Data Modeling BI and Data Warehousing solutions.
• Develops and maintains Power BI reports, dashboards, and data visualizations.
• Designs, develops, and maintains Power BI semantic models and datasets.
• Performs debugging and problem solving for data warehousing solutions.
• Assist in implementing analytics practices to improve decision making and performance.
• Communicate requirements with nontechnical business users for reports and BI solutions.
• Coordinate with technical staff to ensure database integrity, security and performance.
• Identify and resolve data quality issues and data reconciliation.
• Participate in planning and problem resolution activities.
• Develop and enforce standards for data storage and retrieval.
• Work with staff to resolve data discrepancies and clarify reporting procedures.
• Maintain inventory of data, systems, and storage.
• Process data extracts using data retrieval and management tools.
• Protect confidential information.

Skills

SQL

Power BI

ETL

Data warehousing

Analytics

Data visualization

Communication

Teamwork

MS SQL Server

Integration Services

Education

Bachelor's degree in Information Technology, business intelligence, mathematics or software development

Tools

MS SQL Server

Integration Services

Power BI

Enterprise reporting platforms

Job description

Ascend Bank in Wallingford, CT, is seeking a BI Developer II to design and implement enterprise BI solutions. The role focuses on building and maintaining Power BI reports, semantic models, and data visualizations to support decision-making across the organization.

The candidate will model data, optimize data warehouse processes, and collaborate with end users to extract requirements, while ensuring security, data quality, and performance across SQL Server-based environments.