OBJECTIVE OF THE POSITION

As a Junior Data Analyst, you will help turn our operational data into clear, accurate reports and insights that teams across the business can rely on. You will support the BI & Analytics function by writing SQL queries, maintaining reports and dashboards, checking data quality, and answering day-to-day data requests from Finance, Sales, Collections, Resort Operations, and the Contact Centre. You will also help maintain the company's in-house application, resolve user issues in line with our documentation, and prepare contract documentation in Zoho Writer.

This is an excellent opportunity for an early-career analyst who wants to learn quickly in a hands-on environment. You will receive guidance and mentoring, gain exposure to a large real world hospitality dataset, and grow alongside our new data and AI capability.

RESPONSIBILITIES

Reporting and Dashboards

- Build and maintain dashboards in Power BI and Zoho Analytics under the guidance of senior team members.
- Respond to ad-hoc data requests from business teams, clarifying what is needed and delivering accurate, well-presented results.
- Help inventory existing vendor-produced reports and support rebuilding them in the new reporting stack.

Data Querying and Quality

- Write and maintain SQL queries against our MySQL 8 reporting database to extract and analyse data.
- Check reports and outputs against source figures and flag discrepancies, missing data, or unusual values.
- Help identify and document common data issues such as invalid dates, duplicate or soft deleted records, and coded lookup values.
- Assist in documenting tables, relationships, and data sources in a large, poorly documented schema.

Analysis and Insights

- Analyse trends in bookings, occupancy, sales, and collections and summarise findings in plain language.
- Support the creation and upkeep of a metric dictionary with agreed definitions (for example, occupancy, collection rate, delinquency buckets, net sales).
- Assist with data preparation for AI and machine-learning initiatives, such as member segmentation and collections risk analysis.





In-house Application Support and Maintenance

- Support the day-to-day maintenance of the company's in-house application so that it runs reliably and accurately for its users.
- Log, investigate, and troubleshoot issues reported by users, identifying the root cause and providing timely solutions or workarounds.
- Escalate complex technical issues to the Team Leader or development team with clear details, steps to reproduce, and supporting evidence.
- Test fixes, updates, and new features before release and confirm they work as expected.
- Keep the application's documentation up to date, including user guides, process notes, known issues, and change logs, and ensure all fixes and updates follow the documented standards.

Contract Documentation (Zoho Writer)

- Create, format, and maintain contract documentation and templates in Zoho Writer in line with company standards.
- Set up and maintain merge fields and data-linked templates so contract documents are generated accurately from source data.
- Review contract documents for accuracy and consistency, and coordinate with Sales, Finance, and Legal teams on required changes.
- Maintain version control and an organised library of contract templates and related documentation, ensuring member and contract data is handled securely.

Data Governance and Security

- Follow company information security, privacy, and compliance policies, including GDPR and other applicable data protection laws.
- Handle personal data (PII) responsibly, using only approved, masked, or role appropriate datasets and sharing reports only with the right audience.
- Never expose credentials or sensitive data in code, tools, or shared reports.

Collaboration and Support





- Work with business users to understand their questions and explain data and reports in simple terms.
- Help create user guides and short training material so colleagues can self-serve from dashboards.
- Keep work organised, track requests, and communicate progress clearly to the Team Leader.

REQUIREMENTS

Essential

- Bachelor's degree in Computer Science .
- 0–2 years' experience in data analysis, reporting, or BI
- Good working knowledge of SQL: SELECT queries, joins, filtering, grouping, and aggregations. Exposure to CTEs or window functions is a plus.
- Strong Microsoft Excel skills, (XLOOKUP/VLOOKUP), and basic charts. including pivot tables, lookups
- Basic experience with Power BI or a similar BI tool (building visuals, simple data models, or basic DAX).
- Strong attention to detail and a careful approach to checking numbers.
- Awareness of data privacy and the importance of handling personal data responsibly.
- Explicit written and verbal communication in English, including the ability to write clear documentation, and a willingness to learn quickly.
- A logical, problem-solving approach to investigating and resolving user and application issues.

Desirable

- Experience with Zoho Analytics or other BI platforms.
- Experience with Zoho Writer (templates, merge fields, document automation) or other Zoho applications.
- Experience supporting or maintaining a business application, including issue tracking and troubleshooting.
- Familiarity with Python (e.g., pandas) for data cleaning or automation.
- Understanding of basic data modelling concepts such as star schemas, fact and dimension tables.
- Interest in or exposure to hospitality, hotels, timeshare/vacation ownership, or membership businesses.
- Basic understanding of finance concepts such as receivables, instalments, and collections.
- Interest in AI/LLM tools applied to business data, such as natural-language querying.

Pay: From ₹25,000.00 per month

Benefits

- Health insurance
- Life insurance
- Paid sick time
- Paid time off
- Provident Fund

Work Location: In person

📌 Junior Data Analyst (Bellandur)
🏢 Karma Group Global
📍 Bellandur