TopGrep Tech·Data & AI
Category
Data & AI
Work mode
Onsite
Type
Full Time
Experience
3 To 5 Yrs
Salary
Design, develop, and maintain high-performance Power BI dashboards and reports. Build robust, scalable data models using advanced DAX (Data Analysis Expressions) to implement complex business logic, time-intelligence calculations Optimize existing reports and data models for speed, efficiency, and scalability.
Write, optimize, and debug complex SQL queries (including subqueries, CTEs, window functions, and advanced joins) to extract data from various enterprise data warehouses. Ensure data integrity and consistency between source systems and front-end reports.
Power BI & DAX: Minimum of 1–3 years of hands-on experience building Power BI solutions. Deep understanding of evaluation contexts (Filter Context vs. Row Context) and complex DAX functions (CALCULATE, FILTER, ALL, EARLIER, and time-intelligence). Expert SQL Skills: High proficiency in writing complex, optimized SQL queries. Must be comfortable handling large datasets, writing Common Table Expressions (CTEs), utilizing window functions (RANK, LEAD/LAG, PARTITION BY), and analyzing query performance.
Data Modeling: Strong understanding of relational database concepts, star/snowflake schemas, and data normalization/denormalization. Familiarity with cloud data platforms like Snowflake, Azure Synapse, or AWS Redshift. Basic knowledge of Python for data manipulation.
₹4 to ₹5
Location
India
Problem-Solving: A natural curiosity to dig into data anomalies and find the root cause of discrepancies. Communication: Ability to explain complex technical data constraints to non-technical business users clearly. Attention to Detail: Precision in data validation to ensure business decisions are made on 100% accurate reporting.