Tasks/Scope of Work:
Main technologies/Tools: SQL, ETL Process, Tableau, Dashboard, Visualization
1. Data Governance and Compliance:
-Ensure data security, privacy, and compliance with relevant regulations (e.g., GDPR, HIPAA).
-Implement data governance practices to maintain data quality and integrity
2.Data Profiling and Assessment:
-Analyze data sources to understand data structure, content, and quality issues.
-Identify data anomalies, inconsistencies, and errors.
3.Data Validation and Testing:
-Develop and execute data validation tests to verify data accuracy.
-Create test cases and scripts to validate data transformations and processes.
4. Data Cleaning and Transformation:
-Implement data cleaning and transformation processes to rectify data quality issues.
– Standardize and normalize data to maintain consistency.
5.Data Quality Metrics:
-Define and monitor key data quality metrics and KPIs.
-Create reports and dashboards to track data quality over time.
6.Data Governance:
-Establish and enforce data governance policies and procedures.
-Ensure compliance with data quality standards and regulations.