Senior Data Analyst
Straive
5 - 10 years
Bengaluru
Posted: 05/02/2026
Getting a referral is 5x more effective than applying directly
Job Description
As a Senior Data Analyst, you will be the bridge between raw data and strategic execution. We are looking for a technical powerhouse who lives and breathes SQL . You won't just be running queries; you will be designing complex data models, optimizing performance for massive datasets, and mentoring junior analysts. Your insights will directly influence our product roadmap and business strategy.
Key Responsibilities
- Advanced SQL Development: Write, troubleshoot, and optimize complex SQL queries involving multi-table joins, subqueries, and window functions to extract insights from relational databases.
- Data Modeling & Architecture: Design and maintain robust data models and schemas that ensure data integrity and high performance for BI tools.
- Stakeholder Partnership: Act as a strategic partner to Product, Marketing, and Finance teams, translating ambiguous business questions into structured analytical projects.
- Dashboarding & Visualization: Build and automate high-impact dashboards (Tableau, Power BI, or Looker) that track KPIs and provide real-time visibility into business health.
- Performance Tuning: Monitor and optimize query performance, identifying bottlenecks and implementing indexing or partitioning strategies to handle scale.
- Mentorship: Lead code reviews for SQL and data logic, providing guidance to junior analysts to ensure high standards of data accuracy and efficiency.
- ETL Collaboration: Partner with Data Engineers to streamline data pipelines and ensure the "source of truth" is reliable and well-documented.
Required Qualifications
- Experience: 5+ years of professional experience in data analytics, business intelligence, or a related quantitative field.
- SQL Mastery: Expert-level SQL skills are mandatory (PostgreSQL, Snowflake, BigQuery, or SQL Server). You should be comfortable with CTEs, window functions, and complex query optimization.
- BI Tools: Extensive experience building scalable reporting solutions in tools like Tableau, Power BI, Looker, or Sigma .
- Statistical Foundation: Strong understanding of statistical concepts (A/B testing, regression, correlation vs. causation).
- Analytical Rigor: Ability to clean and validate "messy" data, ensuring that insights are based on high-quality, verified sources.
- Communication: Proven ability to present complex technical findings to non-technical executives in a clear, actionable story.
Preferred Skills (The "Plus" List)
- Experience with Python or R for advanced statistical modeling or automation.
- Familiarity with modern data stack tools like dbt (data build tool) .
- Knowledge of cloud data warehouses (e.g., Snowflake, AWS Redshift, Google BigQuery).
- Background in a specific industry (e.g., SaaS, FinTech, or E-commerce).
Services you might be interested in
Improve Your Resume Today
Boost your chances with professional resume services!
Get expert-reviewed, ATS-optimized resumes tailored for your experience level. Start your journey now.
