Business Intelligence Developer II
15d8ecda-48af-4ef3-b87f-5c30d3cf5c69:19000101_000001 · Wallingford, CT, US ·
- Category
- Data analytics
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
DIGITAL LITERACY:
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 five years 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.
Position Wage Range - $80,577 - $108,000
Benefits include medical, dental and vision insurance, 401(k) with employer match, paid time off, paid holidays and other fringe benefits. Note that specific benefit entitlements are dictated by the terms of the plan documents and may be changed at the sole discretion of the Company.
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.
Ascend Bank participates in E-Verify.
EOE/AA/M/F/D/V