Senior Data Analyst Job at Techcliff Group in Quincy

Key Responsibilities

• Perform data validation, profiling, and quality assessments across cloud-based platforms, including Big Query, Snowflake, and other databases.
• Collaborate with data stewards and business teams to gather requirements, identify data inconsistencies, and ensure compliance with data governance standards.
• Design and execute comprehensive test plans, test cases, and data validation procedures for ETL processes and migration projects.
• Work with APIs, Postman, and other tools to validate data mapping, transformations, and error handling.
• Support data migration projects by writing and optimizing complex SQL queries to validate source-to-target data mappings.
• Participate in Agile development cycles, providing feedback on data issues, test strategies, and validation methodologies.
• Assist in performance tuning of queries and systems to enhance data processing pipelines.
• Collaborate with stakeholders, including developers, business analysts, and product owners, ensuring alignment with project goals.
• Document findings, maintain detailed test reports, and assist in defect tracking and resolution.

Qualifications & Experience Required

• 10+ years of experience in data validation, ETL testing, and data pipeline management.
• Strong expertise in SQL, data transformation, and data profiling using Snowflake, Big Query, Teradata, Oracle, and similar databases.
• Hands-on experience with cloud environments (GCP, AWS) and orchestration tools like Airflow.
• Experience in healthcare data projects and understanding of sensitive data handling.
• Familiarity with API testing tools like Postman, SOAP UI, and automation scripting using Python or UNIX.
• Knowledge of data governance, quality assurance practices, and best practices for data integration.
• Strong collaboration skills and experience working with geographically dispersed teams.
• Agile methodology experience, including creating test plans, scenarios, and reporting.

Preferred Skills

• Experience with healthcare platforms such as CVS Health or other medical data ecosystems.
• Familiarity with data privacy standards like HIPAA.
• Experience working with large datasets, business intelligence tools, or advanced analytics frameworks.
• Certification in Agile practices or cloud technologies.