Business Analyst

Sales Data Analysis & Reporting

• Analyze sales data, trends, and patterns to provide actionable insights to the sales team.

• Create comprehensive sales reports, dashboards, and performance metrics.

• Track and analyze key performance indicators (KPIs) including conversion rates, pipeline health, and revenue metrics.

• Identify opportunities for sales growth and process optimization through data analysis.

• Prepare executive presentations and sales forecasts with data visualizations.

• Monitor competitor activities and market trends to support strategic planning.

• Design and implement automated workflows using Google Apps Script to streamline sales operations.

• Develop custom scripts to automate repetitive tasks, data entry, and report generation.

• Create and maintain automated email notifications, follow-up reminders, and task management systems.

• Optimize sales pipelines and identify bottlenecks using data-driven approaches.

• Implement efficiency improvements that reduce manual work and increase productivity.

• Integrate various tools and platforms to create seamless sales workflows.

• Design and maintain complex Google Sheets models for sales tracking, forecasting, and analysis.

• Create dynamic dashboards with advanced formulas, pivot tables, and data validation.

• Manage CRM data quality, ensuring accuracy and completeness of sales information.

• Develop standardized templates and frameworks for sales documentation.

• Implement data governance practices to maintain data integrity.

• Create and maintain centralized databases for client information, proposals, and contracts.

• Leverage AI tools to enhance sales processes, proposal generation, and customer insights.

• Implement AI-powered solutions for lead scoring, predictive analytics, and sales forecasting.

• Explore and integrate AI tools (ChatGPT, Claude, Gemini, etc.) for content creation and analysis.

• Develop AI-assisted workflows for client research, market analysis, and competitive intelligence.

• Train sales team on effective use of AI tools to improve productivity.

• Stay updated on emerging AI technologies applicable to sales operations.

Sales Support & Collaboration

• Collaborate with sales team to understand business requirements and pain points.

• Provide technical support for sales tools, systems, and processes.

• Create sales enablement materials, templates, and documentation.

• Assist in proposal preparation, pricing analysis, and deal structuring.

• Support new client onboarding processes with data setup and documentation.

• Coordinate with technical teams for custom solution requirements.

Strategic Planning & Insights

• Conduct market research and competitive analysis to support sales strategy.

• Analyze customer behavior patterns and provide insights for targeted campaigns.

• Support sales territory planning and resource allocation decisions.

• Identify cross-selling and upselling opportunities through data analysis.

• Contribute to sales strategy development with data-backed recommendations.

• Monitor industry trends and technology adoption relevant to our services.

Must-Have Skills

• Knowledge of AI: Strong understanding of AI tools and their applications in business processes, including ChatGPT, Claude, Gemini, and other generative AI platforms for automation, analysis, and content generation.

• Google Apps Script: Proficiency in writing and implementing Google Apps Script for automation, custom functions, and workflow optimization across Google Workspace applications.

• Google Sheets: Advanced expertise in Google Sheets including complex formulas (QUERY, ARRAYFORMULA, VLOOKUP, INDEX-MATCH), pivot tables, data validation, conditional formatting, charts, and dashboard creation.

Education:

• Bachelor's degree in Business Administration, Computer Science, Information Technology, Data Analytics, or related field.

• MBA or certifications in Business Analytics, Data Science, or Project Management are advantageous.

• Certifications in Google Workspace, Data Analytics, or AI tools are a plus.

• 2-4 years of experience as Business Analyst, Sales Analyst, or similar role.

• Proven experience in sales operations, process automation, or business intelligence.

• Hands-on experience with Google Apps Script and advanced Google Sheets.

• Experience working with CRM systems and sales tools.

• Background in technology or digital services industry is preferred.

Technical Proficiency

• Expert Level: Google Sheets (advanced formulas, scripts, dashboards).

• Proficient: Google Apps Script, Google Workspace suite.

• Strong Knowledge: AI tools (ChatGPT, Claude, Gemini, etc.).

• Good to Have: SQL, Python, Power BI, Tableau, or similar analytics tools.

• Familiar With: CRM platforms (Salesforce, HubSpot, Zoho, etc.).

• Understanding of API integrations and data workflows.

• Basic knowledge of web technologies and cloud platforms.

• Analytical Thinking: Strong ability to analyze complex data sets and derive meaningful insights.

• Problem-Solving: Creative approach to identifying and resolving business challenges.

• Technical Aptitude: Quick learner with strong interest in new technologies and tools.

• Attention to Detail: Meticulous in data accuracy, formula logic, and process documentation.

• Communication Skills: Ability to translate technical concepts into business language for stakeholders.

• Project Management: Capability to manage multiple initiatives and meet deadlines.

• Collaboration: Effective team player who works well across departments.

• Process Orientation: Systematic approach to building scalable and sustainable solutions.

• Innovation Mindset: Proactive in identifying opportunities for automation and efficiency.

• Business Acumen: Understanding of sales processes, metrics, and business objectives.

• Self-Motivation: Independent worker who takes initiative on improvements.

• Adaptability: Comfortable working in a dynamic, fast-paced environment.

Day-to-Day Activities

• Monitor and update sales dashboards with latest data.

• Run automated scripts and troubleshoot any issues.

• Analyze daily/weekly sales metrics and prepare reports.

• Respond to sales team requests for data analysis and custom reports.

• Develop and test new automation scripts and workflows.

• Maintain and optimize existing Google Sheets models.

• Research and implement AI solutions for recurring tasks.

• Collaborate with sales team on proposal requirements.

• Document processes and create training materials.

• Attend sales meetings to provide data insights.

What We Offer

• Competitive salary with attractive performance-based incentives.

• Opportunity to work with industries who are market leaders in their domains.

• Exposure to cutting-edge technology and innovative projects.

• Professional development and growth opportunities.

• Dynamic and collaborative work environment.

• Recognition and rewards for outstanding performance.

Professional Growth

• Diverse Portfolio Exposure: Work with 5300+ clients across 30+ industries, gaining invaluable cross-sector experience.

• Prestigious Client Base: Represent solutions to renowned market leaders.

• Skill Enhancement: Develop expertise across multiple domains – web development, digital marketing, SaaS products, and technology consulting.

• Career Progression: Clear growth path with opportunities to take on larger accounts and leadership roles.

• Innovation Culture: Be part of a team that develops cutting-edge SaaS products and stays ahead of technology trends.

• Learning Environment: Continuous exposure to latest technologies, market trends, and best practices in digital transformation.

Personal Development

• Work-Life Balance: We value your personal time and well-being alongside professional commitments.

• Youthful & Energetic Team: Collaborate with a professional, experienced, yet youthful team that brings fresh ideas and positive energy.

• Supportive Environment: Work in a culture where ideas are valued, challenges are opportunities, and success is celebrated together.

• Meaningful Work: Contribute to our mission of making the Internet a better place – work that matters beyond just numbers.

• Long-term Relationships: We invest in people who grow with us.

Interested candidates are requested to send their updated resume to careers@compubrain.com with the subject line: "Application for Business Analyst - SG Highway, Ahmedabad"

Please include:

• Updated resume/CV

• Cover letter highlighting relevant technical experience with AI, Apps Script, and Google Sheets.

• Examples or links to Google Sheets dashboards or Apps Script projects (if available).

• Any relevant certifications.

• Current and expected CTC.

• Notice period.

Note: Candidates may be asked to complete a technical assessment involving Google Sheets and Apps Script. Only shortlisted candidates will be contacted for further rounds.

CompuBrain Private Limited is India's preferred technology consulting firm with a mission to make the Internet a better place. We offer comprehensive solutions including website design & development, digital marketing, branding, SaaS products, and technology consulting services to 5300+ clients across 30+ industry verticals.