Senior Data Analytics Consultant

Job Location (Short): Hyderabad, India Workplace Type: Hybrid Req Id: 3016 Responsibilities We're looking for an Analytics Engineer who sits at the intersection of data engineering and business intelligence someone who treats SQL like a craft and views pipelines as software. You'll own the transformation layer of our modern data stack, turning raw Snowflake data into clean, tested, and performant models that directly power ThoughtSpot and Power BI for hundreds of internal users. This isn't a pure BI role or a pure engineering role. It's for someone who cares as much about model correctness and query efficiency as they do about whether a business analyst can actually understand the dataset they're working with. Core responsibilities Data modeling in Snowflake. Design and implement scalable Star and Snowflake schemas optimized for cloud warehouse performance and downstream BI consumption. Pipeline orchestration. Build and maintain modular, version-controlled transformation pipelines using Python and SQL-based frameworks. Own reliability and SLA. BI enablement. Architect datasets purpose-built for ThoughtSpot (search-driven analytics) and Power BI, ensuring low-latency queries and intuitive structures for non-technical users. Data quality & governance. Implement automated testing (schema, freshness, referential integrity) and metadata documentation so stakeholders can trust what they see. Performance optimization. Proactively monitor and tune SQL queries, Snowflake warehouse sizing, clustering keys, and materialized views balancing cost and speed. CI/CD & engineering standards. Apply software engineering best practices version control, code review, automated deployment to the analytics development lifecycle. Education / Qualifications Technical requirements Advanced SQL. Mastery of window functions, complex joins, CTEs, and query plan analysis. Comfortable debugging slow Snowflake queries without hand-holding. Snowflake architecture. Working knowledge of Time Travel, Zero-copy Cloning, Tasks, Streams, and warehouse cost management. Python. Strong enough to write production-grade scripts for data manipulation, API ingestion, and ETL automation not just notebook-level Python. BI modeling. Experience preparing data for ThoughtSpot Worksheets/Answers or Power BI (data model + DAX). Both is a strong plus. Modern data stack. Hands-on experience with dbt or Dagster for managing transformations as code. Familiarity with data contract or data mesh patterns is a bonus. About Octave Octave provides mission-critical software that empowers organizations to make informed decisions across every stage of the asset lifecycle - Design, Build, Operate and Protect - where performance, safety, and reliability are non-negotiable and failure is not an option. Turning complex operational data into actionable intelligence, Octave connects expertise, real-world conditions and enterprise-scale insight to improve performance, resilience and incident response where it matters most. Octave has more than 7,000 employees in 45 countries. Learn more at octave.com and follow us on LinkedIn. Why work for Octave All in. Always forward. That's the way we do things around here. We put trust in our people because we believe it's the best way to unleash potential, bring ideas to life, and keep moving ahead. And it's why we're committed to creating an environment that's truly supportive, providing you with the resources you need to support your ambitions, no matter who you are or where you are in the world. Everyone is welcome At Octave, we believe that diverse and inclusive teams are critical to the success of our people and our business. Here, everyone is welcome. As an inclusive workplace, we don't discriminate. In fact, we embrace differences and are fully committed to creating equal opportunities, an inclusive environment, and fairness for all. Respect is the cornerstone of how we operate, so speak up and be yourself. You're valued here. Recruitment Fraud Alert Octave posts all official job opportunities on either https://careers.octave.com/ or https://www.octave.com/about/careers and communicates only from email addresses ending in @octave.com. We never request payment or personal banking information during recruitment. No offers will ever be extended without a proper interview via Teams or in person, never done over email alone. If you suspect fraud, it probably is, and contact us at careers@octave.com Job Location (Short): Hyderabad, India Workplace Type: Hybrid Req Id: 3016 Responsibilities We're looking for an Analytics Engineer who sits at the intersection of data engineering and business intelligence someone who treats SQL like a craft and views pipelines as software. You'll own the transformation layer of our modern data stack, turning raw Snowflake data into clean, tested, and performant models that directly power ThoughtSpot and Power BI for hundreds of internal users. This isn't