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.

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

• 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