Senior Technical Lead - Business Intelligence

Birlasoft Limited; Pune District; On-site; INR 1,500,000 - 2,400,000; Full time

Job summary

Birlasoft Limited is seeking a Senior Technical Lead-BI to design and deliver enterprise BI solutions with a strong focus on Power BI dashboards and DAX calculations. The role is centered on the Microsoft BI stack (SSRS, SSIS, SSAS) to transform complex business requirements into actionable dashboards and insights, with exposure to Fabric Data Analyst capabilities.

The candidate will collaborate with Data Engineers, Architects, and business stakeholders to ensure data accuracy, governance, and

Qualifications

• 6-12 years of experience in BI and Data Visualization.
• Strong hands-on expertise in Power BI.
• Advanced knowledge of DAX, data modeling, and performance optimization.
• Experience with MSBI technologies: SSRS, SSIS, SSAS.
• Strong SQL and database development skills.
• Understanding of data warehousing concepts and dimensional modeling.
• Experience with report scheduling, subscriptions, and security models.
• Excellent analytical, troubleshooting, and communication skills.

Responsibilities

• Design and develop interactive Power BI dashboards and reports.
• Build complex DAX calculations, KPIs, measures, and data models.
• Develop and maintain SSRS reports for operational and management reporting.
• Create and manage ETL processes using SSIS.
• Design and optimize SSAS Tabular/Multidimensional models.
• Gather business requirements and translate them into visualization solutions.
• Ensure data accuracy, performance tuning, and report optimization.
• Implement reporting governance, security, and best practices.
• Collaborate with Data Engineers, Architects, and business stakeholders.
• Support UAT, production deployment, and ongoing enhancements.

Skills

Power BI

DAX

MSBI

SQL

Data Modeling

Performance Optimization

Analytics

Communication

Tools

SSRS

SSIS

SSAS

Fabric Data Analyst

Job description

Sr Technical Lead-BI Area(s) of responsibility Job Description - Data Visualization Engineer Experience: 6-12 Years | Primary Skills: Power BI, DAX, MSBI Role Overview We are seeking an experienced Data Visualization Engineer with strong expertise in Power BI, DAX, and the Microsoft BI stack (SSRS, SSIS, SSAS). The candidate will design, develop, and optimize enterprise reporting and analytics solutions, transforming complex business requirements into impactful dashboards and insights. Exposure to Microsoft Fabric Data Analyst capabilities is preferred.

Key Responsibilities

• Design and develop interactive Power BI dashboards and reports.
• Build complex DAX calculations, KPIs, measures, and data models.
• Develop and maintain SSRS reports for operational and management reporting.
• Create and manage ETL processes using SSIS.
• Design and optimize SSAS Tabular/Multidimensional models.
• Gather business requirements and translate them into visualization solutions.
• Ensure data accuracy, performance tuning, and report optimization.
• Implement reporting governance, security, and best practices.
• Collaborate with Data Engineers, Architects, and business stakeholders.
• Support UAT, production deployment, and ongoing enhancements.

Required Skills

• 6-12 years of experience in Business Intelligence and Data Visualization.
• Strong hands-on expertise in Power BI.
• Advanced knowledge of DAX, data modeling, and performance optimization.
• Experience with MSBI technologies: SSRS, SSIS, and SSAS.
• Strong SQL and database development skills.
• Understanding of data warehousing concepts and dimensional modeling.
• Experience with report scheduling, subscriptions, and security models.
• Excellent analytical, troubleshooting, and communication skills.

Good to Have

• Microsoft Fabric Data Analyst experience.
• Fabric Lakehouse, Semantic Models, Dataflows, and Real-Time Analytics exposure.
• Azure Data Services knowledge.
• Experience working in Agile/Scrum environments.
• Relevant Microsoft certifications.

Experience Level Senior Level