Role: Data Analyst

Engagement type: Contract

Working Hours: Flexible - Working with Mandatory PST overlap from 10 PM to 12 AM (IST)

Required

* Bachelor’s degree in Computer Science, Information Systems, Statistics, or a related field.

* 8+ years of experience in data analysis or data warehousing.

* Proficiency in SQL for data extraction and manipulation.

* Experience with data warehousing tools and technologies (e.g., Snowflake, MS Fabric, etc.).

* Knowledge of ETL tools (e.g. WhereScape, Informatica, Talend, or Alteryx).

* Strong analytical and problem-solving skills.

* Experience with BI tools (e.g., Tableau, Power BI, Looker).

* Familiarity with programming languages like Python, etc..

* Excellent communication and teamwork skills.Desired

* Familiarity with at least one public cloud provider (AWS, Azure, or GCP) and their respective data & analytics products and platforms

* Understanding of data governance, security, and compliance best practices.

Key Responsibilities:

1. Data Quality Assurance:

a. Develop and implement data quality processes to ensure accurate and consistent data.

b. Perform data profiling and validation to identify and resolve data anomalies and inconsistencies.

2. Data Warehouse Development:

a. Collaborate with stakeholders to understand data requirements for the finance domain.

b. Support the development and testing of Data Vault 2.0-based models.

3. ETL Process Validation:

a. Test and validate ETL processes built using automation tools such as WhereScape RED (or any ETL tool).

b. Ensure data integrity during data extraction, transformation, and loading operations.

4. Collaboration & Documentation:

a. Work closely with data modelers, ETL developers, and business analysts to align on data requirements.

b. Document data quality issues, test cases, and resolutions comprehensively.

5. Automation & Tool Utilization:

a. Explore opportunities for automating data quality checks and validations.

b. Continuous Improvement:

c. Analyze recurring data issues and recommend solutions for system improvements.

d. Stay updated with best practices in data quality engineering and apply them to the project.

e. Experienced in ETL Test Automation tools like QyerySurge, Big EVAL, Etc.