Senior ETL Developer
Bring your ideas. Make history.
BNY Mellon offers an exciting array of future-forward careers at the intersection of business, finance, and technology. We are one of the world’s top asset management and banking firms that manages trillions of dollars in assets, custody and/or administration. Known as the “bank of banks” – 97% of the world’s top banks work with us as we lead and serve our customers into the new era of digital.
With over 238 years of rich history and industry firsts, BNY Mellon has been built upon our proven ability to evolve, lead, and drive new ideas at every turn. Today, we’re approximately 50,000 employees across 35 countries with a culture that empowers you to grow, take risks, experiment and be yourself. This is what #LifeAtBNYMellon is all about.
We’re seeking a future team member in the role of Senior ETL Developer to join our Corporate Technology team. This role is located in New York/New Jersey, USA.
In this role, you’ll make an impact in the following ways:
- Develop data jobs and transformation using Pentaho.
- Analyze user requirements and database schema to determine technical design specifications for data transformation and integration.
- Troubleshoot any issues identified in the application during testing or production phases.
- Collaborate with other developers in an agile environment to ensure successful delivery of the application.
- Document development processes
- Provide technical leadership to junior developers.
- Participate in code reviews and provide feedback.
- Test data workflows to ensure quality and performance.
To be successful in this role, we’re seeking the following:
- BA Degree in Computer Science, Information Technology, or related fields
- 3+ Year Pentaho development preferred (Informatica/Ab Initio/Alteryx possible)
- Experience with databases such as Oracle, Vertica or MongoDB
- Ability to work independently and in team environment with local and remote developers.
- Ability to quickly adapt to changing requirements and technologies.
- Excellent written and verbal communication skills
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)
- Human Rights Campaign Foundation, 100% score Corporate Equality Index
- Best Places to Work for Disability Inclusion, Disability: IN – 100% score
- 100 Best Workplaces for Innovators, Fast Company
- 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.
Consults with internal business groups to provide appropriate application software development services or technical support. Provides application software development services or technical support in more complex situations. May also be responsible for requirements gathering and BRD/SRD preparation. Has thorough knowledge of the Software Development Life Cycle. Conducts reviews of the test Plan and test Data. May allocate/ coordinate work within a team/project. The job holder leads the technical design, development and documentation of cross-functional, multi-platform application systems. S/he analyzes, defines and documents requirements for data, workflow, and logical processes and interfaces with other systems. S/he also ensures that expected application performance levels are achieved by coordinating, coding, testing, implementation and documentation. Design and development of backend features and components. Scaling the backend architecture and codebase to support growth. Reducing the level of technical debt of the backend codebase.Programming well-designed, testable, efficient code. Analyze, design and develop tests and test-automation suites. Develop flowcharts, layouts and documentation to satisfy requirements and solutions. Maintain software functionality and currency (technical debt and gain). Actively participate in code reviews. Integrate software components into a fully functional software system. Apply security and privacy principles.Execute full lifecycle software development. Develop software verification plans and quality assurance procedures. Troubleshoot, debug and upgrade existing systems. Ensure software is updated with latest features. Participate in deployment process following all change controls. Provide ongoing maintenance, support and enhancements in existing systems and platforms. Provide recommendations for continuous improvement.Active learning engagement. Complete all required mandatory training / policy awareness curricula on time. Use learning tools such as Pluralsight to complete both recommended and aspirational targets set in personal development plans.Demonstrate team work. Leverage existing products/functionality and promote reuse. Work alongside other engineers on the team to elevate technology and consistently apply best practices. Collaborate closely with all the other members of the team to take shared responsibility for the overall efforts that the team has committed to. Collaborate cross-functionally with data engineers, business users, project managers and other engineers to achieve elegant solutions. Utilize local meetups to gain and share knowledge.Compiles documentation written by more senior developers of all procedures used in system. Acts as mentor to junior level engineers.Prior experience with using a specific application development toolkit and knowledge of a backend development language required (i.e. C#, Java) S/he must have knowledge about the functions and features of modern and traditional structured methods for developing applications.Communications and organization skills; team work skills.Contributes to the achievement of area objectives.MODIFIED BASED UPON LOCAL REGULATIONS/REQUIREMENTSBachelor’s degree in computer science engineering or a related discipline, or equivalent work experience required.7-9 years of experience in software development required; experience in the securities or financial services industry is a plus. Job holder must have understanding interdependencies and business impact of future IT plans. S/he must have prior lead experience selecting and implementing vendor-specific methodologies and prior consulting experience with structured methodologies. Extensive experience with developing and supporting backend environment required. Job holder must have broad experience with multi-platform development tools and toolkits.. 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.
BNY Mellon assesses market data to ensure a competitive compensation package for our employees. The base salary for this position is expected to be between $91,000 and per year at the commencement of employment. However, base salary if hired will be determined on an individualized basis, including as to experience and market location, and is only part of the BNYM total compensation package, which, depending on the position, may also include commission earnings, discretionary bonuses, short and long-term incentive packages, and Company-sponsored benefit programs.
This position is at-will and the Company reserves the right to modify base salary (as well as any other discretionary payment or compensation) at any time, including for reasons related to individual performance, change in geographic location, Company or individual department/team performance, and market factors.
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.