Data Quality Analyst || Raritan, NJ (Onsite) || Contract

[Valzo Soft]

Position: Data Quality Analyst

Location: Raritan, NJ (Onsite)

Type: Contract

 

Role Description:

The Data Quality Analyst plays a critical role in ensuring the accuracy, consistency, and reliability of enterprise data across multiple platforms. This role focuses on validating and reconciling data, monitoring quality through automated checks and dashboards, and investigating discrepancies to identify root causes.

The analyst will collaborate closely with engineering teams and business process owners to define data quality standards, document data flows, and assess the impact of data issues on reporting and analytics. Leveraging tools such as Microsoft SQL Server, Azure Data Factory, Microsoft Fabric, and Power BI, the role emphasizes automation, governance, and continuous improvement to support high data integrity and informed decision-making.

---

Key Responsibilities

• Data Validation & Reconciliation:
  Compare source data with transformed datasets to ensure accuracy, completeness, and consistency.
• Data Quality Monitoring:
  Implement automated checks and dashboards to identify anomalies, missing values, and inconsistencies.
• Root Cause Analysis:
  Investigate discrepancies in reports or system outputs and identify underlying data quality issues.
• Data Pipeline Testing:
  Validate ETL pipelines and ensure data transformations preserve integrity.
• Define Data Quality Standards:
  Establish and enforce rules for acceptable data formats, completeness, accuracy, and timeliness.
• Cross-Functional Collaboration:
  Work closely with engineering teams and business stakeholders to resolve data quality issues.
• Documentation:
  Maintain detailed documentation of data flows, dependencies, and applied quality controls.
• Impact Analysis:
  Assess the downstream impact of data quality issues on reporting, analytics, and operational processes.
• Automation:
  Develop automated validation and reconciliation scripts using SQL and scripting tools.
• Continuous Improvement:
  Recommend and implement improvements to data governance, tools, and processes to prevent recurring issues.

---

Required Skills & Qualifications

• 5+ years of experience in Business Intelligence, Data Analysis, or Data Quality roles
• Strong SQL (T-SQL) skills for data validation, reconciliation, and automation in Microsoft SQL Server
• Hands-on experience with Azure Data Factory for building and testing ETL pipelines
• Familiarity with Microsoft Fabric, including:
• Data Pipelines
• Lakehouse
• Dataflows Gen2
• Proficiency in Power BI for building dashboards and monitoring data quality metrics
• Proven ability to define and enforce data quality standards (format, completeness, accuracy)
• Strong expertise in root cause analysis and impact assessment
• Experience with automated validation scripts (SQL required; Python or PowerShell preferred)
• Excellent documentation skills for data flows, dependencies, and quality checks
• Knowledge of data governance principles and continuous improvement practices
• Strong collaboration and communication skills
• Proven problem-solving abilities, including troubleshooting issues related to GenAI, Copilot, and Microsoft Fabric