3+ Macros Jobs in Ahmedabad | Macros Job openings in Ahmedabad

We are seeking a highly analytical and detail-oriented Senior Data Analyst to lead data management, reporting, automation, and system development initiatives across the organization. The role focuses on transforming raw data into meaningful insights, designing and implementing automated systems, strengthening data structures, and supporting cross-functional teams with accurate, actionable intelligence to drive strategic and operational business decisions.

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 clear, 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
• 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
• Google Apps Script: Automation in Google Sheets, custom functions, triggers, API integrations, workflow optimization

Task:

• Make documentations with formatting and in proper detailing
• Basic knowledge on Excel working with formula handling & reporting.
• Need to do multitasking, able to deliver tasks on time with expected quality
• Candidate should have thinking out of the box which supports the department to deliver good results in the pre-defined processes.
• Needs to be quick learner and able to come up with own thoughts on the tasks explained/shared to deliver good results
• Work closely with German team for operative processes/execution/deliverables.
• Flexible to adopt the changes in terms of processes/task handling.
• Knowledge on order fulfillment processes, managing support content on the website, inputs on support handling processes are added advantage.

We wish:

• At least bachelor in any stream or equivalent experience
• At least 1 year of experience in MS-Excel or similar office tools – is preferred
• Knowledge on VB script, macros is preferred
• Documentation skills
• Good Communication skills, at least speaking in English is required
• Good analytical skills
• Eager to know/experiment new technology and tools
• Web Browsing , ability to search quick results from web
• Experience on process documentation & presentation is preferred
• Ability to work independently with little or no daily supervision
• Out of box thinking and quick learner with willingness to learn new things

We Offer:

• Freedom to realise your own ideas & individual career & development opportunity.
• A motivating work environment, flat hierarchical structure, numerous company events which cannot be forgotten and fun at work place with flexibilities.
• Professional challenges and career development opportunities.