Associate Principal Engineer - BI (India Office)

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