Senior Associate Business Intelligence Analytics and Reporting

Shashwath Solution; Dadri; On-site; INR 1,200,000 - 2,500,000; Full time

Job summary

Shashwath Solution is seeking a Senior BI & Reporting Specialist to design and maintain BI dashboards and data models that drive business insights.

You will collaborate with stakeholders to translate requirements, ensure data accuracy, and deliver executive views using Power BI, DAX, and data warehousing techniques. Experience with SQL databases and cloud platforms (AWS/Azure) is highly valued, along with strong communication across teams.

Qualifications

• Bachelor's degree in CS/IS or related field; MBA preferred.
• 4+ years in BI and reporting with dashboards and analytics.
• Proficient in Power BI with complex DAX, Power Query, and data modeling.
• Strong SQL knowledge across SQL Server, Oracle, MySQL, and Redshift.
• Experience with cloud data storage/processing (AWS or Azure Data Factory) a plus.
• Excellent communication and cross-functional collaboration.
• Agile experience preferred.

Responsibilities

• Design and maintain BI dashboards and reporting.
• Develop data models and feeds for reports.
• Translate business needs into technical requirements.
• Ensure data accuracy and accessibility for reporting.
• Collaborate with stakeholders across functions.
• Follow best practices for Power BI development.
• Ensure compliance with security and data privacy policies.
• Stay updated on BI trends and technologies.

Skills

Power BI

DAX

Power Query

M Query

SQL

ETL/Data Warehousing

Data Modeling

Python

R

Education

Bachelor's degree in CS/IS or related field

MBA preferred

Tools

Microsoft SQL Server

Azure SQL Server

Oracle

MySQL

Amazon Redshift

Azure Data Factory

Power BI Service

Power Automate

SharePoint Online

REST API

Power Apps

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.