Data Intelligence Analyst Raritan NJ

[ramashish kumar]

Hi,

Please let me know if you would be interested in exploring this opportunity, and I will be happy to share more information.

 

Data Intelligence Analyst

Location :  Raritan NJ

Contract

 

Role Overview: The Data Quality Analyst will play a critical role in ensuring the accuracy, consistency, and reliability of enterprise data across multiple platforms. This position focuses on validating and reconciling data, monitoring quality through automated checks and dashboards, and investigating discrepancies to identify root causes. The analyst will work closely with engineering and business process teams to define data quality standards, document data flows, and assess the impact of issues on reporting and analytics. Leveraging tools such as Microsoft SQL Server, Azure Data Factory, Microsoft Fabric, and Power BI, the role emphasizes continuous improvement, automation, and governance to maintain high data integrity and support informed decision-making.

 

Key Responsibilities:

• Data Validation & Reconciliation; Regularly compare source data with transformed datasets to ensure accuracy and completeness.
• Data Quality Monitoring; Implement checks and dashboards to track anomalies, missing values, and inconsistencies across systems.
• Root Cause Analysis: Investigate discrepancies in reporting or system outputs and identify underlying data issues.
• Testing Data Pipelines; Validate ETL processes and confirm that transformations preserve data integrity.
• Define Data Quality Standards; Establish clear rules for acceptable data formats, completeness, and accuracy.
• Collaborate with Engineering & Process Teams; Work closely with system engineers and business process owners to resolve data issues.
• Document Data Flows & Dependencies Maintain clear documentation of how data moves between systems and where checks are applied.
• Perform Impact Analysis; Assess how data issues affect downstream reporting, analytics, and operational processes.
• Develop Automated Validation Scripts; Create SQL queries or scripts to automate data checks and reconciliation tasks.
• Continuous Improvement; Recommend enhancements to data governance, tools, and processes to prevent recurring issues.

Desired Qualifications:

• 5+ years of experience in BI, Data Analysis, or related roles, including experience with data integration, transformation, and visualization
• Strong SQL (T‑SQL) skills for data validation, reconciliation, and automation in SQL Server.
• Hands‑on experience with Azure Data Factory for building and testing ETL pipelines.
• Familiarity with Microsoft Fabric (Data Pipelines, Lakehouse, Dataflows Gen2) and its impact on data quality.
• Proficiency in Power BI for creating dashboards to monitor anomalies and data quality metrics.
• Ability to define and enforce data quality standards (formats, completeness, accuracy).
• Skilled in root‑cause analysis and impact assessment for data issues across systems.
• Experience with automated validation scripts (SQL; Python or PowerShell preferred).
• Strong documentation skills for data flows, dependencies, and quality checks.
• Knowledge of data governance principles and continuous improvement practices.
• Excellent collaboration and communication skills to work with engineering and business teams.
• Strong problem-solving skills and ability to troubleshoot technical issues related to GenAI, Copilot, and Microsoft Fabric.
• Bachelor’s degree in Computer Science, Data Engineering, or related field.

 

 

Thanks and Regards

Ramashish Kumar

Email : rama...@valzosoft.com