Associate Principal Engineer - BI India Office

Wesco; Bengaluru; On-site; INR 900,000 - 1,400,000; Full time

Job summary

Wesco in Bengaluru is seeking aSenior BI Lead to drive the design, development and governance of enterprise Power BI solutions. You will mentor a team of Power BI developers, analysts and data engineers, translating business requirements into scalable dashboards, data models and KPI tracking.

Collaborating with stakeholders, you will provide formal estimates, lead QA processes, implement RLS and ensure data quality across Azure Databricks, Oracle and Power BI reports, while guiding agile

Qualifications

• Extensive experience with Power BI Desktop and Service.
• Strong SQL development and data modeling knowledge.
• Experience leading QA and data testing processes.
• Proficient in DAX and Power Query (M).

Responsibilities

• Lead the design and development of enterprise Power BI solutions.
• Mentor the team of Power BI developers, analysts and data engineers.
• Translate business requirements into analytical solutions and dashboards.
• Review and approve dashboards, data models and data governance standards.
• Validate data across sources and Power BI reports using SQL.
• Implement Row-Level Security (RLS) and data governance.
• Participate in Agile ceremonies and stakeholder meetings.

Skills

Power BI

DAX

SQL

Data modeling

Data warehousing

QA leadership

Agile/Scrum

Tools

Power BI Desktop

Power BI Service

Azure Databricks

Azure Data Factory

Synapse Analytics

Databricks

Zephyr

Jira

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.
• 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

#LI-KS1

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 benefitsand active community engagement, we create an environment where every team member has the opportunity to thrive. Learn more about Working at Wesco hereandFounded 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.