Reporting & Analytics Lead

Company Description

Israel Discount Bank of New York, also known by its registered service mark, “IDB Bank”, is a full service commercial bank chartered by the State of New York and a member of the Federal Deposit Insurance Corporation (FDIC). Our liquidity and capital ratios are strong, and we are ranked by Crain’s New York Business as the 14th largest commercial bank in the New York area. the Bank provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, sexual orientation, national origin, age, disability, genetic status, citizenship status, marital status, military or veteran status, current unemployment or any other legally protected category in accordance with applicable federal, state and local law.

*Candidates must reside in or relocate to NY as this is a hybrid position

Job Description

This position is responsible for performing the duties of Analytics & Reporting Lead working closely with onshore/offshore team.

Responsibilities include

• Lead the development and implementation of data engineering and analytics strategies to support bank-wide decision-making and performance improvement.
• Oversee the design, execution, and delivery of high-quality, comprehensive reports and dashboards using Cognos, Tableau, and Qlik Sense, ensuring data accuracy and actionable insights.
• Manage the end-to-end analytics workflow, including data collection, processing, analysis, and insight generation, to inform and guide strategic planning and operational improvements.
• Direct a team of data analysts and engineers, providing mentorship and development opportunities, ensuring a high level of team performance and data science expertise.
• Collaborate with IT, business units, and senior management to identify opportunities for leveraging bank data to drive business solutions and innovations.
• Ensure the integrity, confidentiality, and security of all data repositories, reports, and analytics tools in compliance with industry regulations and best practices.
• Lead the evaluation and adoption of new technologies, methodologies, and practices in data engineering and analytics to enhance the bank's data capabilities.

This will be a highly dynamic environment where an energetic positive attitude, multi-tasking and the ability to jump in and add value is a requirement.

#LI-Hybrid

Qualifications

• Minimum of 10 years of experience in Business Intelligence, Reporting, and Analytics, with hands-on development experience.
• Proven track record of leading data engineering teams in a banking or financial services environment.
• Extensive experience with BI tools such as Cognos, Qlik Sense, and Tableau.
• Strong background in SQL, including 7+ years of experience with SQL Server and Oracle databases.
• Expertise in Unix Shell scripting, with at least 7 years of experience.
• Knowledgeable in database management, data analysis, and report building practices.
• Familiarity with Agile methodologies and project management tools like JIRA.
• Experience in data modeling and the use of tools such as Erwin Data Modeler.
• Proficient in the use of job scheduling software, preferably Cybermation Job Scheduler.
• Demonstrated ability to translate business needs into data engineering solutions.

Skills:

• 10+ years of Expertise in Cognos, Qlik Sense, and Tableau for advanced data visualization and reporting.
• 5+ years of hands-on experience in designing Cognos Data Framework Manager
• 8+ years of Advanced SQL skills and experience with SQL Server & Oracle databases.
• Proficiency in Unix Shell scripting for data processing and automation.
• Strong analytical and problem-solving abilities, with a keen attention to detail.
• Leadership and team management skills, with the ability to mentor and develop talent.
• Excellent communication and collaboration skills, capable of working effectively with cross-functional teams.
• Knowledge of data privacy and security principles, ensuring compliance with regulations.
• Ability to manage multiple projects simultaneously, prioritizing tasks to meet deadlines.
• Strategic thinking and decision-making capabilities, driven by data insights.
• Continuous learning mindset, staying updated with the latest in technology and data management trends.
• 4 years Bachelor Degree in Computer Science or equivalent

Technologies:

Business Intelligence Tools: Cognos, Tableau, Qlik Sense

ETL and Data Integration: Informatica IDMC, Informatica ETL

Database Management: SQL Server (SSMS, SSRS, SSIS), Oracle SQL, PL/SQL

Scripting and Automation: Unix Shell Scripting

Project Management and Collaboration: BitBucket, Jenkins, JIRA Agile framework

Data Modeling: Cognos Data framework Manager

Job Scheduling: Cybermation Job Scheduler

Tools: Cognos 8.1 & 8.3 (Framework Manager, Cognos connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Access Manager), Qlik Sense, Microsoft SSAS, Microsoft SSRS, JIRA, Confluence, Unix, Cognos Data framework Manager, BitBucket, Jenkins, SSMS

Compensation:

The expected annual salary for this position is between $110,000 - $150,000 at the start of employment. A salary offer is determined on an individualized basis, taking into consideration factors such as an individual’s skills and experience. In addition to base salary, our total rewards package also includes eligibility for an annual bonus, medical, pharmacy, dental, and vision plans, life and disability insurance, employee wellness program, retirement and savings plans with employer contributions, generous holiday and paid time off schedules, parental leave, and tuition reimbursement.

Additional Information

The Bank will make reasonable accommodations to the following employees to allow them to perform the essential functions of their position, except where doing so would result in undue hardship to the Bank:

• Those with a known mental or physical disability.
• Pregnant individuals and/or individuals with pregnancy or childbirth-related medical conditions.
• Victims of domestic violence, sex offenses or stalking.
• Employees with religious observance and practice obligations.

Any employee who believes he or she needs an accommodation for any of the above reasons should contact their supervisor or a member of Human Resources to request such an accommodation. In each case, the Bank will engage in a good faith written or oral dialogue concerning the individual’s accommodation needs; potential accommodations that may address the individual’s accommodation needs, including alternatives to a requested accommodation; and the difficulties that such potential accommodations may pose for the employer.

The Bank retains the ultimate discretion to choose the appropriate reasonable accommodation. Upon reaching a final determination at the conclusion of the cooperative dialogue, the Bank will provide the requesting individual with a written final determination identifying any accommodation granted or denied. In addition, the Bank will maintain any information regarding the employee’s request and status in the strictest confidence, except as requested by the employee, as required on a need-to-know basis or as otherwise required by law.

Disclaimer

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.

All your information will be kept confidential according to EEO guidelines.

Due to COVID-19, we are now operating on a hybrid schedule. We value the safety of our employees because we’re all in this together.

NO AGENCIES PLEASE.

IDB BANK, INCLUDING ITS SUBSIDIARIES AND DIVISIONS, PROVIDES EQUAL EMPLOYMENT OPPORTUNITIES TO ALL EMPLOYEES AND APPLICANTS FOR EMPLOYMENT WITHOUT REGARD TO RACE, COLOR, RELIGION, SEX, SEXUAL ORIENTATION, NATIONAL ORIGIN, AGE, DISABILITY, GENETIC STATUS, CITIZENSHIP STATUS, MARITAL STATUS, MILITARY OR VETERAN STATUS, CURRENT UNEMPLOYMENT OR ANY OTHER LEGALLY PROTECTED CATEGORY IN ACCORDANCE WITH APPLICABLE FEDERAL, STATE AND LOCAL LAW. NOTHING IN THIS SITE CONSTITUTES A PROMISE OR OFFER OF EMPLOYMENT.

Videos to Watch

IDB BANK, INCLUDING ITS SUBSIDIARIES AND DIVISIONS, PROVIDES EQUAL EMPLOYMENT OPPORTUNITIES TO ALL EMPLOYEES AND APPLICANTS FOR EMPLOYMENT WITHOUT REGARD TO RACE, COLOR, RELIGION, SEX, SEXUAL ORIENTATION, NATIONAL ORIGIN, AGE, DISABILITY, GENETIC STATUS, CITIZENSHIP STATUS, MARITAL STATUS, MILITARY OR VETERAN STATUS, CURRENT UNEMPLOYMENT OR ANY OTHER LEGALLY PROTECTED CATEGORY IN ACCORDANCE WITH APPLICABLE FEDERAL, STATE AND LOCAL LAW. NOTHING IN THIS SITE CONSTITUTES A PROMISE OR OFFER OF EMPLOYMENT.

IDB BANK, INCLUDING ITS SUBSIDIARIES AND DIVISIONS, PROVIDES EQUAL EMPLOYMENT OPPORTUNITIES TO ALL EMPLOYEES AND APPLICANTS FOR EMPLOYMENT WITHOUT REGARD TO RACE, COLOR, RELIGION, SEX, SEXUAL ORIENTATION, NATIONAL ORIGIN, AGE, DISABILITY, GENETIC STATUS, CITIZENSHIP STATUS, MARITAL STATUS, MILITARY OR VETERAN STATUS, CURRENT UNEMPLOYMENT OR ANY OTHER LEGALLY PROTECTED CATEGORY IN ACCORDANCE WITH APPLICABLE FEDERAL, STATE AND LOCAL LAW. NOTHING IN THIS SITE CONSTITUTES A PROMISE OR OFFER OF EMPLOYMENT.