Data Scientist

Definitive Healthcare, US; Bengaluru; On-site; INR 1,500,000 - 3,000,000; Full time

Job summary

Analytical Wizards, part of the Definitive Healthcare family, seeks a Data Scientist with BI expertise to design, develop, and optimize scalable reporting using Power BI and cloud data platforms.

You will lead end-to-end BI projects, model data with star/snowflake schemas, and implement governance and performance optimizations for large datasets.

Qualifications

• Experience designing scalable Power BI reporting solutions.

Responsibilities

• End-to-end development of Power BI solutions including ingestion, storage and presentation layers.
• Advanced data modeling with star and snowflake schemas.
• Develop complex DAX measures and KPIs for large datasets.
• ETL and data transformation using Power Query (M).
• Implement Row-Level Security and data governance practices.
• Tune performance of reports and SQL queries for enterprise use.

Skills

Power BI

DAX

SQL

Python

Data modeling

Performance tuning

DAX Studio

Tabular Editor

Data governance

Tools

Power BI Desktop

Power BI Service

Power BI Gateway

Power BI Report Builder

Power Automate

Tableau

Snowflake

AWS SageMaker

Athena

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 dataanalytics to design, develop, and optimize scalable reporting solutions using Power BI and cloud dataplatforms.

Core Responsibilities

• End-to-end development: Handling end-to-end design and deployment of advanced PowerBI solutions, including data ingestion, storage and presentation layers.
• Advanced Data Modeling: Designing robust semantic models using star and snowflakeschemas 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 toensure 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 withPower AutomateTableau desktop, cloud, server, data connectivity and prep layers.
• Advanced SQL: Expert-level skills in writing, optimizing and troubleshooting complex SQLqueries (CTEs, analytical functions, stored procedures)
• Cloud Data Platforms: Hands-on experience with cloud environments like Snowflake andAWS (S3, AWS Sage maker, Athena)
• Scripting: Proficiency in Python for advanced data processing, automation and customvisuals.
• Performance Tuning: Experience with tuning tools such as DAX Studio or Tabular Editor is preferred