Canandaigua National Bank · 23 hours ago
Business Intelligence Data Engineer
BASIN PARK 1160, Pittsford, NY, US
Full-time
Hybrid
Senior Level, Lead/Staff
$95K/yr - $118K/yr
8+ years expCanandaigua National Bank is a community bank dedicated to providing exceptional service to its customers. They are seeking a Business Intelligence Data Engineer to develop and maintain data solutions that support effective operations, ensuring data governance and compliance while working closely with business stakeholders and IT Operations.
BankingFinancial Services
Responsibilities
Develops and maintains data integrations between multiple data services hosted in cloud services and data servers hosted on-premises
Develops and implements new data models and integration to meet business and compliance needs
Writes and documents SQL queries and operations to meet project goals and IT support tasks
Works with data governance team members to instill compliance within the governance rules including maintenance of data dictionaries, data classification, and implementing data security measures
Designs, develops, and populates data objects such as SQL Server Analysis Services (SSAS) cubes, relational dimensional databases, and SSAS data mining models
Designs and builds data models to support self-service BI
Suggests data warehouse enhancements and operations including table, view, stored procedure, ETL, and other changes
Designs, develops, monitors, and maintains ETL processes within the data warehouse and BI data objects
Identifies and examines poorly performing SQL queries and processes. Designs and develops improvements in SQL to improve performance of any poorly performing SQL queries and procedures
Meets with Lines of Business and Business Analysts to define data-driven goals using data integrations with existing and novel systems
Provides updates to the corporate data dictionary and data classification
Follows standard change management processes and version control in moving code from development to test/QA and to production environments
Researches, reviews, and analyzes the effectiveness and efficiency of existing reporting and ETL procedures and develops strategies for enhancing or further leveraging these processes
Follows appropriate incident, problem, change management, and project processes
Mentors less experienced BI developers
Identifies and assesses emerging BI trends within financial services and across industries. Evaluates these for applicability within the firm’s BI strategy, program, and architecture
Maximizes CNC’s ongoing investment in BI technologies by evaluating available features, staying attuned to vendor announcements, upgrades, and updates. Ensures the BI infrastructure is maintained and updated as needed
Creates and maintains BI program documentation including policies, standards, baselines, guidelines, and procedures. Incorporates the maintenance of this documentation into project life cycles
Acts as the primary owner for reviewing data inconsistencies. Works with subject matter experts for the data source to troubleshoot and perform root cause analysis for all BI issues originating from these systems
Manages and participates in BI projects, following standard project management processes and controls for all projects
Coordinates specific work tasks with other personnel within the department as well as with other departments to ensure the smooth and efficient flow of information
Diligently protects the confidentiality of customer information and other highly sensitive data which may be seen while performing the duties of the Senior Business Intelligence database developer
Participates in CNB IT On-Call Program for overnight data services
Communicates with management and staff personnel to integrate goals and activities
Responds to inquiries relating to their area, or to requests from other Bank personnel, customers, etc., within given time frames and within established policy
Maintains appropriate records and provides assigned reports
Qualification
Required
Bachelor's degree in either Computer Science, Management Information Systems, Data Science, Data Analytics, or related field or equivalent combination of education and work experience
A minimum of eight (8) years' experience in related positions is required
Specialized server and database administration education and training
Demonstrated ability to communicate comfortably and at appropriate level of summary and detail to varied audiences
Extensive knowledge in writing efficient SQL queries and with SQL query performance tuning
Knowledge of Data Lakes and integration methodologies
Thorough knowledge of MS-SQL BI components (SSMS, SSIS, SSAS, SSRS, PowerBI, and T-SQL) required
Knowledge of data structures and working with structured and non-structured data
Understanding of basic data governance principles
Knowledge of software development processes and best practices
Experience in data warehouse design and architecture
Experience with Microsoft SQL products is essential
Preferred
Experience in Financial Services preferred
Experience in Cloud Computing for Data Services is preferred
Benefits
Medical, dental, vision, FSA, HSA options for both part-time and full-time employees. Medical coverage is also offered for domestic partners.
Paid holidays, vacation, and sick time.
Retirement benefits that include a 401(k), Profit Sharing, and Employee Stock Ownership Plan (ESOP).
Training & development opportunities.
Tuition assistance.
Community focused volunteer opportunities.
Award winning wellness program that promotes a solid work/life balance.
Banking perks and discount programs.
Company
Canandaigua National Bank
Canandaigua National Bank offers a full range of financial services to realize a financial life, well lived.
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
Tamra O’Donnell
Senior Vice President - Director, Corporate Marketing
Jeffrey Eades
Vice President Business Banking
Recent News
2026-01-20
Central New York Business Journal
2026-01-18
Central New York Business Journal
2025-11-09
Company data provided by crunchbase