Senior Software Engineer

Date: 16 Jun 2026

Location: IN

Company: Mastek Limited

We are seeking an experienced Senior Power BI Developer with deep expertise in enterprise-grade BI architecture, data engineering, security frameworks (RLS/OLS), and CI/CD automation. This role requires a strong combination of hands-on development skills and design thinking, with the ability to lead BI initiatives, enforce governance standards.

You will play a key role in designing scalable semantic models, optimizing performance, defining security architectures, and implementing automated deployment pipelines across environments. Collaboration with business stakeholders, data engineering teams, and security/compliance groups is fundamental to success in this role.

 

Key Responsibilities

1. BI Architecture & Model Design

  • Design and own enterprise semantic models using star schema and data modeling best practices.

  • Lead architecture discussions for scalable datasets, dataflows, and Fabric-based lakehouse/warehouse models.

  • Review and optimize existing models for performance, size, and governance.

  • Oversee conformed dimensions, cross‑fact modeling, and shared dataset strategies.

2. Advanced Power BI Development

  • Develop complex DAX measures, calculation groups, and reusable measure frameworks.

  • Create polished, highly interactive executive dashboards and analytics apps.

  • Implement versioned development using Power BI Desktop + Git integration.

3. Enterprise Security: RLS/OLS

  • Architect secure, dynamic Row-Level Security (Static/Dynamic) solutions for large user bases.

  • Implement and audit Object-Level Security to protect sensitive columns/measures.

  • Work with identity teams (AAD/Entra) to align security with enterprise roles and policies.

  • Ensure secure propagation across multi-fact, multi-dimension models.

5. CI/CD & Deployment Automation

  • Design and maintain end-to-end deployment pipelines for Dev → Test → Prod.

  • Implement CI/CD, Git integration, version control, and automated validation.

  • Manage release cycles, rollback plans, and deployment consistency across environments.

  • Partner with DevOps teams to integrate BI assets into enterprise DevOps workflows.

6. Governance, Optimization & Best Practices

  • Define standards for modeling, naming conventions, security, and workspace management.

  • Conduct code reviews, audits, and performance tuning for DAX, Power Query, and models.

  • Drive data quality, documentation, and lifecycle management across BI products.

7. Leadership & Collaboration

  • Mentor junior developers, providing technical guidance and code reviews.

  • Work closely with business stakeholders to translate ambiguous requirements into robust BI solutions.

 

Required Skills & Experience

Technical Expertise

  • 7+ years in Power BI development, modeling, and enterprise-level BI delivery.

  • 3+ years of working experience implementing Data Lake or Data Warehousing projects using ETL/ELT tools in either of Microsoft Fabric, Snowflake or Databricks.

  • Strong proficiency in:

    • DAX (expert level)

    • Power Query (M)

    • T-SQL (advanced)

  • Deep understanding of RLS (dynamic/static) and OLS.

  • Hands-on experience building complex semantic models in Fabric.

  • CI/CD implementation using:

    • Power BI Deployment Pipelines

    • Git Integration

    • Azure DevOps / GitHub Actions (optional)

  • Strong understanding of Entra ID (AAD) and Power BI security architecture.

Soft Skills

  • Strong leadership, stakeholder management, and communication.

  • Ability to break down complex requirements and design scalable solutions.

  • Comfortable driving technical discussions and presenting architecture decisions.

  • Strong documentation and analytical skills.

 

Preferred Qualifications (Nice to Have)

  • Microsoft certifications:

    • DP-600: Fabric Analytics Engineer Associate

    • PL-300: Power BI Data Analyst

    • PL-400 / PL-200

  • Experience with:

    • Python or PySpark for advanced transformations

    • Data governance & regulatory compliance (GDPR, SOC2, etc.)