Power BI Developer

Analytical Thinking & Business Insight Convert business problems into analytical logic and data models Validate metrics against source systems before release Identify trends, anomalies, leakage, and operational risks Support decision-making with accurate, explainable insights Create documentation for KPIs, calculations, and data flows Power BI Development Build high-quality Power BI dashboards and reports with a strong focus on usability and clarity Write advanced DAX measures in a highly optimized manner to achieve business requirements Design calculations for complex scenarios such as rolling metrics, comparisons, conditional logic, and cumulative values Optimize DAX to reduce query execution time and improve report responsiveness Manage relationships, filters, and calculation logic to avoid ambiguity or incorrect results Implement Row-Level Security (RLS) based on business rules Configure dataset refresh, manage gateways, and troubleshoot refresh failures in Power BI Service Advanced SQL Development Write highly optimized, production-grade SQL queries Use complex joins, CTEs, sub queries, and window functions effectively Create SQL logic for: Incremental data loads Deduplication and data cleansing Historical tracking and change detection Aggregations and pre-calculations Analyze query execution plans and optimize performance Design and maintain: SQL views Materialized views Reporting tables Handle large datasets (millions to billions of rows) efficiently Perform root-cause analysis for data mismatches and incorrect metrics Data Architecture & Warehousing Concepts Design analytical data structures suitable for reporting and performance Decide what logic should live in SQL vs Power BI (DAX) based on scalability and maintainability Define fact and dimension-type tables based on business processes Design aggregation layers and summary tables where required Ensure consistent metric definitions across reports and datasets Review existing data structures and recommend architectural improvements Work closely with engineering teams on data ingestion and transformation logic Requirements Must have at least 4 years of strong experience in Power BI. Take full ownership of analytics solutions Design data structures, not just consume them Write clean, efficient, and scalable SQL Decide the right balance between SQL, Power BI, and upstream transformations Deliver insights that directly impact business outcomes Ensure accuracy, performance, and consistency across all reports Act as a go-to person for analytics architecture and data logic Benefits Working hours: 10:00 AM – 7:00 PM Working days: 5 days a week (plus 1st & 3rd Saturdays working) Medical Insurance coverage for employees Provident Fund (PF) facility Quarterly parties and yearly outings/trips for team bonding Regular check-ins with leadership for growth and feedback