Associate Principal Engineer - BI (India Office)

Wesco; Bengaluru; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

Wesco seeks an experienced Power BI leader in Bengaluru to drive enterprise BI solutions and mentor a team of developers, analysts, and data engineers. You will translate business requirements into analytics, design data models, and govern data access with RLS.

The role emphasizes collaboration with stakeholders, designing dashboards, and ensuring QA through testing and automation tools within an Agile framework.

Qualifications

• Strong expertise in Power BI Desktop/Service and DAX development.
• Experience mentoring a BI/QA/data engineering team in an agile setup.
• Knowledge of SQL, data modeling, and data governance.
• Experience with testing frameworks and Zephyr/Jira tooling.

Responsibilities

• Lead design and development of enterprise Power BI solutions.
• Mentor and manage a team of BI developers, analysts, and data engineers.
• Collaborate with stakeholders to translate requirements into analytics.
• Define use cases, create BRD, and set up review sessions.
• Implement RLS and ensure data governance standards.

Skills

Power BI

Mentor team

Agile/Scrum

DAX

SQL

Tools

Zephyr

BI Validator

Jira

Power BI Service

Job description

Job Description

Perform requirement gathering, interact with business users, analyze requirements & provide solutions to optimize the business processes and increase efficiency. Mentor and manage a team of Power BI developers, analysts, and data engineers. Collaborate with business stakeholders to gather requirements and translate them into analytical solutions.

• Provide formal estimates to satisfy requirements and produce planning & strategy documents and Requirement Traceability Matrix.
• Participate in daily standup, sprint planning, grooming, review, retrospectives and periodical business meetings with all the stake holders in Agile environment.
• Lead the design and development of enterprise Power BI solutions.
• Review and approve technical designs, dashboards, and data models.
• Led the Quality Assurance team and manage all aspects of data, functional and automation testing, ensuring seamless coordination and accountable for the delivery of all QA components.
• Define use cases using BRD documents, set up review sessions and get the sign off from the Business Analysts for PowerBI reports.
• Design test scripts from the use cases and develop automaton scripts using BI Validator tool and maintain them in Zephyr a Jira tool.
• Develop interactive dashboards, reports, scorecards, and KPI tracking solutions.
• Design and optimize semantic models and datasets.
• Create complex DAX measures and calculations.
• Develop reusable reporting frameworks and self-service analytics solutions.
• Implement Row-Level Security (RLS) and data governance standards.

Job Description

Perform requirement gathering, interact with business users, analyze requirements & provide solutions to optimize the business processes and increase efficiency. Mentor and manage a team of Power BI developers, analysts, and data engineers. Collaborate with business stakeholders to gather requirements and translate them into analytical solutions.

• Provide formal estimates to satisfy requirements and produce planning & strategy documents and Requirement Traceability Matrix.
• Participate in daily standup, sprint planning, grooming, review, retrospectives and periodical business meetings with all the stake holders in Agile environment.
• Lead the design and development of enterprise Power BI solutions.
• Review and approve technical designs, dashboards, and data models.
• Led the Quality Assurance team and manage all aspects of data, functional and automation testing, ensuring seamless coordination and accountable for the delivery of all QA components.
• Define use cases using BRD documents, set up review sessions and get the sign off from the Business Analysts for PowerBI reports.
• Design test scripts from the use cases and develop automaton scripts using BI Validator tool and maintain them in Zephyr a Jira tool.
• Validate data between Azure Databricks, Oracle against PowerBI reports using SQL queries.
• Develop interactive dashboards, reports, scorecards, and KPI tracking solutions.
• Design and optimize semantic models and datasets.
• Create complex DAX measures and calculations.
• Develop reusable reporting frameworks and self-service analytics solutions.
• Implement Row-Level Security (RLS) and data governance standards.

QA Skills Required

• Develop scripts for manual test scenarios for smoke, functional, regression, integration, end to end, UAT and maintain it in Zephyr tool.
• Mentor the team and monitor the quality of work produced by the QA team to ensure the quality standards are met consistently.
• Execute product design features to support scalability, usability and better performance.
• Extensive experience and Strong knowledge in various Project, Release & Change Management processes including Agile/Scrum, Waterfall and Iterative.

Technical Skills

• Expert knowledge of Power BI Desktop and Power BI Service.
• Advanced DAX and Power Query (M).
• Strong SQL development and database optimization.
• Data modeling and data warehousing concepts.
• Azure Data Factory, Synapse Analytics, Databricks & Reporting suite expertise.
• ETL/ELT design and implementation.
• Performance tuning and optimization.
• Power BI Gateway configuration and administration.
• Security implementation including RLS/Object-Level Security

About The Team

At Wesco, we build, connect, power and protect the world. As a leading provider of business-to-business distribution, logistics services and supply chain solutions, we create a world that you can depend on.

Our Company’s greatest asset is our people. Wesco is committed to fostering a workplace where every individual is respected, valued, and empowered to succeed. We promote a culture that is grounded in teamwork and respect. With a workforce of over 20,000 people worldwide, we embrace the unique perspectives each person brings. Through comprehensive benefits and active community engagement, we create an environment where every team member has the opportunity to thrive.

Founded in 1922 and headquartered in Pittsburgh, Wesco is a publicly traded (NYSE: WCC) FORTUNE 500® company.

Wesco International, Inc., including its subsidiaries and affiliates (“Wesco”) provides equal employment opportunities to all employees and applicants for employment. Employment decisions are made without regard to race, religion, color, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, or other characteristics protected by law. US applicants only, we are an Equal Opportunity Employer.

Los Angeles Unincorporated County Candidates Only: Qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act.

This posting is for a current, active vacancy intended for immediate hire.