Senior Insight Analyst

Advertising sales teams work with local businesses and national agencies.

Role overview

Lanternlane is hiring a Senior Insight Analyst to work remotely from India. The Finance team needs someone who can write SQL, build dashboards and explain what changed and why. Analyst role with a mix of recurring reporting and project work. Most of your day will be in SQL, Excel and Power BI or Tableau. Remote position. Most of the team is in Jaipur, but nobody is required to come in. Hours are flexible, with one short team call each morning. Most communication happens in Slack, with short video calls when needed.

Job duties

• Automate recurring Excel reports with Power Query, Python or scheduled SQL
• Analyse trends, cohorts and funnel drop-off and summarise findings in plain language
• Field ad hoc requests through a ticket queue and prioritise them with your manager
• Present results to managers and answer follow-up questions
• Investigate data quality issues and work with data engineering to fix them at the source
• Clean and reconcile data from CRM, ERP and spreadsheet sources

Qualifications

• Basic statistics: averages vs. medians, distributions, significance
• Bachelor's degree in statistics, economics, business, math or a related field
• Strong SQL (joins, CTEs, aggregations, window functions)
• Able to juggle several requests and say when a deadline isn't realistic
• Clear written and verbal communication with non-technical stakeholders

Preferred

• Dbt or Snowflake
• Salesforce or NetSuite reporting

What you get

• Health insurance for you and your family
• Provident fund
• Paid leave

Start: Within 30 days.

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