Senior Associate Business Intelligence Analytics / Reporting

Shashwath Solution; Pune District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Shashwath Solution in Pune, India is seeking a seasoned BI professional to design, develop, and maintain the organization’s dashboards, data models, and reporting solutions to drive business insights. The role will collaborate with stakeholders to translate requirements into technical implementations and ensure data accuracy and accessibility for reporting and analysis.

You will lead end-to-end BI initiatives, implement Power BI best practices including complex DAX, data modeling, and security

Qualifications

• 4+ years of BI experience with dashboards and reporting.

Responsibilities

• Design, develop, and maintain the organization’s business intelligence and reporting dashboards.

Skills

SQL

DAX

Power BI

Power Query

M Query

Python

R programming

Excel

REST API

Power Apps

Power Automate

DAX Studio

Tabular Editor

JavaScript

Education

Bachelor's degree in Computer Science or related field

MBA preferred

Tools

Microsoft SQL Server

Azure SQL Server

Oracle

MySQL

Amazon Redshift

AWS

Azure Data Factory

Power BI Service

Job description

Role Responsibilities

• Design, develop, and maintain the organization’s business intelligence and reporting dashboards.
• Design, develop, and maintain data models and feeds for report development.
• Prepare insights based on data and reporting solutions.
• Collaborate with business stakeholders to understand reporting and analysis needs and translate them into technical requirements.
• Ensure that data is accurate and easily accessible for reporting and analysis.
• Develop and maintain persona-based dashboards, management reports and executive views to provide business insights.
• Experienced in Power BI to understand business needs and deliver technical solutions.
• Follow, learn, and share best practices for Power BI development.
• Ensure compliance with security and data privacy policies and regulations.
• Manage and prioritize workload and identify opportunities to streamline processes and improve efficiency.
• Keep up to date with industry trends and emerging technologies and evaluate their potential impact on business intelligence and reporting.

Qualifications & Skills

• Bachelor’s degree in Computer Science, Information Systems, or a related field
• Master of Business Administration preferred.
• At least 4 years of experience in business intelligence and reporting, with a focus on data visualization, dashboards, and reporting.
• Demonstrated experience with Microsoft Power BI, with proficiency in complex DAX, Power Query, tabular data modeling, visualizations, RLS, composite modeling, Power BI Service, Licensing, etc.
• Strong understanding of database systems, analytical processing, data modeling and ETL/DWH framework.
• Worked in advanced SQL and database technologies such as Microsoft SQL Server, Azure SQL Server, Oracle, and MySQL, and Amazon Redshift SQL.
• Experience with cloud-based data storage and processing technologies such as AWS or Azure Data Factory is a plus.
• Experience in end-to-end implementation projects as well as maintenance & support projects is a plus.
• Excellent communication skills, with the ability to collaborate effectively with cross-functional teams.
• Experienced across requirement analysis, solutioning, designing, modeling, implementation, testing, end-user communication.
• Work in diverse environments - geographical, cultural, and business is preferred.
• Ability to adapt to changing reporting requirements, priorities, and project timelines.
• Experience in Banking or Financial Services industry is a plus.
• Experience in Agile methodologies is preferred.
• Experience in Microsoft Excel, SharePoint Online, PowerAutomate, Draw.io, Power Apps, Administration, Governance, REST API, PowerShell, JavaScript, DAX Studio, Tabular Editor, Python, R programming, is a plus.
• Certification in Microsoft Power BI or SQL is a plus.

Must Have:

• SQL (Minimum 3-4 years of hands-on experience), DAX, Power BI, Power Query, M Query.