Data Analyst

ConnectWise; Pune District; On-site; INR 600,000 - 1,000,000; Full time

Job summary

ConnectWise in Pune, India is hiring a Data Analyst to turn complex data into actionable insights. You will design Power BI dashboards, optimize queries in Snowflake, and implement DBT‑driven data models to support strategic decisions.

You will partner with stakeholders to define metrics, document business logic, and ensure data quality across reporting layers within a governed analytics environment.

Qualifications

• Bachelor's degree in data analytics, CS, statistics, or related field.
• Strong hands‑on experience with Power BI, including DAX and data modeling.
• Advanced proficiency in Snowflake and complex SQL query development.
• Practical experience using DBT for data transformation and modeling.
• Solid understanding of operational metrics, KPIs, and reporting frameworks.
• Excellent analytical thinking, problem solving, and documentation skills.
• Ability to work independently under pressure in dynamic environments.
• Strong communication and stakeholder‑management capabilities.

Responsibilities

• Design, develop, and maintain high quality Power BI dashboards for internal stakeholders.
• Transform raw datasets into clear insights through data visualization and analytics.
• Ensure outputs are accurate, intuitive, and aligned with governance standards.
• Partner with stakeholders to gather and refine reporting requirements.
• Document business logic, data definitions, KPIs, and data models clearly.
• Write and optimize SQL queries within Snowflake to support analytics needs.
• Build and maintain scalable data models and DBT transformations.
• Analyze operational metrics, generate insights, and drive process improvements.
• Deliver high‑quality outputs in fast‑paced environments with strong time management.

Skills

Power BI

Power BI DAX

Data modeling

SQL (Snowflake)

DBT

KPIs & metrics

Documentation

Stakeholder management

Communication

Independent work

Education

Bachelor's degree in Data Analytics, Computer Science, Statistics, or related discipline

Tools

Snowflake

DBT

Power BI

Job description

The Data Analyst plays a critical role in converting complex data into actionable insights that inform strategic and operational decision‑making. This role requires strong analytical expertise, advanced proficiency in Power BI, Snowflake, and DBT, and the ability to independently manage multiple initiatives across diverse stakeholder groups. The ideal candidate brings a solid understanding of operational metrics, business logic documentation, and end‑to‑end dashboard development within a governed analytics environment.

Key Responsibilities

• Design, develop, and maintain high‑quality Power BI dashboards to support internal business stakeholders.
• Transform raw, complex datasets into clear, actionable insights through effective data visualization and analytics.
• Ensure reporting outputs are accurate, intuitive, visually compelling, and aligned with business requirements and data governance standards.

Stakeholder Management & Requirements Gathering

• Partner closely with business stakeholders to gather, validate, and refine reporting and analytics requirements.
• Document business logic, data definitions, operational KPIs, data models, and technical transformations in a clear and structured manner.
• Communicate effectively with cross‑functional teams, proactively managing expectations and dependencies.

Technical Skills

• Write and optimize complex SQL queries within Snowflake to support analytical and reporting needs.
• Build and maintain scalable data models and transformations using DBT (Data Build Tool).
• Ensure data accuracy, consistency, and quality across all reporting layers and analytical assets.

Operational Metrics & Analysis

• Analyze and monitor key operational metrics to provide visibility into business performance.
• Generate insights and recommendations that drive process improvements, efficiency gains, and better business outcomes.
• Deliver high‑quality analytical outputs in fast‑paced environments with tight timelines.
• Manage multiple projects concurrently with strong prioritization, organization, and time‑management skills.
• Operate independently with minimal supervision, demonstrating strong ownership, accountability, and follow‑through.

Qualifications & Skills

• Bachelor’s degree in Data Analytics, Computer Science, Statistics, or a related discipline.
• Strong hands‑on experience with Power BI, including DAX, data modeling, and dashboard design.
• Advanced proficiency in Snowflake and complex SQL query development.
• Practical experience using DBT for data transformation, modeling, and pipeline development.
• Solid understanding of operational metrics, KPIs, and performance reporting frameworks.
• Excellent analytical thinking, problem‑solving, and documentation skills.
• Ability to work independently under pressure in dynamic business environments.
• Strong communication skills with proven stakeholder‑management capabilities

Preferred Attributes

• Highly detail‑oriented with a strong focus on data accuracy, quality, and governance.
• Proactive, self‑motivated, and comfortable taking end‑to‑end ownership of analytics initiatives.
• Strong ability to translate business questions into scalable, data‑driven analytical solutions.