Associate Principal Engineer - BI

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

Job summary

Wesco is seeking a senior Power BI lead to drive requirement gathering, architecture and development of enterprise BI solutions. You will mentor a team of BI developers, analysts and data engineers while collaborating with business stakeholders to deliver analytics that boost efficiency.

You will own QA across data and automation, implement RLS and data governance, and ensure timely delivery through Agile ceremonies and stakeholder reviews.

Qualifications

• Lead QA across data, functional and automation testing for BI projects.
• Experience in Agile/Scrum, Waterfall and Iterative project management.
• Mentor QA team to ensure adherence to quality standards.

Responsibilities

• Lead design and development of enterprise Power BI solutions.
• Review and approve dashboards and data models.
• Define use cases via BRD and obtain sign-off from BAs.
• Create test scripts and automation using BI Validator and Zephyr.
• Validate data across Azure Databricks, Oracle and Power BI with SQL.
• Develop interactive dashboards, reports, scorecards and KPIs.
• Implement Row-Level Security and data governance.
• Mentor and manage a team of Power BI developers, analysts and data engineers.

Skills

Power BI

SQL

DAX

Data modeling

Data warehousing

ETL/ELT

Performance tuning

Security (RLS)

Azure

QA leadership

Tools

Zephyr

Jira

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