Senior Data Quality Analyst

Role: Senior Data Quality Analyst<br /><br />Location: Buffalo, NY or Wilmington, DE - Onsite<br /><br />The Senior Data Quality Analyst is a hands-on data quality engineer responsible for building<br /><br />automation-first controls, monitoring, and remediation at scale. The role designs, scripts, and<br /><br />operationalizes data quality validation pipelines, integrates with observability platforms, and<br /><br />leverages APIs to orchestrate end-to-end workflows across cloud and on-prem environments.<br /><br />The ideal candidate is fluent in Python and SQL, experienced with REST/GraphQL APIs, and<br /><br />comfortable integrating DQ checks into ETL/ELT, CI/CD, and event-driven architectures. This<br /><br />is a role with location options in Buffalo, NY or Wilmington, DE.<br /><br />POSITION RESPONSIBILITIES:<br />Engineer automated data quality pipelines that detect, diagnose, and remediate data defects; design for scalability, idempotency, and observability.<br />Use Python/SQL for data profiling, rule evaluation, schema validation, anomaly detection, and automated exception workflows.<br />Implement API-driven integrations (REST/GraphQL/SDKs) with DQ, catalog, ticketing, notification, and orchestration systems; handle OAuth2, pagination, rate limits, retries, and backoff.<br />Define and maintain DQ rule libraries and validation frameworks as reusable, versioned assets; enforce code quality via unit tests, linting, and static analysis.<br />Embed automated controls into ETL/ELT and data integration jobs; implement pre/post-load validations, row/column-level checks, and SLA/SLO monitoring.<br />Build event-driven alerts and webhook workflows to route exceptions to the right queues (e.g., Jira/ServiceNow), with metadata for reproducibility and audit.<br />Develop KPI dashboards and operations apps using Power BI and Power Apps to visualize coverage, drift, and rule performance, and to streamline triage/remediation.<br />Conduct root-cause analysis using lineage, logs, and metrics; implement automated remediation where feasible (e.g., rollback, quarantine, replay).<br />Contribute to CI/CD workflows (GitLab or equivalent) for DQ assets: automated tests, environment promotion, secrets management, and change controls.<br />Author and maintain runbooks, design docs, and operational playbooks; mentor analysts on scripting, APIs, and engineering best practices.<br />Uphold risk, regulatory, and internal control requirements; ensure auditability and traceability throughout DQ processes.<br />MINIMUM QUALIFICATIONS REQUIRED: Bachelor's degree and a minimum of 5 years related experience; or in lieu of a degree, a combined minimum of 9 years higher education and/or work experience, including a<br />minimum of 5 years related experience. Advanced proficiency in Python and SQL for automation, including building reusable<br />libraries, scheduled jobs, and validation pipelines.<br />API engineering experience: designing and consuming REST/GraphQL APIs,<br />handling auth (OAuth2/Bearer), pagination, rate limits, error handling/retries, and webhooks for event-driven processes.<br />Experience building solutions with Power BI and Power Apps for operational reporting and workflow automation.<br />Demonstrated success collaborating across engineering, governance, and business teams in fast-paced environments.<br />IDEAL QUALIFICATIONS PREFERRED Experience with automated ETL/ELT validation and data integration platforms;<br />familiarity with pre/post-load checks, data contracts, and schema enforcement.<br />Proficiency with DQ/observability platforms (e.g., Informatica Cloud DQ, Monte Carlo, Anomalo, Collibra OwlDQ) and their SDKs/APIs.<br />Hands-on data profiling, rule design, and automated measurement of DQ dimensions (completeness, validity, accuracy, timeliness, uniqueness, consistency).<br />Implemented governance-aligned DQ frameworks (standards, metadata contracts, lineage, policy as code).<br />Experience with workflow/automation tools (Power Apps, Alteryx, or equivalent) and messaging/queueing for event-driven triage.<br />Cloud experience (Azure, Snowflake): scripting with providers/SDKs, secrets management, job orchestration, and cost-aware design.<br />CI/CD in GitLab (or similar): pipeline design, automated testing, code scanning, environment promotion, and approvals.<br />Exposure to AI/ML-based anomaly detection or statistical monitoring; ability to integrate model outputs via APIs.<br />Excellent communication skills-able to explain engineering decisions and automation tradeoffs to non-technical stakeholders.<br />Proven ability to manage multiple concurrent automation initiatives and deliver high-quality solutions on schedule.