Business Intelligence Data Engineer

Overview

Business Intelligence Data Engineer
Canandaigua National Bank

Location:

Pittsford, NY (Hybrid, 3 days onsite/2 work from home)

The BI Data Engineer provides key data solutions to facilitate effective operations at Canandaigua National Bank. The Data Engineer is responsible for collaborating with business stakeholders, database administrators, data scientists, and other Business Application groups to define, design, and implement data solutions and resolve inconsistencies within models or existing records.

The Data Engineer works closely with other members of the Business Intelligence team as well as IT Operations to facilitate and execute goals related to data governance.

The Data Engineer also collaborates with IT Operations and Business Applications to develop, maintain, and explore data solutions using Microsoft Data and novel data solution products.

• 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 integrations 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 ensure compliance within 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.
• Suggets data warehouse enhancements and operations including tables, views, stored procedures, 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.
• 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 enhancement.
• 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 applicability within the firm’s BI strategy, program, and architecture.
• Maximizes CNC’s ongoing investment in BI technologies by evaluating features, staying attuned to vendor announcements, upgrades, and updates. Ensures BI infrastructure is maintained and updated as needed.
• Creates and maintains BI program documentation including policies, standards, baselines, guidelines, and procedures; incorporates documentation maintenance 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 BI issues.
• Manages and participates in BI projects, following standard project management processes and controls.
• Coordinates specific work tasks with other personnel within the department and with other departments to ensure smooth information flow.
• Diligently protects the confidentiality of customer information and other highly sensitive data seen during BI duties.
• Participates in CNB IT On-Call Program for overnight data services.
• Communicates with management and staff to align goals and activities.
• Responds to inquiries relating to their area, or requests from Bank personnel, customers, etc., within given time frames and established policy.
• Maintains appropriate records and provides assigned reports.

• Bachelor’s degree in Computer Science, Management Information Systems, Data Science, Data Analytics, or…