Senior Business Intelligence Analyst

ROLE OBJECTIVE :

The individual for this position will understand, develop and support reporting and analysis for the respective business unit. The duties and responsibilities will include transition of existing reports and develop new reports and provide support on deep dive analysis of information and share the insights with BU management.

RESPONSIBILITIES :

• BI reporting and analysis support to the Business Unit
• Design, develop, and maintain interactive dashboards and reports using Power BI and Tableau.
• Build and customize business applications using PowerApps, integrating with various data sources.
• Write and optimize SQL queries for data extraction, transformation, and analysis.
• Work with relational databases to manage and structure data efficiently.
• Integrate and manage data sources through SharePoint and other Microsoft platforms.
• Utilize Power Query for data transformation in Excel and Power BI.
• Develop advanced Excel solutions, including macros and VBA scripting, for automation and reporting.
• Collaborate with cross-functional teams to understand business requirements and deliver data-driven insights.
• Ensure data accuracy, consistency, and security across all reporting platforms.
• Actively participate in the calls/meetings with India, Europe and US teams and understanding the business requirements.

CRITICAL EXPERIENCE

• 4 - 6 years software development experience
• Strong command of SQL for querying and managing data
• Must have strong analytical and reporting skills
• Proficiency in Power BI and Tableau for data visualization and dashboard creation.
• Hands-on experience with PowerApps and familiarity with its integration capabilities.
• Solid understanding of relational database concepts and structures.
• Experience with SharePoint for data storage and collaboration.
• Expertise in Power Query for data transformation tasks.
• Advanced skills in Microsoft Excel, including macros and VBA.
• Skills in Python coding for Machine Learning and automation.
• Excellent analytical, problem-solving, and communication skills.