Job
Description
Collect, clean, and validate data from multiple internal systems (ERP, CRM, etc.) to ensure accuracy and integrity. Design and maintain data structures and SQL queries to support regular and ad-hoc reporting needs. Monitor data flows and resolve issues related to inconsistencies, missing records, or integration errors. Create and maintain comprehensive reports, dashboards, and scorecards using Power BI, Tableau, and Excel, tailored to business requirements. Build interactive, automated dashboards that deliver actionable insights for key stakeholders across departments such as Sales, Finance, and Operations. Use Excel to develop financial and operational models, including pivot tables, charts, and macros for daily, weekly, and monthly reporting. Generate variance reports, trend analyses, and forecasting models to support strategic planning. Write complex SQL queries for efficient data extraction, aggregation, and transformation from relational databases. Optimize SQL queries to ensure high performance and minimal impact on system resources. Analyze data to uncover trends, patterns, and business opportunities. Provide data-driven insights and actionable recommendations to support strategic decision-making. Support senior management with predictive analytics and “what-if” scenario modeling using historical data. Collaborate closely with department heads to gather reporting requirements and translate business needs into effective technical solutions. Train and support end-users to ensure they can effectively interact with dashboards and reports. Identify and implement opportunities to improve reporting processes through automation and standardization. Ensure all data handling and reporting practices comply with organizational policies and data protection standards. Manage user access controls and permissions for sensitive reports and dashboards to maintain data security. Job Types: Full-time, Permanent Pay: ₹15,000.00 - ₹25,000.00 per month Benefits: Health insurance Leave encashment Provident Fund Schedule: Day shift Supplemental Pay: Yearly bonus Work Location: In person
