Data Consumer Analyst /Data Engineer
About Us:
ITC Infotech is a leading global technology services and solutions provider, led by Business and Technology Consulting. ITC Infotech provides business-friendly solutions to help clients succeed and be future-ready, by seamlessly bringing together digital expertise, strong industry specific alliances and the unique ability to leverage deep domain expertise from ITC Group businesses. We provide technology solutions and services to enterprises across industries such as Banking & Financial Services, Healthcare, Manufacturing, Consumer Goods, Travel and Hospitality, through a combination of traditional and newer business models, as a long-term sustainable partner.
Role Overview:
We are undertaking a strategic migration of our on-premise data warehouse to a modern, cloud-based data platform leveraging Amazon S3. We are seeking an experienced Data Consumer Analyst to identify, analyze, and document all data consumers and their dependencies on the existing warehouse. The role involves mapping reports, downstream applications, BI pipelines, and business processes that rely on the current data infrastructure. The successful candidate will work closely with engineering, data, and business teams to ensure a seamless migration with minimal business disruption. This is a high-visibility role requiring strong SQL, data analysis, cloud technology, and automation skills, combined with excellent stakeholder management and problem-solving abilities.
Key Responsibilities:
Identify and maintain a comprehensive inventory of data consumers, including reports, downstream applications, BI pipelines, and business teams.
Map end-to-end data lineage from source systems through data transformations to downstream consumption points.
Analyze actual data usage patterns to identify active dependencies, redundant consumers, and obsolete data assets.
Review query logs, access logs, and usage metrics to assess consumption frequency, business criticality, and performance requirements.
Collaborate with technical and business stakeholders to validate dependencies, clarify requirements, and prioritize migration activities.
Develop and maintain detailed documentation, including data consumer catalogs, dependency maps, lineage diagrams, and risk registers.
Automate data discovery, analysis, and inventory processes using Python, SQL, scripting, or other suitable tools.
Identify migration risks, dependency gaps, and potential business impacts to support migration planning and cutover readiness.
Support migration and decommissioning decisions by providing accurate dependency analysis and actionable recommendations.
Ensure critical reports, applications, and business processes continue to function effectively throughout the migration.
Required Qualifications:
8+ years of hands on experience in data analysis, data engineering, data warehousing, or complex data migration projects.
Strong understanding of data warehouses, data lakes, database architectures, and data integration concepts.
Advanced SQL skills, including complex queries, joins, data profiling, and query analysis.
Hands-on experience with relational databases (RDBMS) and NoSQL databases.
Proficiency in Python or another object-oriented programming language for data analysis and automation.
Practical experience with cloud platforms, particularly Amazon Web Services (AWS) and Amazon S3.Demonstrated experience automating workflows through scripts, pipelines, or custom tools.
Strong analytical, troubleshooting, and problem-solving skills.
Excellent communication skills and the ability to collaborate with technical teams, business users, and senior stakeholders.
Ability to translate complex technical findings into clear documentation and actionable business insights.
Preferred Qualifications:
Exposure to AI agents, generative AI, or intelligent automation for workflow optimization.
AWS certifications such as AWS Certified Data Engineer or AWS Certified Solutions Architect.
Hands-on experience with BI and reporting tools such as Power BI or Tableau.
ITC Infotech is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law. ITC infotech is committed to providing veteran employment opportunities to our service men and women.