Analyst - Business Intelligence

WSP India is seeking a motivated Business Intelligence Analyst with 4–6 years of experience to design, develop, and maintain BI dashboards and reports.

The ideal candidate will have strong analytical skills and hands-on expertise in Power BI, Excel, and AI-driven BI solutions.

Responsibilities

• Build, optimize, and maintain interactive Power BI dashboards and reports.
• Apply AI/ML features within BI dashboards for predictive insights and automation.
• Use advanced Excel functions for data analysis, validation, and reporting.
• Connect BI tools to SQL Server and other databases for seamless data integration.
• Ensure accuracy and consistency of data across multiple sources.
• Interpret complex datasets to provide actionable business insights.
• Manage BI workspace permissions, documentation, and governance.
• Basic understanding of billing, invoicing, timesheets, and expenses and how they feed into project cost reporting (good to have).
• Basic awareness of project budgets, monthly accruals, and planned vs. actual cost tracking to support performance dashboards (good to have).
• Ability to check project and billing data for accuracy and coordinate with finance and project teams; familiarity with ERP systems is a plus (good to have).

Required Skills

• 4–6 years of experience in Business Intelligence or related roles.
• Proficiency in Power BI (DAX, Power Query).
• Experience with AI features in BI dashboards.
• Advanced Excel skills (pivot tables, formulas, macros preferred).
• Hands-on with SQL Server database connections and query optimization.
• Solid analytical and problem-solving skills.
• Good administrative and organizational abilities.
• Experience managing Power BI workspaces with good knowledge of Microsoft Fabric capacity.
• Basic understanding of project cost control such as billing, timesheets, expenses, and budget vs. actual tracking (good to have).

Qualifications

• Bachelor’s degree in computer science, Information Technology, Engineering, or a related technical field (preferred).
• Candidates with a strong academic foundation in data structures, databases, and programming concepts will be given preference.
• 4–6 years of relevant experience in Business Intelligence, Data Analytics, or related roles.
• Solid understanding of data modeling, database systems, and data architecture principles.
• Exposure to AI concepts or data-driven solutions within BI environments is an added advantage.
• Strong analytical mindset with the ability to translate business requirements into technical solutions.
• Effective communication skills to collaborate with cross-functional and technical teams.