Job Description
In this role, you’ll make an impact in the following ways:
- Data Quality Control Execution: Build and implement Detective Data Quality Controls (DQCs) based on approved Data Quality Requirements (DQRs), run and monitor data quality controls in BAU, ensure controls align with defined business rules and relevant data quality dimensions, and maintain control logic as upstream data structures or source systems evolve.
- Multi‑Technology Data Quality Execution: Implement and operate data quality controls across Snowflake (SQL-based checks for platform datasets), SQL-based data sources outside Snowflake, and file-based data feeds including vendor and batch files; perform common file-based validations such as record count and reconciliation checks, mandatory field and null value checks, and basic format or structural validation; and ensure control outputs are consistent, interpretable, and suitable for effective operational monitoring.
- Investigation & Operational Support: Support L2 data quality investigations when controls fail or issues are escalated by analyzing data using SQL and file-based validation to determine whether failures represent genuine data issues, control logic defects, or upstream source or transformation changes; document findings clearly and update data quality incidents in ServiceNow; and escalate complex or structural issues to more senior team members where appropriate.
- Team Capability & Knowledge Sharing: Share technical knowledge and good practice within the Data Quality Management (DQM) team, support colleagues with SQL used for data quality controls and investigations, file-based data validation techniques, and understanding common control patterns and investigation approaches; contribute to documentation, examples, and reusable templates; provide informal coaching and peer support without formal line management responsibility; and work with Data Stewards and engineers to clarify rule intent where market data behavior is relevant.
To be successful in this role, we’re seeking the following:
Essential Skills:
- Strong SQL skills
- Experience running data quality checks
- Experience with Snowflake and file-based data
- Comfortable operating in BAU environments
Additional Skills:
- Bloomberg or market data exposure
- Securities or financial data experience
- Grafana or monitoring tool exposure
- Experience or exposure to Collibra for data cataloguing, lineage, classifications, and supporting data governance processes
At BNY, our culture allows us to run our company better and enables employees’ growth and success. As a leading global financial services company at the heart of the global financial system, we influence nearly 20% of the world’s investible assets. Every day, our teams harness cutting-edge AI and breakthrough technologies to collaborate with clients, driving transformative solutions that redefine industries and uplift communities worldwide.
Recognized as a top destination for innovators, BNY is where bold ideas meet advanced technology and exceptional talent. Together, we power the future of finance – and this is what #LifeAtBNY is all about. Join us and be part of something extraordinary.
