Data & Reporting Specialist (Jaipur)

Data & Reporting Specialist (Jaipur)

21 Nov
|
ClickForge
|
Jaipur

21 Nov

ClickForge

Jaipur

Position Summary

We are seeking a detail-oriented Data & Reporting Specialist to support system data maintenance, data processing, pricing analysis, and business reporting.

This position requires advanced Microsoft Excel skills, particularly Power Query, along with hands-on experience developing and maintaining Power BI reports. Basic SQL knowledge is required to understand and modify existing queries used within Excel Power Query. Experience running Python scripts is preferred but not required.

The position will primarily support Sourcing and Supply Chain operations while coordinating with other departments as needed. Responsibilities also include vendor communication and banking information verification.

Key Responsibilities

Data Management & System Support

- Maintain and update system data, ensuring accuracy, completeness, and consistency.
- Prepare and maintain data files for ERP system uploads, analysis, and reporting.
- Work with large datasets from multiple sources and reconcile discrepancies.
- Investigate data issues and coordinate with internal departments to resolve them.
- Organize and maintain recurring data processes.

Excel, Power Query & Power BI

- Utilize advanced Excel functions, including Power Query, lookup formulas, PivotTables, and data validation.
- Develop, maintain, and troubleshoot Power Query processes.
- Build, modify, and maintain Power BI reports and dashboards.
- Support data modeling, report refreshes, and basic DAX calculations.
- Read, understand, and make minor modifications to SQL queries, including SELECT statements, filters, and joins.
- Identify opportunities to automate recurring data preparation and reporting tasks.

Pricing & Sourcing Support

- Review and compare vendor pricing files,



identify discrepancies, and summarize findings.
- Prepare pricing comparisons and analysis for management.
- Support sourcing activities through data analysis and reporting.
- Maintain accurate vendor, item, and pricing information.
- Assist with data preparation for sourcing projects and system updates.

Vendor Communication

- Communicate with vendors to confirm banking information and obtain supporting documentation.
- Follow company procedures for verification of confidential banking information.
- Coordinate with internal departments to resolve vendor information discrepancies.
- Assist with other data-related administrative activities as needed.

Required Qualifications

- Advanced proficiency in Microsoft Excel, particularly Power Query, lookup formulas, PivotTables, and data validation.
- Hands-on experience developing and maintaining Power BI reports.
- Basic SQL knowledge, including the ability to understand and modify existing queries.
- Experience working with large datasets and reconciling information across multiple files or systems.
- Robust analytical and problem-solving skills.
- Excellent attention to detail.
- Strong organizational skills and ability to manage multiple assignments.
- Ability to work independently and troubleshoot data-related issues.
- Clear written and verbal communication skills.
- Ability to handle confidential business and banking information appropriately.

Preferred Qualifications

- Basic Python knowledge, including the ability to run existing scripts and make minor adjustments.
- Experience with ERP systems and system data uploads.
- Experience in purchasing, sourcing, supply chain, vendor management, or pricing analysis.
- Experience improving or automating recurring data workflows.

📌 Data & Reporting Specialist (Jaipur)
🏢 ClickForge
📍 Jaipur

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: data & reporting specialist (jaipur) / jaipur

Subscribe to this job alert:

Get the latest job offers by email for: data & reporting specialist (jaipur) / jaipur