Data Consumer Analyst

Apexon; Hyderabad, Bengaluru; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Apexon is seeking a Data Consumer Analyst to support a migration from an on-premises data warehouse to an AWS S3-based cloud data platform. In this role, you will identify data consumers, document dependencies, and analyze lineage to ensure a seamless migration with minimal business disruption.

You will work with business stakeholders, BI teams, data engineers, architects, and application owners to validate requirements, map data flows, and develop automation to accelerate discovery and

Qualifications

• : 5+ years in Data Warehousing/Analytics/ Governance or Migration projects.
• : Strong understanding of Data Warehouses, Data Lakes, ETL/ELT and enterprise data architecture.
• : Advanced SQL skills with complex datasets and dependencies.
• : Experience with Relational and NoSQL databases.
• : Python for automation, scripting and data analysis.
• : AWS exposure with S3.
• : Experience in impact analysis, dependency mapping and lineage documentation.
• : Strong communication and stakeholder management across tech and business teams.
• : Proven experience supporting large-scale data migration or modernization initiatives.

Responsibilities

• Identify and inventory all data consumers across reports, dashboards, apps, and teams.
• Perform end-to-end data lineage analysis from source to consumption layers.
• Analyze database objects, ETL processes, and downstream dependencies for migration impact.
• Review query logs and usage patterns to distinguish active vs obsolete assets.
• Collaborate with stakeholders to validate dependencies and requirements.
• Create and maintain dependency maps, catalogs, migration inventories, and risk assessments.
• Support migration planning by identifying critical processes and risks before cutover.
• Develop automation scripts to accelerate data discovery and lineage tracking.
• Assist engineering teams in prioritizing migration waves by business criticality.
• Ensure accurate documentation and knowledge transfer throughout migration.

Skills

Data lineage

Data mapping

Impact analysis

Dependency analysis

Data migration

Data warehouse

Data lake

AWS S3

SQL

Python

Data governance

Metadata management

Data catalog

ETL / ELT

Business intelligence

Power BI

Tableau

RDBMS

NoSQL

Stakeholder management

Cloud migration

Data discovery

Automation

Tools

Collibra

Alation

Informatica EDC

Apache Atlas

AWS Glue Data Catalog

Power BI

Tableau

Job description

Job Description: Data Consumer Analyst (Data Lineage & Migration)

Role Overview

We are seeking a highly analytical and detail-oriented Data Consumer Analyst to support a strategic migration from an on-premises data warehouse to a modern AWS S3-based cloud data platform. In this role, you will be responsible for discovering, documenting, and analyzing all data consumers, dependencies, reports, applications, and business processes that rely on the existing data ecosystem.

You will work closely with business stakeholders, BI teams, data engineers, architects, and application owners to ensure a seamless migration with minimal business disruption.

Key Responsibilities

• Identify and inventory all consumers of enterprise data, including reports, dashboards, applications, interfaces, data feeds, and business teams.
• Perform end-to-end data lineage analysis and document data flow from source systems through transformations to consumption layers.
• Analyze database objects, ETL processes, reporting assets, and downstream dependencies to understand migration impacts.
• Review query logs, access patterns, and usage metrics to distinguish active data assets from obsolete or redundant ones.
• Collaborate with business and technical stakeholders to validate data dependencies and usage requirements.
• Create and maintain detailed dependency maps, consumer catalogs, migration inventories, and risk assessments.
• Support migration planning by identifying critical business processes and potential risks prior to cutover.
• Develop automation scripts and tools to accelerate data discovery, lineage tracking, and dependency analysis.
• Assist engineering teams in prioritizing migration waves based on business criticality and complexity.
• Ensure accurate documentation and knowledge transfer throughout the migration lifecycle.

Required Qualifications

• 5+ years of experience in Data Warehousing, Data Analytics, Data Governance, or Data Migration projects.
• Strong understanding of Data Warehouses, Data Lakes, ETL/ELT processes, and enterprise data architecture.
• Advanced SQL skills with experience analyzing complex datasets, queries, and database dependencies.
• Experience working with both Relational Databases (Oracle, SQL Server, PostgreSQL, MySQL, etc.) and NoSQL databases.
• Hands-on programming experience in Python for automation, scripting, and data analysis.
• Experience with cloud platforms, preferably AWS, with exposure to Amazon S3.
• Experience performing impact analysis, dependency mapping, and data lineage documentation.
• Strong communication and stakeholder management skills with the ability to interact across technical and business teams.
• Proven experience supporting large-scale data migration or modernization initiatives.

Preferred Qualifications

• Experience with Data Governance and Metadata Management tools such as Collibra, Alation, Informatica EDC, Apache Atlas, or AWS Glue Data Catalog.
• Hands-on experience with BI and reporting tools such as Power BI or Tableau.
• Knowledge of AWS data services and cloud-native analytics platforms.
• Experience building automation solutions, AI agents, or intelligent workflow tools.
• AWS Certifications such as:
• AWS Certified Data Engineer
• AWS Certified Solutions Architect
• AWS Certified Data Analytics

Key Skills

• Data Lineage
• Data Mapping
• Impact Analysis
• Dependency Analysis
• Data Migration
• Data Warehouse
• Data Lake
• AWS S3
• SQL
• Python
• Data Governance
• Metadata Management
• Data Catalog
• ETL / ELT
• Business Intelligence
• Power BI
• Tableau
• RDBMS
• NoSQL
• Stakeholder Management
• Cloud Migration
• Data Discovery
• Automation