Business Analyst (Retail Domain)
Role details
Job location
Tech stack
Job description
- Collect, review, and validate metadata for existing SAP BO iRAP local reports.
- Perform enrichment of the initial report batches as outlined in the DWHR Report Rationalisation Playbook.
- Map report owners, usage patterns, data sources, universes, SQL scripts, KPIs, and consumers.
- Apply the Rationalisation Framework: Retire, Replace, Refactor, Rebuild.
- Conduct relevance analysis based on active users, business process alignment, usage patterns, and technical dependencies.
- Use similarity matrices, lineage, and clustering logic to group reports logically.
- Facilitate working sessions with business teams to finalise rationalisation decisions.
- Lead business workshops for reviewing enriched group/batch inventories.
- Align with business leads, coordinators, and functional stakeholders to understand requirements and validate recommendations.
- Document business expectations and playback validated outcomes.
- Gather functional requirements for target Power BI reports and KPIs.
- Collaborate with business stakeholders to create wireframes for new or consolidated reports.
- Ensure alignment with semantic models, business process flows, and future-state data architecture.
- Work with technical teams to compile end-to-end lineage from source systems, DWH views, and reports.
- Validate mappings for facts, dimensions, metrics, and calculations.
- Ensure metadata accuracy for Collibra updates (report catalog, SQL view catalog).
- Support estimation and planning activities.
- Contribute inputs to rationalisation and realisation estimation models (effort/complexity classification: S, M, L, XL).
- Validate complexity drivers such as pages/tabs, KPIs, transformations, visual types, and modeling requirements.
- Work with Migration Accelerator teams (metadata extraction, automation output validation) and Data Modeling teams (fact/dimension design alignment), as well as Power BI developers.
Requirements
Do you have experience in SQL?, Business Analyst with 8+ years of experience, seasoned in Retail. Expert in Power BI target-state design, EDWH architecture, data lineage, metadata governance (Collibra), SQL analysis, and stakeholder facilitation. Leads report rationalisation, metadata enrichment, and requirements definition, aligning SAP BO reporting with future EDWH and Power BI through close business and technical collaboration., * At least 8 years of relevant experience, seasoned in Business Analysis in Retail
- Skilled in Power BI reporting concepts and target-state design
- Knowledge of Enterprise Data Warehouse (EDWH) architecture
- Experience in data lineage analysis
- Knowledge of metadata management and governance (Collibra)
- SQL analysis and report universe understanding
- Strong analytical capability, stakeholder engagement skills, and a deep understanding of business processes, metadata, and reporting ecosystems
- Ability to facilitate and moderate business workshops
- Ability to translate business needs into technical requirements
- Strong cross-functional collaboration with technical and analytics teams, * Attention to detail and data accuracy
- Analytical mind - conceptual thinking
- Structured approach
- Problem-solver
- Quality-minded with an eye for detail
- Goal-oriented
- Open to change
Benefits & conditions
- Great team of smart people, in a friendly and open culture
- Expand your knowledge of various business industries
- Create content that will help our users on a daily basis
- Real responsibilities and challenges in a fast evolving company
Work at yechte
We are an independent digital consultancy with ambitious goals and a global presence. We support a diverse range of companies, building digital teams and delivering innovative digital solutions. Our multicultural and diverse workforce, comprised of 'Global Citizens', reflects this inclusivity.
We care about work-life balance and meeting the expectation of a growing team, investing in people because they are our greatest asset. Our consistent growth is a testament to this commitment.
Come work at yechte, a company on the rise, offering excellent benefits, opportunities for personal development, and the chance to learn from accomplished leaders. We are always looking for exceptional professionals to join our team.