Job Title : Business Analyst

Experience : 1.5- 5 years

Reporting To : Head of Product

Location : Noida

Work Mode : Work from Office (5.5 Days)

About GyanDhan :

GyanDhan is India's leading platform for education financing, helping students secure loans for studying abroad. We partner with study abroad consultants to provide the best financial solutions for students.

About the Role :

We are looking for a highly analytical and execution-focused Business Analyst with deep expertise in data analytics and automation.

This is a data-intensive role, not a documentation-only BA role. The person in this role will own data systems that power business decisions. Strong hands-on capability in complex SQL querying, building automated dashboards, designing data pipelines, and enabling live reporting systems is mandatory.

If you do not have deep practical experience in data analytics and dashboard automation, this role is not a fit.

Key Responsibilities :

Data Analytics & Automation (Core Ownership Area) :

- Write complex SQL queries using joins, CTEs, window functions, subqueries, aggregations, and performance optimization techniques.

- Design, build, and maintain live dashboards tracking real-time business KPIs.

- Automate recurring reports and dashboards to eliminate manual reporting.

- Build and manage data pipelines in collaboration with Engineering.

- Ensure data accuracy, consistency, and governance across reporting systems.

- Conduct funnel, cohort, retention, and performance analysis.

- Identify tracking gaps and define event-level data requirements.

- Reduce manual Excel dependency by building scalable BI systems.

Business Requirement Analysis :

- Gather and structure business requirements from stakeholders across Product, Ops, Marketing, and Business teams.

- Convert business problems into clear functional and non-functional requirements.

- Create BRDs, FRDs, use cases, user flows, process maps, and data mapping documents.

- Identify edge cases, dependencies, and system integration requirements.

- Ensure requirement completeness before development begins.

Process Optimization :

- Map current business workflows and identify inefficiencies.

- Recommend data-backed process improvements.

- Align operational processes with system capabilities.

- Define measurable success metrics for process improvements.

Product & Engineering Collaboration :

- Translate business requirements into structured documentation for Engineering.

- Conduct requirement walkthroughs and align on scope and feasibility.

- Support sprint planning and backlog grooming.

- Assist in QA and UAT to ensure releases meet acceptance criteria.

- Track requirement changes and maintain documentation integrity.

Stakeholder Communication :

- Act as a bridge between Business, Ops, Product, and Engineering teams.

- Resolve ambiguities and proactively surface risks.

- Communicate impact analysis and data insights clearly.

- Ensure stakeholders are aligned on scope, timelines, and expected outcomes.

Must-Have Skills & Experience :

- Advanced SQL expertise (complex joins, CTEs, window functions, performance tuning).

- Proven experience building and maintaining live dashboards.

- Strong experience in dashboard automation and report automation.

- Experience working with data pipelines and large datasets.

- Strong hands-on experience with BI tools (Looker, PowerBI, Tableau, Metabase, etc.).

- Strong analytical thinking with ability to derive actionable insights from raw data.

Candidates lacking hands-on dashboard automation and complex query experience will not be considered.

Education : Bachelor's or Master's degree in Engineering, Computer Science, Economics, Mathematics, Statistics, or related fields preferred.

What You'll Get :

- Opportunity to work directly with senior product leadership and influence roadmap.

- Ownership of meaningful product problems with visible business impact.

- Exposure to high-impact business problems in a fast-growing environment.

- Ownership of data systems that directly influence strategic decisions.

- Strong growth trajectory in analytics, systems thinking, and execution excellence.