Data Analyst

Job Title: Data Analyst

Location : Barrackpore, Kolkata

Experience : 2-3 Years

About PointO

PointO is building modern, data-driven products that help businesses operate smarter and faster. We work at the intersection of operations, automation, and product innovation—turning messy workflows into simple, scalable systems. If you enjoy solving real business problems with data and tech, you’ll fit right in.

Role Overview

We’re looking for a highly analytical and tech-savvy professional who is exceptional with Excel and comfortable working with APIs, cloud software, and backend systems. You’ll support product and operations teams by building automated reports, integrating tools, and improving data flows across platforms.

This role is ideal for someone who loves structure, enjoys problem-solving, and thinks in terms of scalable systems.

Key Responsibilities

Advanced Excel & Reporting

• Build and maintain complex Excel models using Pivot Tables, Power Query, Power Pivot, advanced formulas, and dashboards.

• Automate recurring reports and business trackers to reduce manual work.

• Design clean, decision-ready dashboards for leadership and cross-functional teams.

• Validate data accuracy and troubleshoot reporting issues quickly.

API Integrations & Automation

• Work with internal and external APIs to pull/push data between systems.

• Configure and maintain integrations between PointO tools and third-party services.

• Support automation workflows using API logic, webhooks, or middleware tools when needed.

• Document integration logic clearly for internal reference.

Cloud & Backend Collaboration

• Understand cloud-based platforms (SaaS tools, cloud DBs, cloud automation).

• Work closely with backend engineers on data pipelines and system improvements.

• Assist in debugging basic backend issues involving Node.js and data flow.

Database & Data Handling

• Write and optimize SQL queries in MySQL for reporting and analysis.

• Extract, clean, and combine data from multiple sources.

• Support data structure improvements for better product insights.

Product & Process Thinking

• Understand business needs and translate them into scalable data/integration solutions.

• Identify inefficiencies and propose automation or tooling improvements.

• Collaborate with product teams to support experiments, metrics, and feature tracking.

Required Skills & Qualifications

• 2–3 years of relevant experience in data/reporting/integration/ops-tech roles.

• Expert-level Excel skills including:

• Pivot tables/charts

• Power Query / Power Pivot

• Complex formulas (INDEX-MATCH/XLOOKUP, SUMIFS, array formulas, etc.)

• Dashboarding & data modeling

• Strong understanding of API integrations (REST basics, JSON, auth tokens).

• Working knowledge of cloud software / SaaS ecosystems.

• Familiarity with backend concepts and environments:

• Node.js (basic understanding / ability to collaborate effectively)

• MySQL (solid querying skills)

• Strong analytical thinking and attention to detail.

• Ability to work independently and manage multiple tasks.

Good to Have / Advantageous

• Experience using or integrating Zoho (CRM, Analytics, Creator, or Zoho One stack).

• Product-thinking mindset: ability to look beyond tasks and understand user/business value.

• Exposure to automation tools (Zapier, Make, n8n, etc.).

• Experience working in startups or fast-moving teams.

What Success Looks Like in This Role

• Reporting becomes faster, cleaner, and more trusted.

• Repetitive manual tasks are replaced by automation.

• Data flows reliably between systems with minimal intervention.

• Teams get insights that directly drive product and operational decisions.

Why Join PointO?

• Work on real problems with high ownership and visibility.

• A chance to blend data + automation + backend understanding into one impactful role.

• Fast growth, steep learning curve, and collaboration with product and engineering leaders.