Power BI Developer

ScaleupAlly

Not Interested
Bookmark
Report This Job

profile Job Location:

Noida - India

profile Salary: Not Disclosed
profile Experience Required: 3-6years
Posted on: 18 hours ago
Vacancies: 1 Vacancy

Job Summary

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




Required Skills:

Python l Microsoft Fabric l ETL l Power BI l Azure l SQL l Leadership


Required Education:

Bachelors degree in Computer ScienceInformation Systems or a related 4 years of demonstrable experience in Power BI

Analytical Thinking & Business InsightConvert business problems into analytical logic and data modelsValidate metrics against source systems before releaseIdentify trends anomalies leakage and operational risksSupport decision-making with accurate explainable insightsCreate documentation for KPIs ca...
View more view more

Company Industry

IT Services and IT Consulting

Key Skills

  • Business Intelligence
  • Cognos
  • SQL
  • Power BI
  • QlikView
  • Microsoft SQL Server
  • ssrs
  • Tableau
  • SSIS
  • T Sql
  • Data Modeling
  • Data Warehouse