VP, Data Quality Specialist

Location:  Los Angeles, CA (Hybrid Schedule)

Job Code:  LQ486

The Data Quality Specialist 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 Specialist will work with reporting teams, data domain stewards and Technology to identify and document data quality rules, requirements, and lineage of critical data elements (CDEs). The Specialist will be responsible for the design and execution of necessary data tests in diverse development platforms and computing environments including MS SQL, Oracle, Excel VBA, and third-party applications.

ESSENTIAL FUNCTIONS

Other responsibilities of the Data Quality Specialist include:

• Participate in and lead discussions with cross-functional teams to identify and document data quality rules for critical reports and Enterprise CDEs.
• 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:

• 5 – 7 years of Data Governance/ Data Management experience; experience with financial services is preferred.
• Minimum 5 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.
• 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.
• Experience building data quality rules and documenting business requirements.
• Ability to work independently with minimal supervision in various areas of responsibility.
• Excellent written and verbal communication.
• Strong interpersonal skills.

Estimated salary range: (DOE) $130K to $160K+ (possibly to $170K base) plus annual bonus & possible signing bonus, medical, dental, vision, life, vacation, 401K

Email your resume in MS/Word to Guyot@Bankers-Search.com 

Or contact Keith Guyot at (310) 823-1400