Data Analyst (Excel | SQL | Power BI | Automation)

Job Overview

Job Description – Data Analyst (Excel | SQL | Power BI | Automation)

Job Title:

Data Analyst

Location: Bharatpur  –  Rajasthan 321001

Job Summary:

We are looking for a skilled Data Analyst who can analyze data, create dashboards, and

automate reports to support business decision-making. The candidate must have strong

hands-on experience in Excel, SQL, Power BI, and Outlook Email Automation. Automation

knowledge is a critical requirement for this role.

 

Roles & Responsibilities:

• Analyze business data and generate actionable insights and

• Develop MIS reports and dashboards using Excel and Power BI

• Write and optimize SQL queries for reporting

• Automate recurring reports and email notifications

• Maintain data accuracy and documentation

• Coordinate with business and operations teams

• Improve and optimize existing reporting processes

Preferred Candidate Profile:

• Strong analytical and problem-solving skills

• Hands-on experience with data and automation

• Good communication and documentation skills 

Preferred Qualifications

• Mandatory Skills:

  1. MS Excel

  • Advanced Excel (Pivot Tables, Power Query, Power Pivot)

  • VLOOKUP / XLOOKUP / INDEX-MATCH

  • IF, COUNTIFS, SUMIFS formulas

  • Dashboard creation and report automation

  • Excel Macros / VBA (Preferred)

  2. SQL

  • Writing complex SQL queries

  • Joins, Subqueries, CTEs

  • GROUP BY, HAVING clauses

  • Data extraction and optimization

  3. Power BI

  • Data modeling and relationships

  • DAX measures and calculated columns

  • Interactive dashboards and reports

  • Scheduled refresh and publishing reports

  4. Email & Report Automation (Very Important):

  • Automating daily/weekly/monthly reports using Outlook

  • Sending automated emails with Excel / PDF / Power BI report attachments

  • Trigger-based emails (s based on data conditions)

  Automation Tools – Required:

  • Outlook Automation using VBA

  • Excel + Outlook integration

  • Power Automate (Microsoft Flow)

  • Python for automation (Pandas, OpenPyXL, SMTP, Schedule)

  • SQL scheduled jobs

  • Windows Task Scheduler / Cron Jobs

  (Google Apps Script is a plus)