Description

Required Technical Skills

Data Analysis & Modelling

- Data profiling and data quality analysis
- Source-to-target mapping
- Data lineage and impact analysis
- Functional and business requirement gathering
- SQL querying and data validation
- Understanding of data warehousing concepts and dimensional modeling

Programming & Cloud

- Python (Pandas, NumPy)
- SQL
- Google Cloud Platform (BigQuery, Cloud Storage)
- Understanding of ETL/ELT concepts

Legacy Platform Understanding

- SAS datasets and SAS reporting concepts
- SAS data structures and business rules analysis
- Experience supporting SAS migration initiatives is highly desirable

Documentation Tools

- Excel
- Visio
- JIRA
- Confluence
- PowerPoint

Responsibilities

Key Responsibilities

Business & Data Analysis

- Analyze existing SAS datasets, reports, and data pipelines.
- Gather and document business, functional, and data requirements from stakeholders.
- Conduct source-to-target mapping and data lineage analysis.
- Identify business rules embedded within SAS programs and workflows.
- Create detailed Functional Requirement Documents (FRD), Business Requirement Documents (BRD), and mapping specifications.
- Support data profiling and data quality assessments.

Migration Support





- Assist in discovery and assessment of SAS assets targeted for migration.
- Collaborate with Data Engineers to understand SAS transformation logic and convert business requirements into Python and GCP-based solutions.
- Validate transformed datasets in GCP against legacy SAS outputs.
- Participate in reconciliation activities and defect analysis.
- Support UAT planning and stakeholder sign-off processes.

Data Quality & Governance

- Define data quality rules and validation criteria.
- Conduct data reconciliation between source and target platforms.
- Analyze data anomalies, discrepancies, and migration issues.
- Support metadata documentation and data governance initiatives.
- Ensure compliance with security, privacy, and regulatory requirements.

Reporting & Stakeholder Management

- Prepare project status reports, data analysis summaries, and migration readiness reports.
- Facilitate workshops with business users, SMEs, and technical teams.
- Present findings, recommendations, and migration impacts to stakeholders.

Support change management and user adoption activities.

Qualifications

Graduate in Computer Science, Data Science, or related field. 4-6 years of experience in data engineering or related field.

📌 Manager (Pune)
🏢 EXL
📍 Pune