Power BI Lead / Architect

Brief DescriptionRole : Power BI Lead / Architect Skills – MandatoryMicrosoft Power BI, DAX, Power Query, SQL, RDBMS Total Experience : 7+ years Work Location : Cochin/TVM/Remote Job Purpose (both Onsite / Offshore) : Utilize skills in data analysis and visualization to translate raw data into actionable insights. The candidate needs to design and create interactive dashboards and reports using Tableau, aiding informed decisionmaking for organizations. Their role contributes to optimizing data-driven strategies and facilitating effective communication of key metrics. Job Description / Duties and Responsibilities : ▪ Responsible for designing, developing, and maintaining BI solutions to transform raw data into actionable insights.▪ Collaborate with data engineers, stakeholders, and IT teams to create interactive dashboards, reports, and visualizations that facilitate data-driven decision-making. ▪ Involves data modeling, ETL processes, and ensuring data accuracy while staying updated with advancements to optimize analytics capabilities.▪ Lead the design, development & deployment of Power BI solutions, including complex data models and interactive reports to deliver actionable business insights.▪ Utilize Power Query (M language) extensively to perform data transformation, cleansing, and shaping for integration into BI reports.▪ Write optimized DAX measures and calculated columns to ensure efficient query performance and interactive user experience.▪ Build and optimize SQL queries on Azure SQL databases, create and maintain database objects such as tables, views, and stored procedures to support BI data retrieval.▪ Implement and monitor performance tuning techniques in Power BI, Azure SQL Server, and underlying data warehouses to improve report load times and query speed.▪ Engage directly with clients to gather requirements, understand business objectives, and translate them into scalable technical BI solutions.▪ Take complete ownership of BI delivery, ensuring end-to-end management from requirement gathering through to deployment, user training, and post-implementation support.▪ Mentor and guide BI developers on best practices in Power BI development, SQL optimization, and data visualization standards.▪ Manage Power BI service deployment, including workspace administration, dataset refresh scheduling, gateway configuration, and troubleshooting complex issues related to data, performance, and integration.▪ Demonstrate flexibility to work in overlapping hours with customer time zones for seamless coordination, meetings, and real-time issue resolution.▪ Good to have knowledge in Adobe Analytics, but not mandatory.▪ To adhere to the Information Security Management policies and procedures.Preferred SkillsSkills – MandatoryMicrosoft Power BI, DAX, Power Query, SQL, RDBMS