Senior Associate, Database Engineer

At BNY, our culture empowers you to grow and succeed. As a leading global financial services company at the center of the world’s financial system we touch nearly 20% of the world’s investible assets. Every day around the globe, our 50,000+ employees bring the power of their perspective to the table to create solutions with our clients that benefit businesses, communities and people everywhere.

We continue to be a leader in the industry, awarded as a top home for innovators and for creating an inclusive workplace. Through our unique ideas and talents, together we help make money work for the world. This is what #LifeAtBNY is all about.

We’re seeking a future team member for the role of Senior Associate, Database Engineer to join our Insight Investment team. This role is located in Chennai, Tamil Nadu – HYBRID.

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

• Candidates should possess a blend of technical expertise, client & regulatory reporting knowledge, and collaborative skills to excel in this role.
• Asset Management or similar FS experience.
• Technical SQL & Data leadership.
• Extensive & proven technical skills with MS SQL Server (or similar RDBMS), data warehousing and ETL tools and advanced T-SQL skills.
• Microsoft Azure cloud experience (or similar). Use of cloud data tools – e.g. ADLS, ADF and Data Bricks etc would be beneficial.
• Jira & Confluence (or similar).
• PowerShell / Bat files / VBA.
• A good understanding of data modelling, data pipelines and workflow.
• Knowledge of data quality and governance approaches.
• Comfortable working with remote stakeholders and colleagues using state of the art collaboration technology.
• Software development experience in a commercial environment with exposure to all phases of the software development lifecycle.
• Experience as lead technician within an implementation project team and exposure to different project methodologies.
• Stand by software engineering principles around quality and doing things the right way.
• Stakeholder relationship management.
• Analysis & requirements gathering as required.
• Experienced of building effective relationships within and across IT teams.
• Able to work with incomplete information when determining business solutions taking into account relevant dependencies, timing and constraints.
• Able to produce functional requirements, high level design and detailed design specifications when needed to support project processes and delivery requirements.
• Experience working in Agile teams performing iterative development.
• Ability to collaborate with end users, stakeholders, and team members.
• Demonstrate initiative and independence to solve problems.
• Have a constant desire to improve knowledge and drive adoption of new tech or approaches within the team.
• Evidence or demonstrate the ability to learn new technologies and tools.
• Own mistakes and work with your colleagues to redress them, learn from them, and make improvements for the long-term.
• Be able to communicate abstract or complex ideas or solutions effectively.

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

• Design, implement, and optimize SQL database objects and data models tailored to support client & regulatory reporting requirements. Ensure that database structures are designed to efficiently store and retrieve the data necessary for client & regulatory reporting, including transaction & position reporting, portfolio holdings, performance metrics and account activity.
• Develop and maintain ETL processes to extract data from various sources such as Northern Trust (3rd party back office provider), various order management systems and market data providers. Transform raw data into standardized formats suitable for client & regulatory reporting, applying data validation and enrichment rules as necessary.
• Establish and enforce data quality controls to validate the accuracy, completeness, and consistency of data used in client & regulatory reports. Conduct regular data reconciliation checks and audits to identify and resolve discrepancies in a timely manner.
• Work closely with other team members including business analysts to successfully implement client & regulatory reporting solutions to budget, scope and timescale.
• Create high level and detailed functional and technical designs, build, document, test and implement components as required.
• Develop solutions in accordance with Insight standards and deliver solutions that meet the existing Insight change management processes.
• Maintain detailed documentation of client & regulatory reporting processes, data lineage, and system configurations in accordance with internal policies and regulatory requirements. Ensure compliance with FCA/PRA guidelines, ESMA directives, and other relevant regulatory mandates governing data management and reporting practices.
• Stay abreast of client & regulatory developments and changes impacting the UK & US asset management industry. Assess the impact of regulatory updates on existing reporting processes and systems and collaborate with stakeholders to implement necessary enhancements and adjustments.
  
  At BNY, our culture speaks for itself. Here’s a few of our awards:
• America’s Most Innovative Companies, Fortune, 2024
• World’s Most Admired Companies, Fortune 2024
• Human Rights Campaign Foundation, Corporate Equality Index, 100% score, 2023-2024
• Best Places to Work for Disability Inclusion, Disability: IN – 100% score, 2023-2024
• “Most Just Companies”, Just Capital and CNBC, 2024
• Dow Jones Sustainability Indices, Top performing company for Sustainability, 2024
• Bloomberg’s Gender Equality Index (GEI), 2023

Our Benefits and Rewards:

BNY 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, including paid volunteer time, that can support you and your family through moments that matter.

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