Database and ETL Pentaho Engineer

We're seeking a future team member in the role of Specialist Database and ETL Pentaho Engineer to join our Data Operations Engineering team. This role is in CITY, Pittsburgh, PA - HYBRID.

Data Operations Engineering, part of BNYM Global Enterprise Data Management, are looking for a Lead Database and ETL Pentaho Engineer to work within their Data Insights and Engineering team. We are a team that drive business results using data as the actual product or service .

Data Engineering are focused on developing high quality, efficient ETL that integrates with our core systems and supports our focus on bringing efficiency to operational processes and removing manual effort. Our challenges include building pipelines to ETL data from multiple sources, improve database queries and ETL performance, all while ensuring our solutions are fully automated, cost effective and scalable. Our team build re-useable micro services and operate continuous improvement of existing processes.

In this role, you'll make an impact in the following ways:

• Your role within the team would see you working closely with our business analysis and operations team from start to finish, analysing, designing code, and developing tests within the ETL environment.
• You would have a thorough knowledge of the software development lifecycle and would work to develop flow charts, layouts, and documentation to satisfy the requirements and solutions.
• You would l everage existing products/functionality and promote reuse, work alongside other engineers on the team to elevate technology and consistently apply best practices.
• You would collaborate closely with all the other members of the team to take shared responsibility for the overall efforts that the team has committed to. You would collaborate cross-functionally with data engineers, business users, project managers and other engineers to achieve elegant solutions .

To be successful in this role, we're seeking the following:

• Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience required
• 2-6 years of experience in software development required, 2+ years in Pentaho ETL tooling, or equivalent would be considered.
• 2+ years' experience with advanced SQL (analytical queries) preferred PL-SQL and Oracle
• Experience in the securities or financial services industry is a plus

At BNY Mellon, our inclusive culture speaks for itself. Here's a few of our awards:

• Fortune World's Most Admired Companies & Top 20 for Diversity and Inclusion
• Bloomberg's Gender Equality Index (GEI)
• Best Places to Work for Disability Inclusion , Disability: IN - 100% score
• 100 Best Workplaces for Innovators, Fast Company
• Human Rights Campaign Foundation, 100% score Corporate Equality Index
• CDP's Climate Change 'A List'

Our Benefits:

BNY Mellon offers highly competitive compensation, benefits, and wellbeing programs rooted in a strong culture of excellence and our pay-for-performance philosophy. We provide access to flexible global resources and tools for your life's journey. Focus on your health, foster your personal resilience, and reach your financial goals as a valued member of our team, along with generous paid leaves that can support you and your family through moments that matter.

BNY Mellon is an Equal Employment Opportunity/Affirmative Action Employer - Underrepresented racial and ethnic groups/Females/Individuals with Disabilities/Protected Veterans.

. Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience required. 2-6 years of experience in software development required; experience in the securities or financial services industry is a plus; should have thorough knowledge of the software development cycle S/he must also have experience developing mainframe applications. Job holder must be knowledgeable about cross-platform interoperability (multiple platforms. NT, Intranet, etc.) , major tools in a toolkit for a specific platform and features of multiple toolkits. S/he must be experienced at resolving hardware, software, and communications malfunctions and understand the business impact of resolving complications. BNY Mellon is an Equal Employment Opportunity/Affirmative Action Employer. Minorities/Females/Individuals with Disabilities/Protected Veterans. Our ambition is to build the best global team - one that is representative and inclusive of the diverse talent, clients and communities we work with and serve - and to empower our team to do their best work. We support wellbeing and a balanced life, and offer a range of family-friendly, inclusive employment policies and employee forums.

Employer Description:

For over 230 years, the people of BNY Mellon have been at the forefront of finance, expanding the financial markets while supporting investors throughout the investment lifecycle. BNY Mellon can act as a single point of contact for clients looking to create, trade, hold, manage, service, distribute or restructure investments and safeguards nearly one-fifth of the world's financial assets. BNY Mellon remains one of the safest, most trusted and admired companies. Every day our employees make their mark by helping clients better manage and service their financial assets around the world. Whether providing financial services for institutions, corporations or individual investors, clients count on the people of BNY Mellon across time zones and in 35 countries and more than 100 markets. It's the collective ambition, innovative thinking and exceptionally focused client service paired with a commitment to doing what is right that continues to set us apart. Make your mark: bnymellon.com/careers.

EEO Statement:

BNY Mellon is an Equal Employment Opportunity/Affirmative Action Employer. Minorities/Females/Individuals With Disabilities/Protected Veterans. Our ambition is to build the best global team - one that is representative and inclusive of the diverse talent, clients and communities we work with and serve - and to empower our team to do their best work. We support wellbeing and a balanced life, and offer a range of family-friendly, inclusive employment policies and employee forums.