Data Analyst

Aloola; Surat; On-site; INR 800,000 - 1,400,000; Full time

Job summary

Aloola is seeking a data analyst to transform data into insights using Google BigQuery and Looker Studio. You will manage data pipelines, design dashboards, and work with cross-functional teams to ensure data accuracy and actionable reporting.

The role requires strong SQL skills, experience with data warehousing, and the ability to translate complex data into clear visualizations for stakeholders. This is a full-time position based in Surat.

Qualifications

• Bachelor's degree in a related field or equivalent experience.
• 4+ years hands-on experience with Google BigQuery and Looker Studio (or Data Studio).
• Strong SQL and data modeling skills with ETL experience.

Responsibilities

• Design, develop, and maintain BigQuery data pipelines.
• Write complex SQL queries to transform data from multiple sources.
• Build, optimize, and maintain dashboards in Looker Studio.

Skills

SQL

BigQuery

Looker Studio

Education

Bachelor's degree in CS/DS/IS/Statistics

Tools

BigQuery

Looker Studio

Job description

Job Summary

We are seeking a skilled Data Analyst with expertise in Google BigQuery and Looker Studio to join our analytics team. In this role, you will leverage your technical and analytical skills to transform data into actionable insights, enabling data-driven decision-making across the organization. Your primary responsibilities will involve managing data in BigQuery, designing and building insightful dashboards in Looker Studio, and collaborating with cross-functional teams to ensure data accuracy and relevance.

Location: Surat

Job Type: Full-time

Responsibilities

• Data Management Transformation: Design, develop, and maintain efficient and scalable BigQuery data pipelines.
• Data Management Transformation: Write complex SQL queries to retrieve, transform, and analyze data from multiple sources.
• Data Management Transformation: Ensure data quality and integrity by implementing validation checks and optimizing data structures.
• Data Visualization Reporting: Build, optimize, and maintain interactive dashboards and reports in Looker Studio to present data-driven insights.
• Data Visualization Reporting: Collaborate with stakeholders to understand reporting needs, translating them into effective visualizations and dashboards.
• Data Visualization Reporting: Ensure that dashboards are user-friendly, insightful, and aligned with business goals.
• Collaborative Analysis: Work closely with stakeholders across departments (e.g., marketing, finance, operations) to understand business needs and define data requirements.
• Collaborative Analysis: Provide insights and recommendations based on data analysis to support strategic business decisions.
• Collaborative Analysis: Train end-users on how to use Looker Studio dashboards effectively.
• Data Governance Optimization: Maintain best practices for data governance, privacy, and security in compliance with industry standards.
• Data Governance Optimization: Optimize BigQuery performance, including cost management and query optimization strategies.

Qualifications

• Education: Bachelor's degree in Computer Science, Data Science, Information Systems, Statistics, or a related field (or equivalent experience).

Preferred Qualifications

• Knowledge of Google Cloud Platform (GCP) beyond BigQuery, including Cloud Storage, Cloud Functions, and Dataflow.
• 4+ years of hands-on experience with Google BigQuery and Looker Studio (or Data Studio).
• Technical Skills: Proficient in SQL and comfortable writing complex queries in BigQuery.
• Familiarity with ETL (Extract, Transform, Load) processes and data modeling.
• Solid understanding of data visualization principles and experience designing reports in Looker Studio.
• Experience with data warehousing and knowledge of cloud-based data architecture.
• Soft Skills: Strong analytical and problem-solving abilities, with a keen eye for detail.
• Excellent communication skills and ability to translate complex data insights into actionable recommendations.
• Ability to work both independently and collaboratively in a fast-paced environment.
• Experience: 4+ years of experience
• Job Type: Full-time (WFO Only)