Senior Associate Business Intelligence Analytics / Reporting

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

Job summary

Shashwath Solution is seeking a talented Senior BI Analyst to design, develop, and maintain dashboards, data models, and feeds that drive business insight for our enterprise clients.

You will collaborate with stakeholders across the organization, ensure data accuracy, implement Power BI solutions with advanced DAX and M queries, and follow best practices for security and governance while staying current with BI trends.

Qualifications

• Experience with 4+ years in BI and reporting focusing on dashboards.
• Expertise with Power BI, DAX, Power Query, and data modeling.
• Strong SQL and experience with SQL Server/Azure/Oracle/MySQL/Redshift.
• Familiar with AWS or Azure Data Factory.
• Knowledge of Agile methodologies and end-to-end BI projects.
• Excellent communication and cross-functional collaboration.

Responsibilities

• Design, develop, and maintain BI dashboards and reports.
• Create data models and feeds for reporting.
• Translate business needs into technical requirements.
• Ensure data quality and accessibility for reporting.
• Develop persona-based and executive dashboards to provide insights.
• Follow Power BI best practices and security policies.
• Collaborate with stakeholders across teams.
• Stay updated on BI trends and technologies.
• Manage workload and streamline processes.

Skills

Communication skills

Agile methodologies

Requirement analysis

Collaboration

Education

Bachelor's degree in Computer Science or related field

MBA preferred

Tools

Power BI

SQL Server / Azure SQL

Oracle

MySQL

Azure Data Factory

Power Automate/Power Apps

Excel

REST API

Python

R

DAX Studio

Tabular Editor

JavaScript

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.