Senior Associate Business Intelligence Analytics and Reporting

Shashwath Solution; Pune District; Remote; INR 900,000 - 1,300,000; Full time

Job summary

Shashwath Solution is seeking a seasoned BI Analyst to design, develop, and maintain Power BI dashboards and data models. You will translate business needs into technical reporting solutions and deliver insights that drive strategic decisions.

The role emphasizes end-to-end BI delivery, data governance, and collaboration with stakeholders. Remote work with India-wide scope is offered, focusing on BI excellence.

Qualifications

• 4+ years of experience in BI with dashboards and reporting.
• Proficiency in complex DAX, Power Query, tabular data modeling, and RLS (row-level security).
• Experience with SQL Server, Azure SQL Server, Oracle, MySQL, and Redshift SQL.
• Cloud data storage/processing via AWS or Azure Data Factory is a plus.
• End-to-end BI projects including maintenance and support exposure.
• Strong communication and cross-functional collaboration.
• Experience with Agile methodologies is a plus.
• Excel, SharePoint Online, Power Automate, Draw.io, Power Apps, REST API, PowerShell, JavaScript, DAX Studio, Tabular Editor, Python, and R are advantageous.
• Certification in Power BI or SQL is a plus.

Responsibilities

• Design, develop, and maintain BI dashboards and reporting solutions.
• Design data models and data feeds for reporting.
• Prepare insights based on data and reporting.
• Collaborate with stakeholders to translate requirements into technical specs.
• Ensure data accuracy and accessibility for reporting and analysis.
• Develop persona-based dashboards and executive views for business insights.
• Follow best practices for Power BI development.
• Ensure compliance with data security and privacy policies.
• Manage workload and identify process improvements.
• Stay updated with industry trends and emerging BI technologies.

Skills

Power BI

DAX

Power Query

M Query

SQL

Data modeling

Python

R programming

ETL

Data warehousing

Education

Bachelor's degree in Computer Science, Information Systems, or a related field

Master of Business Administration preferred

Tools

Microsoft Power BI

Microsoft SQL Server

Azure SQL Server

Oracle

MySQL

Amazon Redshift

AWS or Azure Data Factory

SharePoint Online

Power Automate

Draw.io

Power Apps

REST API

PowerShell

JavaScript

DAX Studio

Tabular Editor

Python

R programming

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.

Location - Remote, Hyderabad,Ahmedabad,pune,chennai,kolkata.

Mandatory Key Skills

etl,data modeling,licensing,sql,business intelligence,python,data warehousing,sql server,amazon redshift,aws,javascript,azure data factory,sql azure,powerapps,mysql,sharepoint,oracle,power bi*,dax*,power query*,microsoft power bi*,data visualization*