Key Responsibilities

1. Data Management & Reporting

• Collect, clean, validate, and consolidate data from multiple internal and external sources.

• Prepare and deliver daily, weekly, and monthly MIS reports for management and departments.

• Design, develop, and maintain dashboards to track KPIs, performance metrics, and operational trends.

2. Database & Data Accuracy Management

• Manage and regularly update internal databases, spreadsheets, and reporting systems.

• Ensure data accuracy, consistency, integrity, and confidentiality across all platforms.

• Implement best practices for data validation, version control, and audit checks.

3. Data Analysis & Business Insights

• Analyze large and complex datasets to identify trends, patterns, gaps, and anomalies.

• Translate data findings into transparent, actionable insights and recommendations to support strategic and operational decision-making.

4. Reporting Automation, System Recommendation & Implementation

• Identify opportunities to replace manual or semi-manual processes with automated, data-driven systems.

• Design and implement automated reporting frameworks, dashboards, and data pipelines using Excel (Power Query, VBA, Macros), SQL, BI tools, and Python.

• Proactively suggest new automation tools, system enhancements, or integrations to improve efficiency, accuracy, and scalability.

• Lead the end-to-end implementation of approved automation initiatives, including requirement gathering, system design, testing, deployment, and stabilization.





• Continuously monitor and optimize automated systems in line with business growth and evolving data needs.

5. Cross-Functional Coordination & Support

• Collaborate with Sales, HR, Finance, Operations, and other departments to understand reporting and data requirements.

• Provide support for ad-hoc analysis, custom reports, and special data requests.

• Act as a data partner to department heads for decision support and performance tracking.

6. Documentation & Compliance

• Maintain complete and updated documentation for MIS processes, reports, data models, automation logic, and system changes.

• Ensure compliance with company data governance policies and applicable data protection standards.

________________________________________

System Development & Data Structuring Responsibilities

• Study and understand departmental workflows to evaluate how data is generated, processed, and utilized.

• Review existing manual and digital data systems to identify operational gaps, risks, and improvement opportunities.

• Recommend structured data models, reporting formats, and storage solutions aligned with business requirements.

• Coordinate with department heads to define data structures, access levels,



and reporting standards.

• Implement new or upgraded data systems (Excel-based models, cloud platforms, ERP integrations) with minimal operational disruption.

• Design structured data formats and role-based access controls to ensure secure and organized data management.

• Train employees on newly implemented systems and provide post-implementation support.

• Monitor system performance, resolve issues, and continuously improve systems based on user feedback and organizational growth.

________________________________________

Qualifications & Experience

• Bachelor’s degree in Commerce, Statistics, Computer Applications, or a related field.

• 3–5 years of experience in data analytics, reporting, or system automation roles.

• Strong analytical thinking, logical reasoning, and problem-solving abilities.

• High attention to detail with excellent organizational and documentation skills.

________________________________________

Technical Skills (Must Have)

• Advanced Excel: Power Query, Power Pivot, VBA basics, Macros, Charts

• SQL: Complex joins, subqueries, CTEs, performance tuning

• Python or R: Data cleaning, analysis, automation (Pandas, NumPy, etc.)

• BI Tools: Power BI or Tableau (DAX, data modeling, dashboard optimization)

• Data Warehousing Concepts: ETL processes, OLAP, Star/Snowflake schema

Skills:- PowerBI, : Power Query, Tableau, Advance excel, Google sheets, looker studio, VLOOKUP, Python, R, VBA , Macros and Data Analytics

📌 Senior Data Analyst - Ahmedabad
🏢 Hunarstreet Technologies
📍 Ahmedabad