Business Intelligence Developer II

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

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.