Chief Data Office-Data Quality and Analytics Associate

Sumitomo Mitsui Trust Bank Limited New York Branch; New York (NY); On-site; USD 42,000 - 90,000; Full time

Job summary

Bank of China in New York seeks a Data Quality and Analytics Associate to own end-to-end data quality measurement and reporting across enterprise data domains. You’ll collaborate with data stewards, governance, and IT to remediate issues and support analytics needs.

You will develop validation rules in SQL/Python, build dashboards, and participate in data governance and data lineage activities to ensure data accuracy and timeliness. A BA/BS is required with 1+ year in data analysis.

Qualifications

• Bachelor’s degree in a related field required; MBA/MS preferred.
• Minimum 1 year of data analysis, SQL and BI tool experience.
• Solid knowledge of SQL, data analysis and data visualization.
• Ability to collaborate with governance and technology teams.

Responsibilities

• Develop and maintain data quality validation rules and monitoring logic using SQL and Python.
• Profile data, identify anomalies, and report data quality issues and KRIs.
• Lead data quality dashboards and scorecards for visibility into data health.
• Perform RCA and coordinate remediation with DGWG and stakeholders.
• Support analytics needs and ad hoc data inquiries for business units.

Skills

SQL

Data analysis

Data visualization

Education

BA/BS degree

MBA/MS degree preferred

Tools

PowerBI

Tableau

Qlik Sense

Job description

Established in 1912, Bank of China is one of the largest banks in the world, with over $3 trillion in assets and a footprint that spans more than 60 countries and regions. Our long-term outlook, institutional weight and global breadth provide our clients with a stable and reliable financial partner, whether in Corporate or Personal Banking or our Trade Services, Commodities, Financial Institutions and Global Markets lines of business.

The Data Quality (DQ) and Analytics Associate is responsible for end-to-end data quality measurement, monitoring, and metrcs reporting on the critical data elements (CDEs) certified across all enterprise data domains, following the bank’s data management framework. The individual collaborates with business data stewards, and technology and governance teams to perform DQ issue root cause analysis, identify solutions and manage the issue remediation. This role also carries on DQ testing and assurance for IT system development / enhancement projects, and supports business departments on their data analytics needs and Ad Hoc data inquiries.

Data Quality Monitoring, Reporting and Support (45%)

• Develop and maintain Data Quality validation rules and monitoring logic using SQL and Python to assess the timeliness, completeness, accuracy, and consistency of Critical Data Elements (CDEs).
• Perform data profiling and trend analysis across internal systems / databases to identify anomalies, inconsistencies, and potential data quality issues.
• Execute and enhance the automated DQ BAU process.
• Design and enhance the data quality dashboards and scorecards, using BI tools, to provide visibility into data health metrics and data quality key risk indicators (KRIs).
• Perform data validation, and data quality test and assurance for IT system development / enhancement projects.

Data Quality Issue Management and Remediation (25%)

• Conduct the root cause analysis (RCA) on identified DQ issues and identify remediation solutions.
• Coordinate and plan remediation activities with Data Governance Team, technology team, and business data stewards and stakeholders to resolve data defects timely.
• Report the enterprise Data Quality status and KRIs to the Data Governance Working Group (DGWG) and the Data Governance Committee (DGC).

Support Business Departments on Data Analytics (10%)

• Help formulate their business data analytics requirements and design solutions accordingly.
• Build and maintain business data analytics dashboards, including development of automated ETL/ELT pipelines and analytical data layer, to improve their operational and reporting efficiency and increase their data-driven decision-making ability.
• Support business departments on their Ad Hoc data inquiries.

Data Governance Support Activities (20%)

• Assist Data Governance with Data Dictionary maintenance and enforcing the data ownership and accountability in the bank.
• Document metadata, data definitions, and data lineage to support transparency between source systems and reporting layers.
• BA/BS degree required, MBA/MS degree preferred
• A minimum of 1 year of experience in data analysis, SQL and BI tools (e.g., PowerBI, Tableau, or Qlik Sense)
• Solid knowledge and experience in SQL, data analysis, and data visualization

USD $42,000.00 - USD $90,000.00 /Yr.