Technical Business Analyst (Data warehousing)

eClerx; Pune District, Mumbai; Hybrid; INR 1,400,000 - 2,300,000; Full time

Job summary

eClerx is seeking a seasoned Business System Analyst (Technical BA) to bridge business stakeholders and IT teams for data warehouse and BI initiatives across Pune and Mumbai in a hybrid model. The role demands 7–10 years of BA experience, strong data warehousing concepts, and hands-on SQL and ETL tool expertise.

You will gather requirements, translate them into detailed specs, collaborate with data architects, design star/snowflake schemas, and validate data quality, dashboards, and reports,

Qualifications

• 7–10 years of BA experience in data warehousing/BI/ETL.
• Strong SQL for data analysis and validation.
• Experience with ETL tools (Informatica preferred).

Responsibilities

• Engage with business users to understand data and reporting needs.
• Gather, document, and analyze business, functional, and technical requirements for data warehousing and BI.
• Translate requirements into source-to-target mappings, data flow diagrams, and ETL specifications.
• Collaborate with data architects, data engineers, and ETL developers to design scalable data warehouse solutions.
• Validate data integration processes, data quality rules, and reconciliation between source and target systems.
• Support data modeling activities (star schema, snowflake, fact and dimension design).
• Assist in defining metadata, lineage, and governance requirements.
• Create and execute UAT plans for data warehouse deliverables.
• Develop ad-hoc SQL queries for requirement validation, data profiling, and reconciliation.
• Act as the primary liaison between business stakeholders and the technical development team.
• Prepare BRD, use cases, and user stories.
• Support production releases and post-implementation reviews.

Skills

Business Analysis

Data Warehousing

ETL

SQL

BI Tools

Agile/Scrum

Communication

Documentation

Education

Bachelor's degree in Computer Science / Information Systems

Tools

Informatica

Tableau

Power BI

Qlik

Job description

Job Title: Business System Analyst (Technical BA)

Experience: 7-10 Years

Location: [Pune, Mumbai, Hybrid]

Shift : EMEA

Employment Type: Full-Time

Department: Business Intelligence / Data Analytics / IT

Job Summary

We are seeking a detail-oriented and technically strong Business Analyst with expertise in Data Warehousing and Business Intelligence (BI). The Technical BA will act as the bridge between business stakeholders and technical teams, gathering and analyzing requirements, translating them into functional and technical specifications, and ensuring successful delivery of data warehouse and analytics solutions.

Key Responsibilities

• Engage with business users to understand data and reporting needs.
• Gather, document, and analyze business, functional, and technical requirements for data warehouse and BI initiatives.
• Translate requirements into source-to-target mappings (STTM), data flow diagrams, and ETL specifications.
• Collaborate with data architects, data engineers, and ETL developers to design scalable data warehouse solutions.
• Validate data integration processes, data quality rules, and reconciliation between source and target systems.
• Support data modeling activities (star schema, snowflake, fact and dimension design).
• Assist in defining metadata, lineage, and governance requirements.
• Create and execute user acceptance test (UAT) plans for data warehouse deliverables.
• Develop ad-hoc SQL queries for requirement validation, data profiling, and reconciliation.
• Act as the primary liaison between business stakeholders and the technical development team.
• Prepare documentation such as BRD, use cases, user stories.
• Support production releases and post-implementation reviews.

Required Skills & Qualifications

• 7-10 years of experience as a Business Analyst with data warehousing / BI / ETL projects.
• Strong understanding of data warehousing concepts (ETL, OLAP, data marts, dimensional modeling).
• Proficiency in SQL for data analysis and validation.
• Experience working with any ETL tools (preferably Informatica).
• High level knowledge of reporting/visualization tools (Tableau, Power BI, Qlik, etc.) (Not Mandatory)
• Familiarity with data governance, lineage, and master data concepts.
• Experience working in Agile/Scrum methodology (user stories, backlog management, acceptance criteria).
• Strong communication, stakeholder management, and documentation skills.
• Bachelors degree in Computer Science, Information Systems, or a related field.

Soft Skills

• Analytical and detail-oriented mindset.
• Strong problem-solving and critical-thinking abilities.
• Ability to work independently and in cross-functional teams.
• Strong stakeholder communication and expectation management.