Jobs
Interviews
RentoMojo logo

Data Analyst - Reporting & Insights (SQL + Automation Expert)

0 years

0 Lacs

Bengaluru Karnataka India

Posted:1 week ago| Platform: Linkedin logo

Apply

Skills Required

data reporting sql automation power postgresql mysql aws automate metrics engineering storytelling mongodb reports query pipeline orchestration marketing finance drive integrity scheduling excel tableau python node.js scripting stack redshift analytics looker

Work Mode

On-site

Job Type

Full Time

Job Description

About The Role

We’re looking for a sharp, analytical, and business-savvy Data Analyst who is a power user of SQL across platforms like PostgreSQL, MySQL, and AWS Athena. In this role, you won’t just write high-performance queries—you’ll also automate reporting flows, build scalable pipelines, and ensure real-time visibility into business metrics across teams.If you thrive at the intersection of data engineering, automation, and business storytelling, this role is for you.Key Responsibilities
  • Build, optimize, and maintain complex SQL queries on Postgres, MySQL, MongoDB and Athena to generate actionable reports and dashboards.
  • Automate query execution and reporting via Google Sheets, using AWS Lambda or equivalent serverless solutions.
  • Set up and manage scheduled jobs, alerts, and workflows using AWS Data Pipeline, Step Functions, or similar orchestration tools.
  • Partner with business stakeholders (Ops, Marketing, Finance, Product) to understand reporting needs and deliver high-impact solutions.
  • Own day-to-day reporting requirements—automated and ad-hoc—including operational metrics, cohort analyses, funnel reports, and performance dashboards.
  • Identify data gaps, inconsistencies, and propose scalable solutions for reporting infrastructure.
  • Translate business problems into analytical tasks and convert data into insights that drive decision-making.
  • Collaborate with Data Engineering/Platform teams to ensure data integrity and pipeline reliability.
Must-Have Skills
  • Advanced SQL proficiency across PostgreSQL, MySQL, and AWS Athena.
  • Strong experience in automating data workflows, especially pushing query outputs to Google Sheets using AWS Lambda or similar tools.
  • Knowledge of AWS Data Pipeline, Glue jobs, and scheduling/event-driven processing.
  • Experience with data modeling and structuring datasets for analytics.
  • Comfortable navigating large and messy datasets to answer open-ended business questions.
  • Proficient in Excel and/or BI tools (e.g., Metabase, Power BI, Tableau, Looker).
  • Good understanding of business KPIs and ability to derive insights from raw data.
Bonus Points
  • Experience with Python or Node.js for Lambda scripting and automation.
  • Familiarity with DBT or modern data stack (e.g., Snowflake, Redshift, Fivetran).
  • Exposure to product or supply chain analytics in a fast-paced environment.
Skills: google sheets,bi tools,postgres, mysql, mongodb,metabase,looker,excel,aws lambda,aws athena,automating data workflows,postgresql,aws data pipeline,power bi,step functions,sql,data modeling,tableau,mysql

More Jobs at RentoMojo

Warehouse Executive- After sales

Ahmedabad, Gujarat, India

Experience: Not specified

|

INR 3 - 12 Lacs

Logistics Coordinator

Gurgaon / Gurugram, Haryana, India

Experience: Not specified

|

INR 3 - 10 Lacs

SEO Executive

Bengaluru / Bangalore, Karnataka, India

Experience: Not specified

|

INR 3 - 11 Lacs

Warehouse Executive- After sales

Gurgaon / Gurugram, Haryana, India

Experience: Not specified

|

INR 2 - 11 Lacs

Assistant Manager -Taxation

Bengaluru / Bangalore, Karnataka, India

5.0 - 10.0 yrs
|

INR 3 - 14 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Google Play App Store
coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
RentoMojo logo
RentoMojo

Technology, Information and Internet

Bangalore Karnataka

RecommendedJobs for You

RentoMojo logo

Data Analyst - Reporting & Insights (SQL + Automation Expert)

RentoMojo

Bengaluru, Karnataka, India

RentoMojo logo

Data Analyst - Reporting & Insights (SQL + Automation Expert)

RentoMojo

Bengaluru, Karnataka, India