Data Consumer Analyst - Cloud Data

Ample Success HR; Bengaluru; On-site; INR 800,000 - 1,400,000; Full time

Job summary

Ample Success HR seeks a Data Consumer Analyst to guide the cloud migration from on-premise warehousing to an AWS S3-based environment. You will map all data consumers and BI pipelines, document data lineage, and coordinate with business teams to ensure zero disruption.

You will analyze usage patterns, validate dependencies, and support migration planning with clear artifacts, automation, and risk assessments across multiple teams.

Qualifications

• Experience mapping data consumers, reports, and BI pipelines.
• Strong SQL skills and ability to analyze data usage patterns.
• Hands-on Python for automation and data tooling.
• Cloud experience focusing on AWS S3 and data migrations.
• Excellent communication with technical and business stakeholders.

Responsibilities

• Discover and inventory all on-premise data consumers, reports, BI pipelines, and teams.
• Map end-to-end data lineage from source to consumption points.
• Validate usage patterns to identify active vs obsolete dependencies.
• Analyze query logs to measure usage frequency and performance needs.
• Coordinate with technical and business teams to confirm requirements and prioritise migration waves.
• Document findings as dependency maps, consumer catalogs, and risk registers.

Skills

Data consumer mapping

SQL proficiency

Python

AWS S3

Communication

Tools

Power BI

Tableau

Job description

Data Consumer Analyst - Cloud Data Warehouse Migration (AWS)

Role Summary:

We are embarking on a strategic migration of our data infrastructure from an on-premise data warehouse to a modern, Amazon S3-based cloud data warehouse. As our Data Consumer Analyst, you will be the person who maps the full landscape of who use our data and how. You will discover, document, and analyze every report, downstream application, BI pipeline, and business team that depends on the existing warehouse - ensuring a seamless, zero disruption migration. This is a high-visibility role that bridges deep technical analysis with cross functional coordination, directly safeguarding business continuity throughout the transition.

Key Responsibilities:

• Discover and inventory all on-premise data consumers, including reports, downstream applications, BI pipelines, and business teams.
• Map end-to-end data lineage from source systems through transformations to consumption points.
• Validate actual data usage patterns to distinguish active dependencies from obsolete ones, informing migration and decommissioning decisions.
• Analyze query and access logs to quantify usage frequency, criticality, and performance requirements.
• Coordinate across technical and business teams to confirm requirements, resolve ambiguities, and prioritize migration waves.
• Document findings in clear, actionable artifacts (dependency maps, consumer catalogs, risk registers) for engineering and stakeholder teams.
• Automate discovery and analysis workflows to accelerate the mapping process and improve accuracy.
• Support migration planning by flagging risks, gaps, and impact areas before cutover.

Required Qualifications:

• Proven experience with data lakes, data warehouses, and complex data migration projects.
• Strong understanding of both RDBMS and NoSQL databases, with advanced SQL querying skills.
• Hands-on proficiency in at least one object-oriented programming language (Python preferred).
• Practical cloud platform experience, with an emphasis on Amazon S3.
• Demonstrated hands-on automation experience (scripting, pipelines, or tooling).
• Exceptional communication, problem-solving attitude, and analytical aptitude to interface effectively with diverse technical and business stakeholders.

Preferred Qualifications (Pluses)

• Experience building or leveraging AI agents for workflow automation.
• Active AWS certifications (e.g., AWS Certified Data Engineer, AWS Certified Solutions Architect).
• Hands-on experience with Business Intelligence tools (e.g., Power BI, Tableau)