Database Administrator

Company Overview:

Peapack Private Bank & Trust is a leader in wealth, lending and deposit solutions. At Peapack Private, our clients are cared for by a single point of contact and are served by empowered employees who consistently go above and beyond to provide exceptional service and offer a boutique private banking experience.

What makes Peapack Private different? We are an institution that has always believed in putting the well-being and needs of our employees and our clients first. We are proud to be recognized for the seventh consecutive year by American Banker as one of the "Best Banks to Work For" across the nation. In addition, we were selected as Crain's Best Places to work in NYC for our inaugural year, 2024. Our secret sauce in one word is our 'culture'.

At Peapack Private, we value a diverse and inclusive workspace, deeply committed to growing leaders at all levels of the organization thorough mentorship, career pathing, and professional development. There are multiple ways to build relationships and get involved - from joining our Cultural Ambassador Committee focused on areas like Wellness, Fun, Inclusion, or Environmental Awareness - to involvement in community service activities through Volunteerism. Said quite simply, the culture and the people who work here are amazing!

Department Overview:

Our Technology group encompasses IT and Data Analytics. The office of data and analytics is positioned at the Nexus of the front office bank business and operational technology. ODA is responsible for enterprise CRM data-driven business campaigns cloud based digital workflow development data governance and data security The ODA partners with the business to supercharge the way we work. Information technology is a critical part of bank operations across all business lines. IT deploys, manages, and supports the bank's technology solutions .

Position Overview:

Responsible for managing and optimizing the organization's Enterprise Data Warehouse infrastructure. This role ensures that large volumes of financial data are stored securely and are readily available to authorized users, while maintaining the data's confidentiality, integrity, and availability (CIA). The administrator will lead data cleanup and quality initiatives to improve data accuracy and support business needs and will collaborate with cross-functional teams to ensure the data warehouse supports reporting and analytics across the bank.

Key Responsibilities:

• Oversee operation of Enterprise Data Warehouse built on Microsoft SQL and Microsoft Fabric. Includes optimizing performance, monitoring data imports, and integrating new data.
• Manage and support ETL (Extract, Transform, Load) processes that feed data into the warehouse from various banking systems. Ensure that data pipelines are running on schedule and that data from source systems (e.g. transaction processing systems, CRM, core banking software) is properly transformed and loaded into the warehouse without errors.
• Plan and execute long term architectural roadmap for Data Warehouse, including cloud migration.
• Implement and enforce data management standards and procedures to ensure data is consistent, accurate, and secure. Apply the principles of data confidentiality, integrity, and availability by controlling access to sensitive financial data, protecting against unauthorized access, and ensuring reliable data backups and restoration processes.
• Lead data cleanup initiatives to purge or correct inaccurate and outdated information and to merge duplicate records, thereby improving overall data quality and warehouse efficiency. Perform data audits and use scripts or tools to clean and transform data as needed.
• Work closely with data analysts, BI developers, and business stakeholders to understand reporting requirements and ensure the data warehouse can fulfill those needs. This may involve creating or optimizing database views, supporting the development of data marts or cubes, and ensuring data is structured for easy retrieval.
• Act as a liaison between database developers, data architects, and business analysts to translate business data requirements into effective warehouse solutions
• Develop, document, and maintain formal policies, procedures, and standards for the Enterprise Data Warehouse.
• Keep up-to-date on information technology industry trends
• Maintain the confidentiality of the bank and its customers

Qualifications:

• Bachelor's degree in computer science, information systems, business administration, or another related field
• Microsoft SQL and Power BI experience required
• Microsoft Fabric or similar cloud Data Warehouse solution experience preferred
• Cloud Migration and Management experience preferred
• Financial services experience preferred
• 2-5 years database experience
• Technical training or certification preferred
• Strong analytical skills and critical thinking
• Excellent oral and written communication skills
• Ability to work independently and with minimal supervision
• Experience managing a team preferred
• Maintain a neat and orderly work area
• Perform other related duties as assigned

Benefits Overview:

We offer a competitive compensation package, a generous paid time off program, comprehensive medical, dental and vision coverage, maternity/paternity leave, a hybrid work environment (for most roles), education reimbursement, wellness programs and more. We also offer participation in an Employee Stock Purchase Program and a 401K with a generous match.

The approximate pay range for this position is $97,692 to $143,000, plus an opportunity to earn performance-based incentives. Please note that the pay range provided is a good faith estimate for the position at the time of posting. Final compensation may vary based on factors including, but not limited to knowledge, skills and abilities, as well as geographic location.

Note: Incentives and/or benefits packages may vary depending on the position.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the notice from the Department of Labor.