AVP, Data Quality Analyst

GENERAL SUMMARY

The Data Quality Analyst will be responsible for testing data accuracy and performing data analysis and record-keeping in order to improve the quality of data on critical reports, data sets and databases. The Analyst will work with reporting teams, data domain stewards and Technology to document the lineage of critical data elements (CDEs) and implement data quality rules on CDEs with the use of the Enterprise Data Governance Tool.

ESSENTIAL FUNCTIONS

Other responsibilities of the Data Quality Analyst include:

• Deconstruct complex Excel workbooks and SQL scripts to identify data lineage, transformations, and dependencies.
• Profile data manually and set up profiling tasks in the Enterprise Data Governance Tool.
• Write SQL queries to test data based on various dimensions (i.e., Completeness, Accuracy, Conformity, Validity, Uniqueness, etc.).
• Draft SQL rules on behalf of data domain stewards and CDE owners; create test cases.
• Validate data quality rules around Enterprise CDEs to ensure they meet Data Governance requirements.
• Review transformation specifications especially around risk data aggregation and reporting, to propose additional DQ rules as necessary.
• Identify Data Quality issues and escalate issues to the respective remediation team(s).

QUALIFICATIONS

Education:    

• Bachelor’s degree or equivalent work experience.
• Master’s degree or Data Governance certification (CDMP, CIMP, DGSP, etc.) a plus.

Experience:  

• 3 - 5 years of Data Governance/ Data Management experience; experience with financial services is preferred.
• Minimum 3 years of experience with data analysis and reporting.
• Minimum 3 years of experience with data quality testing and writing SQL statements.
• Experience in any data quality and reporting tools/applications is highly desired (e.g.: Informatica, Collibra, IBM Analytics)
• Experience and confidence in working with stakeholders across a wide variety of roles, including senior management.
• Experience working and effectively collaborating with reporting, operations, and technology teams.
• Experience building data quality rules and documenting business requirements.
• BCBS 239 experience is a plus.

Skills/Ability: 

• Knowledge of information access and delivery methods, analytics applications and tool portfolio, data sourcing and integration methods.
• Ability to write SQL queries independently.
• Understanding of data warehouse, ETL, data cleansing and architecture.
• Knowledge of advanced formulas & pivot tables in Excel.
• Thorough understanding of data quality testing principles.
• Ability to work independently with minimal supervision in various areas of responsibility.
• Excellent written and verbal communication.
• Strong interpersonal skills.

OTHER DETAILS

$120K – $135K / year 
Pay determined based on job-related knowledge, skills, experience, and location.