Analytics Consultant 4 - Data Quality

Data Profiling & Analysis: Perform data profiling using SQL to understand data structures, identify patterns, detect anomalies, and assess data quality. Data Validation & Issue Identification: Identify data discrepancies, investigate data quality issues, and support root cause analysis and remediation.

Key Responsibilities and Required Skills

• Hands-on SQL: Write and execute SQL queries to extract, analyze, and validate data from the Teradata environment.
• Data Quality Rule Definition: Define, develop, and implement data quality rules to assess data accuracy, completeness, consistency, and integrity.
• Data Profiling & Analysis: Perform data profiling using SQL to understand data structures, identify patterns, detect anomalies, and assess data quality.
• Data Validation & Issue Identification: Identify data discrepancies, investigate data quality issues, and support root cause analysis and remediation.
• Data Requirements & Documentation: Document data quality rules, profiling results, validation logic, and findings to support consistent data management practices.
• Strong, hands-on SQL experience is essential.
• Must be able to write and execute SQL queries, perform joins, retrieve data, and identify data anomalies.
• Experience with data profiling, defining data quality rules, and creating data quality dashboards is required.
• Candidates must be technically proficient rather than primarily focused on management, coordination, or oversight.
• Experience with Teradata or other relevant data platforms is beneficial.
• Financial crimes or AML experience is not required; the team can provide the necessary business context and documentation.

EEO:

Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.