Senior Data Scientist

Definitive Healthcare; Bengaluru; On-site; INR 1,200,000 - 2,100,000; Full time

Job summary

Analytical Wizards, part of the Definitive Healthcare family, seeks a data scientist with strong BI and analytics skills to design, develop and optimize scalable reporting solutions using Power BI and cloud data platforms. You will handle end-to-end BI projects, build semantic models, and ensure governance and performance at scale.

The role emphasizes expert Power BI capability, SQL proficiency, and experience with Snowflake/AWS, Python, and advanced DAX for KPI development.

Qualifications

• Expert Power BI across Desktop, Service, Gateway and report building.
• Advanced SQL with CTEs, analytics functions and stored procedures.
• Experience with Snowflake and AWS data services (S3, SageMaker, Athena).
• Proficient in Python for data processing and automation.

Responsibilities

• End-to-end development of Power BI solutions including ingestion, storage and presentation layers.
• Design robust semantic models using star and snowflake schemas.
• Develop and optimize DAX for measures and KPIs over large datasets.
• Perform ETL/data transformation using Power Query and reusable dataflows.
• Implement Row-Level Security and uphold data governance standards.
• Tune performance of reports and SQL queries for scalability.

Skills

Power BI

SQL

Snowflake

AWS

Python

DAX Studio

Tools

Power BI Desktop

Power BI Service

Power BI Gateway

Power BI Report Builder

Tableau Desktop

SQL

Job description

Analytical Wizards is part of the Definitive Healthcare family. We balance innovation with an open, friendly culture and the backing of a long-established parent company, known for its ethical reputation. We guide customers from what’s now to what’s next by unlocking the value of their data and applications to solve their challenges, achieving outcomes that benefit both business and society. Our people are our biggest asset, they drive our innovation advantage and we strive to offer a flexible and collaborative workplace where they can thrive. We offer industry-leading benefits packages to promote a creative and inclusive culture. If driving real change gives you a sense of pride and you are passionate about powering social good, we’d love to hear from you.

Role Overview

We are looking for a skilled Data Scientist with strong expertise in Business Intelligence and data analytics to design, develop, and optimize scalable reporting solutions using Power BI and cloud data platforms.

Core Responsibilities

• End-to-end development: Handling end-to-end design and deployment of advanced Power BI solutions, including data ingestion, storage and presentation layers.
• Advanced Data Modeling: Designing robust semantic models using star and snowflake schemas to ensure optimized relationships and aggregations.
• Complex DAX Development: Writing and optimizing complex Data Analysis Expression (DAX) for measures, calculated columns, and intricate KPIs to handle large datasets.
• ETL & Data Transformation: Developing sophisticated data transformation logic, for instance using Power Query (M language), and building reusables dataflows and pipelines.
• Governance and Security: Implement Row-Level Security and enforce data governance, documentation and quality standards.
• Performance Tuning: Troubleshooting and optimizing existing reports and SQL queries to ensure high performance and usability at scale.

Required Skills

• Expert Power BI - Proficiency with the entire stack.
• Power BI Desktop, Service, Gateway and Power BI Report Building. Experience with Power Automate Tableau desktop, cloud, server, data connectivity and prep layers.
• Advanced SQL: Expert-level skills in writing, optimizing and troubleshooting complex SQL queries (CTEs, analytical functions, stored procedures)
• Cloud Data Platforms: Hands-on experience with cloud environments like Snowflake and AWS (S3, AWS Sage maker, Athena)
• Scripting: Proficiency in Python for advanced data processing, automation and custom visuals.
• Performance Tuning: Experience with tuning tools such as DAX Studio or Tabular Editor is preferred