Lead Visualization Specialist - BI-Power BI

Bristlecone; Bengaluru; On-site; INR 3,800,000 - 6,000,000; Full time

Job summary

Bristlecone is seeking a Power BI Lead in Bengaluru to architect and deliver enterprise BI solutions. With 7–10 years of experience, you will guide data modeling, DAX development, SQL querying, and performance tuning while mentoring teammates and enforcing governance standards.

You will partner with business stakeholders to translate requirements into scalable BI designs, ensuring secure, efficient reporting and analytics across the organization.

Qualifications

• Experience leading BI design and implementation projects.
• Strong skills in data modeling, DAX, and SQL.
• Mentor teammates and promote BI best practices.

Responsibilities

• Architect and design scalable Power BI solutions.
• Develop robust data models optimized for performance.
• Define governance standards and development templates.
• Write and optimize DAX measures, calculations and KPIs.
• Write and optimize SQL queries across data sources.
• Collaborate with stakeholders to translate requirements.
• Provide technical guidance and mentorship to the team.
• Ensure data security and compliance in BI solutions.

Skills

Data modeling

Performance optimization

Advanced DAX development

SQL query writing

Leadership

Mentoring

Communication

Tools

Power BI

Power BI Desktop

Power BI Service

Microsoft BI technologies

SQL

Job description

We are seeking a highly skilled Power BI Lead with 7-10 years of experience, possessing deep expertise in data modeling, performance optimization, advanced DAX development, and SQL query writing. The ideal candidate will lead the design and implementation of scalable Business Intelligence solutions, mentor team members, and drive best practices in data visualization, analytics, and reporting.

Key Responsibilities

• Architecture & Solution Design
• Design and develop robust data models optimized for performance, scalability, and maintainability.
• Define and implement Power BI architecture standards, governance frameworks, and best practices.
• Ensure solution alignment with enterprise data and analytics strategy.
• Development & Performance Optimization
• Develop complex DAX measures, calculations, and KPIs to support advanced analytics requirements.
• Optimize Power BI reports, dashboards, datasets, and semantic models for enhanced performance.
• Write and optimize SQL queries for data extraction, transformation, validation, and troubleshooting.
• Analyze and resolve performance bottlenecks across reporting and data layers.
• Stakeholder Collaboration & Leadership
• Collaborate with business stakeholders to gather requirements and translate them into actionable BI solutions.
• Lead design discussions and provide technical guidance throughout the project lifecycle.
• Mentor and support team members on Power BI development, data modeling techniques, DAX best practices, and performance optimization strategies.
• Promote knowledge sharing and continuous learning within the team.
• Quality, Governance & Standards
• Ensure adherence to organizational standards related to data security, governance, and compliance.
• Establish reusable frameworks, templates, and development standards to improve consistency and efficiency.
• Conduct code reviews and ensure adherence to best practices across Power BI solutions.

Technical Expertise

• Strong proficiency in Power BI Desktop, Power BI Service, and related Microsoft BI technologies.
• Extensive experience in data modeling, including:
  • Star Schema
  • Snowflake Schema
  • Normalization and Denormalization Techniques
• Advanced expertise in DAX (Data Analysis Expressions) for complex calculations and business logic implementation.
• Proven experience in Power BI performance tuning and optimization.
• Strong SQL development skills with the ability to write and optimize complex queries across multiple data sources.

Data Integration & Data Management

• Hands-on experience working with:
  • Relational Databases
  • Azure Data Services
  • On-Premises Data Sources
  • APIs and External Data Sources
• Strong understanding of ETL processes, data integration patterns, and data warehousing concepts.
• Experience with enterprise-scale reporting and analytics environments.

Soft Skills

• Excellent analytical, problem-solving, and troubleshooting capabilities.
• Strong verbal and written communication skills.
• Ability to collaborate effectively with cross-functional teams and business stakeholders.
• Demonstrated leadership and mentoring capabilities.
• Ability to manage multiple priorities in a fast-paced environment.

Preferred Qualifications

• Experience with Azure data and analytics services.
• Familiarity with enterprise BI governance and deployment frameworks.
• Knowledge of data warehousing and modern analytics architectures.

Experience leading teams and delivering enterprise-scale Power BI implementations

About Us

Bristlecone is the leading provider of AI-powered application transformation services for the connected supply chain. We empower our customers with speed, visibility, automation, and resiliency to thrive on change.

Our transformative solutions in Digital Logistics, Cognitive Manufacturing, Autonomous Planning, Smart Procurement and Digitalization are positioned around key industry pillars and delivered through a comprehensive portfolio of services spanning digital strategy, design and build, and implementation across a range of technology platforms.

Bristlecone is ranked among the top ten leaders in supply chain services by Gartner. We are headquartered in San Jose, California, with locations across North America, Europe and Asia, and over 2,500 consultants. Bristlecone is part of the $19.4 billion Mahindra Group.

Equal Opportunity Employer

Bristlecone is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.

Information Security Responsibilities

• Understand and adhere to Information Security policies, guidelines and procedure, practice them for protection of organizational data and Information System.
• Take part in information security training and act while handling information.
• Report all suspected security and policy breach to InfoSec team or appropriate authority (CISO).
• Understand and adhere to the additional information security responsibilities as part of the assigned job role.