Power BI Developer

Analytical Thinking & Business Insight<\/u><\/span><\/span><\/b><\/span><\/span>
<\/h3>

• Convert business problems into analytical logic and data models<\/span><\/span><\/span><\/span>
  <\/p><\/li>

• Validate metrics against source systems before release<\/span><\/span><\/span><\/span>
  <\/p><\/li>

• Identify trends, anomalies, leakage, and operational risks<\/span><\/span><\/span><\/span>
  <\/p><\/li>

• Support decision\-making with accurate, explainable insights<\/span><\/span><\/span><\/span>
  <\/p><\/li>

• Create documentation for KPIs, calculations, and data flows<\/span><\/span><\/span><\/span>
  <\/p><\/li><\/ul>

  <\/span><\/span><\/b><\/span><\/span>Power BI Development<\/u><\/span><\/span><\/b><\/span><\/span>
  <\/p>

  
  <\/div>

  • Build high\-quality Power BI dashboards and reports with a strong focus on usability and clarity<\/span><\/span><\/span><\/span>
    <\/p><\/li>

  • Write <\/span><\/span><\/span><\/span>advanced DAX measures in a highly optimized manner<\/span><\/span><\/b><\/span><\/span> to achieve business requirements<\/span><\/span><\/span><\/span>
    <\/p><\/li>

  • Design calculations for complex scenarios such as rolling metrics, comparisons, conditional logic, and cumulative values<\/span><\/span><\/span><\/span>
    <\/p><\/li>

  • Optimize DAX to reduce query execution time and improve report responsiveness<\/span><\/span><\/span><\/span>
    <\/p><\/li>

  • Manage relationships, filters, and calculation logic to avoid ambiguity or incorrect results<\/span><\/span><\/span><\/span>
    <\/p><\/li>

  • Implement Row\-Level Security (RLS) based on business rules<\/span><\/span><\/span><\/span>
    <\/p><\/li>

  • Configure dataset refresh, manage gateways, and troubleshoot refresh failures in Power BI Service<\/span><\/span><\/span><\/span>
    <\/p><\/li><\/ul>

    
    <\/div>

    <\/span><\/span><\/span><\/span>Advanced SQL Development <\/u><\/span><\/span><\/b><\/span><\/span>
    <\/p>

    • Write <\/span><\/span><\/span><\/span>highly optimized, production\-grade SQL queries<\/span><\/span><\/b><\/span><\/span>
      <\/p><\/li>

    • Use complex joins, CTEs, sub queries, and window functions effectively<\/span><\/span><\/span><\/span>
      <\/p><\/li>

    • Create SQL logic for:<\/span><\/span><\/span><\/span>
      <\/span><\/span><\/span><\/span><\/p><\/li>

      • Incremental data loads<\/span><\/span><\/span><\/span>
        <\/p><\/li>

      • Deduplication and data cleansing<\/span><\/span><\/span><\/span>
        <\/p><\/li>

      • Historical tracking and change detection<\/span><\/span><\/span><\/span>
        <\/p><\/li>

      • Aggregations and pre\-calculations<\/span><\/span><\/span><\/span>
        <\/span><\/span><\/span><\/span><\/p><\/li><\/ul>

      • Analyze query execution plans and optimize performance<\/span><\/span><\/span><\/span>
        <\/p><\/li>

      • Design and maintain:<\/span><\/span><\/span><\/span>
        <\/span><\/span><\/span><\/span><\/p><\/li>

        • SQL views<\/span><\/span><\/span><\/span>
          <\/p><\/li>

        • Materialized views<\/span><\/span><\/span><\/span>
          <\/p><\/li>

        • Reporting tables<\/span><\/span><\/span><\/span>
          <\/span><\/span><\/span><\/span><\/p><\/li><\/ul>

        • Handle <\/span><\/span><\/span><\/span>large datasets (millions to billions of rows)<\/span><\/span><\/b><\/span><\/span> efficiently<\/span><\/span><\/span><\/span>
          <\/p><\/li>

        • Perform root\-cause analysis for data mismatches and incorrect metrics<\/span><\/span><\/span><\/span>
          <\/p><\/li><\/ul>

          Data Architecture & Warehousing Concepts<\/u><\/span><\/span><\/b><\/span><\/span>
          <\/u><\/h3>

          • Design analytical data structures suitable for reporting and performance<\/span><\/span><\/span><\/span>
            <\/p><\/li>

          • Decide what logic should live in <\/span><\/span><\/span><\/span>SQL vs Power BI (DAX)<\/span><\/span><\/b><\/span><\/span> based on scalability and maintainability<\/span><\/span><\/span><\/span>
            <\/p><\/li>

          • Define fact and dimension\-type tables based on business processes<\/span><\/span><\/span><\/span>
            <\/p><\/li>

          • Design aggregation layers and summary tables where required<\/span><\/span><\/span><\/span>
            <\/p><\/li>

          • Ensure consistent metric definitions across reports and datasets<\/span><\/span><\/span><\/span>
            <\/p><\/li>

          • Review existing data structures and recommend architectural improvements<\/span><\/span><\/span><\/span>
            <\/p><\/li>

          • Work closely with engineering teams on data ingestion and transformation logic<\/span><\/span><\/span><\/span>
            <\/p><\/li><\/ul>

            
            <\/div><\/span>
            

            Requirements<\/h3>

            • Must have at least 4 years of strong experience in Power BI.
              <\/p><\/li>

            • Take <\/span><\/span>full ownership<\/span><\/span><\/b> of analytics solutions<\/span><\/span><\/span><\/span>
              <\/p><\/li>

            • Design data structures, not just consume them<\/span><\/span><\/span><\/span>
              <\/p><\/li>

            • Write <\/span><\/span>clean, efficient, and scalable SQL<\/span><\/span><\/b><\/span><\/span>
              <\/p><\/li>

            • Decide the right balance between SQL, Power BI, and upstream transformations<\/span><\/span><\/span><\/span>
              <\/p><\/li>

            • Deliver insights that directly impact business outcomes<\/span><\/span><\/span><\/span>
              <\/p><\/li>

            • Ensure <\/span><\/span>accuracy, performance, and consistency<\/span><\/span><\/b> across all reports<\/span><\/span><\/span><\/span>
              <\/p><\/li>

            • Act as a <\/span><\/span>go\-to person<\/span><\/span><\/b> for analytics architecture and data logic<\/span><\/span><\/span><\/span>
              <\/p><\/li><\/ul>

              
              <\/div><\/span>
              

              Benefits<\/h3>

              • Working hours: <\/span><\/span>10:00 AM \u2013 7:00 PM<\/span><\/span><\/b><\/span><\/span>
                <\/p><\/li>

              • Working days: <\/span><\/span>5 days a week<\/span><\/span><\/b> (plus 1st & 3rd Saturdays working)<\/span><\/span><\/span><\/span>
                <\/p><\/li>

              • Medical Insurance<\/span><\/span><\/b> coverage for employees<\/span><\/span><\/span><\/span>
                <\/p><\/li>

              • Provident Fund (PF)<\/span><\/span><\/b> facility<\/span><\/span><\/span><\/span>
                <\/p><\/li>

              • Quarterly parties and yearly outings/trips<\/span><\/span><\/b> for team bonding<\/span><\/span><\/span><\/span>
                <\/p><\/li>

              • Regular check\-ins<\/span><\/span><\/b> with leadership for growth and feedback<\/span><\/span><\/span><\/span>
                <\/p><\/li><\/ul>

                
                <\/div><\/span>