Technical Business Analyst (Data warehousing)

eClerx; Pune District; Hybrid; INR 1,800,000 - 2,800,000; Full time

Job summary

eClerx is seeking a detailed and technically strong Business System Analyst (Technical BA) with expertise in Data Warehousing and BI. The role acts as a bridge between business stakeholders and technical teams, gathering requirements and translating them into functional and technical specifications for data warehouse and analytics solutions.

The candidate will collaborate with data architects, engineers, and ETL developers to design scalable data warehouse solutions and ensure data quality and

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.

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.

Skills

7-10 years experience

Data warehousing

BI

ETL

SQL

Agile/Scrum

Communication skills

Education

Bachelor’s degree in Computer Science or Information Systems

Tools

Informatica

Tableau

Power BI

Qlik

Job description

Job Title

Business System Analyst (Technical BA)

Experience

710 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.
• Bachelor’s 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.