Data Analyst

Started in 1994 out of a spare bedroom, the agency now has a small office downtown.

We're looking for a Data Analyst to join our team. This is a remote role. You'll own a set of dashboards and the data behind them, and be the go-to person when someone asks why a number looks off. Remote within India. The team meets in Mumbai once a quarter, travel covered. Normal business hours, Monday to Friday, with some flexibility. You will write a lot of updates, so clear written English is important.

Responsibilities

• Define metric logic with stakeholders and document it
• Automate recurring Excel reports with Power Query, Python or scheduled SQL
• Clean and reconcile data from CRM, ERP and spreadsheet sources
• Present results to managers and answer follow-up questions
• Field ad hoc requests through a ticket queue and prioritise them with your manager
• Investigate data quality issues and work with data engineering to fix them at the source
• Prepare weekly and monthly KPI reports for department leads

Skills and experience

• 3+ years of experience in a data or reporting analyst role
• Experience with at least one BI tool such as Tableau, Power BI or Looker
• Bachelor's degree in statistics, economics, business, math or a related field
• Able to juggle several requests and say when a deadline isn't realistic
• Strong SQL (joins, CTEs, aggregations, window functions)
• Advanced Excel: pivot tables, XLOOKUP, Power Query

Benefits

₹9,00,000 - ₹11,00,000 per year

• Health insurance for you and your family
• Provident fund
• Paid leave
• Internet reimbursement
• Gratuity
• Learning budget
• Flexible hours

Start: Flexible.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at DKT Agency Pvt Ltd.