Senior Database Engineer Associate Job in Pune at BNY Mellon Technology Pvt Ltd

BNY is hiring for the role of Senior Database Engineer Associate! 

Responsibilities of the candidate:

• 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.

Requirements:

• 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.