Data Analyst

Techwave; Rangareddy; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Techwave in Hyderabad, India, is seeking a Data Analyst with 5+ years of experience to design and deliver robust data platforms supporting analytics and AI products.

The role focuses on translating business requirements, data lineage, and modeling within a Medallion architecture, working with Snowflake, REST APIs, and BI tools. Collaboration with stakeholders and mentoring juniors are key aspects.

Qualifications

• Bachelor of Science in computer science or information systems (or equivalent work experience).
• 5+ years of Data Analyst or Business Data Analyst experience in enterprise data environments.
• Experience with ETL/ELT tools (Informatica, DBT).
• Experience with BI/reporting tools (Power BI, Tableau, Excel).
• Experience with data modeling methodologies (Dimensional modeling, Data Marts, Data Warehousing, Star/Snowflake schema).
• Familiarity with cloud data platforms (Azure, AWS, GCP).
• Exposure to API testing tools (Postman, Swagger).
• Agile/Scrum delivery exposure.

Responsibilities

• Work closely with business stakeholders to gather,validate, and clarify data and reporting requirements.
• Translate business needs into detailed functional and technical requirement documents.
• Develop comprehensive Source-to-Target Mapping (STTM/STM) documents capturing field-level data logic.
• Create detailed Business Rules, Data Definitions, and Data Transformation documentation.
• Perform complete data lineage analysis across Snowflake, APIs, upstream sources, and reporting layers.
• Assistin data modeling and design aligned with Medallion architecture (Bronze/Silver/Gold layer separation).
• Conduct data profiling, validation, and reconciliation using Snowflake SQL.
• Work with REST API data integrations, including reading API specifications, understanding payloads, and mapping to Snowflake tables.
• Collaborate with data engineers, ETL/ELT developers, and QA to ensureaccurateinterpretation of the requirements.
• Support UAT and resolve data-related gaps through iterative testing and validation.
• Mentor and guide more junior team members.

Skills

SQL

Python

Snowflake

ETL/ELT

Data Modeling

API Ingestion

Data Validation

Communication

Education

BS in Computer Science or Information Systems

Tools

Power BI

Tableau

Excel

Informatica

DBT

Postman

Job description

Techwave , we are always in an exercise to foster a culture of growth, and inclusivity. We ensure whoever is associated with the brand is being challenged at every step and is provided with all the necessary opportunities to excel in life. People are at the core of everything we do.

Who are we?

Techwave is a leading global IT and engineering services and solutions company revolutionizing digital transformations. We believe in enabling clients to maximize the potential and achieve a greater market with a wide array of technology services, including, but not limited to, Enterprise Resource Planning, Application Development, Analytics, Digital, and the Internet of things (IoT).

Founded in 2004, headquartered in Houston, TX, USA, Techwave leverages its expertise in Digital Transformation, Enterprise Applications, and Engineering Services to enable businesses accelerate their growth.

Plus, we’re a team of dreamers and doers who are pushing the boundaries of what’s possible.

And we want YOU to be a part of it.

Job Description

Role: Data Analyst
Experience: 5+Years of experience
Location: Hyderabad

Summary

Data & Analytics function is dedicated to designing and delivering robust global data platforms that enable business solutions and high-quality analytics. The Data Analystis responsible forinterpreting and analyzing data from complex sources like ERP, HCM, and CRM to support data-driven decision making and ensure the accuracy, integrity, and usability of information within the organization’s Data Lakehouse. This hands-on role focuses onrequirementstranslation, source-to-target mapping, dimensional modeling support, ELT/ETL validation, testingsupportand data quality. Working closely with Business teams, Data Architects, and Engineers, the Data Analyst transforms business processes into well-structured, secure, and reliable data models and pipelines, enabling the Data Lakehouse to serve as a trusted foundation for analytics,reportingand AI products.

Responsibilities

• Work closely with business stakeholders to gather,validate, and clarify data and reporting requirements.

• Translate business needs into detailed functional and technical requirement documents.

• Develop comprehensive Source-to-Target Mapping (STTM/STM) documents capturing field-level data logic.

• Create detailed Business Rules, Data Definitions, and Data Transformation documentation.

• Perform complete data lineage analysis across Snowflake, APIs, upstream sources, and reporting layers.

• Assistin data modeling and design aligned with Medallion architecture (Bronze/Silver/Gold layer separation).

• Conduct data profiling, validation, and reconciliation using Snowflake SQL.

• Work with REST API data integrations, including reading API specifications, understanding payloads, and mapping to Snowflake tables.

• Collaborate with data engineers, ETL/ELT developers, and QA to ensureaccurateinterpretation of the requirements.

• Support UAT and resolve data-related gaps through iterative testing and validation.

• Mentor and guide more junior team members.

Skills

• Proven experience with programming languages such as SQL and Python for data validation, profiling, reconciliation, and analytics.

• Strong hands-on Snowflake experience isrequired, including:

• Ability to construct & optimize complex SQL queries

• Variant/JSON parsing

• Schema and stage understanding

• Performance analysis & troubleshooting

• Working experience in Medallion Architecture (Bronze, Silver, Gold data layers) including mapping data flows across layers.

• Proven experience with API-based data ingestion (REST APIs, JSON/XML).

• Ability to interpret API documentation and create field mappings for Snowflake ingestion.

• Experience building Source-to-Target mapping documents and transformation rules.

• Strong understanding of data lineage, metadata traceability, and impact analysis.

• Experience writing BRDs, FRDs, mapping documents, and business rule specifications.

• Effective communication skills withabilityto work directly with business stakeholders.

• Excellent analytical and problem-solving skills.

Education / Professional Experience/ Qualifications

• Bachelor of Science (BS) in computer science or information systems (or equivalent work experience).

• 5+ years of Data Analyst or Business Data Analyst experience in enterprise data environments.

• Preferred:Experience in professional services, accounting industry, or client service/consultative technology roles.

• Experience with ETL/ELT tools (Informatica, DBT).

• Experience with BI/reporting tools (Power BI, Tableau, Excel).

• Experience with data modeling methodologies (Dimensional modeling, Data Marts, Data Warehousing, Star/Snowflake schema).

• Familiarity with cloud data platforms (Azure, AWS, GCP).

• Exposure to API testing tools (Postman, Swagger).

• Agile/Scrum delivery exposure.