Business Intelligence Data Engineer
Canandaigua National Bank
Location: Pittsford, NY (Hybrid, 3 days onsite/2 work from home)
What does a BI Data Engineer do?
The Business Intelligence (BI) Data Engineer provides key data solutions to facilitate the needs of effective operations of Canandaigua National Bank. The Data Engineer is responsible for working with business stakeholders, database administrators, data scientists, and other Business Application groups within Canandaigua National Bank to define, design, and implement data solutions and resolve inconsistencies within models or existing records.
The Data Engineer will work closely with other members of the Business Intelligence team as well as members of IT Operations to facilitate and execute goals related to data governance.
The Data Engineer will work 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 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.
What is needed to be successful in this role?
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.
Experience in Financial Services preferred.
Experience in Cloud Computing for Data Services is preferred.
What makes working at Canandaigua National Bank different?
Our Core Values guide how we serve, lead, and grow alongside our community. By working wholeheartedly, feeling empowered, acting with courage, being authentic, and serving with a noble spirit, WE CAN fortify healthy lives by doing what's right for our customers and the community.
Our culture nurtures passionate employees and offers great rewards including:
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.
Our goal is to ensure that our bank, employees, and our community thrive and grow, now and for the next 135 years. We're in it for the long haul. What truly sets us apart from other financial institutions is the quality and commitment of our employees. We've assembled a diverse team of people who share a primary focus: to provide exceptional service for our customers.
As an organization, we are committed to hiring, training, developing, promoting, and celebrating employees from historically disadvantaged groups. At Canandaigua National Bank, we welcome the unique contributions that you can bring in terms of ethnicity, race, sex, gender identity and expression, nation of origin, age, languages spoken, veteran's status, religion, disability, sexual orientation, education, and culture.
Canandaigua National Bank remains an independent, community bank. If you want to be a part of something special, join us today!
Compensation range - $95,000 - $117,500
The actual salary offered within the range is dependent on a variety of factors including, but not limited to, relevant experience, qualifications, skills, level offered, and performance expectations.
Canandaigua National Corporation and its subsidiaries encourage diversity in the workplace; we are an Equal Opportunity Employer. Minority/Female/Sexual Orientation/Gender Identity/Disability/Veteran.
