Position: Data Intelligence Analyst with Azure
Location: Raritan - NJ***From Day 1 Onsite***
Duration: 1 Years
| | 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.
Bachelors degree in Computer Science Data Engineering or related field. |
Position: Data Intelligence Analyst with Azure Location: Raritan - NJ***From Day 1 Onsite*** Duration: 1 Years 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 fo...
Position: Data Intelligence Analyst with Azure
Location: Raritan - NJ***From Day 1 Onsite***
Duration: 1 Years
| | 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.
Bachelors degree in Computer Science Data Engineering or related field. |
View more
View less
Job Location:
Monthly Salary:
Not Disclosed
Posted on:
3 hours ago
Vacancies:
1 Vacancy
