Sr. Business Analyst

Position Summary

Kaseya is hiring a highly analytical and detail-oriented Business Analyst to design, develop, and maintain scalable reporting and analytics solutions that support data-driven business decisions. This role will leverage Power BI, SQL, Python, and Advanced Excel to transform complex data into actionable insights, automate reporting processes, and deliver impactful dashboards that drive operational excellence and business performance.

Key Responsibilities

• Design, develop, and maintain interactive Power BI dashboards, reports, and KPI scorecards to support business and operational decisions.
• Gather and analyze business requirements, translating them into scalable reporting and analytics solutions.
• Develop, optimize, and maintain SQL queries, stored procedures, views, and data models to support reporting and analytics needs.
• Create and maintain Python-based automation scripts for data extraction, transformation, validation, and reporting processes.
• Perform data analysis, cleansing, validation, and transformation across multiple data sources while ensuring data quality and consistency.
• Build and maintain advanced Excel-based analytical models, dashboards, and reports using PivotTables, Power Query, Power Pivot, XLOOKUP, and advanced formulas.
• Implement and manage Power BI security models, including Row-Level Security (RLS), data governance, and access controls.
• Collaborate with business, operations, and technical teams to define KPIs, metrics, and reporting requirements.
• Monitor report performance, troubleshoot data-related issues, and continuously optimize reporting solutions for scalability and efficiency.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Analytics, Statistics, Engineering, or a related field.
• 3+ years of experience in Data Analytics, Business Intelligence, Reporting, or related roles.
• Strong experience developing Power BI dashboards, reports, and semantic data models.
• Proficiency in Advanced DAX functions including CALCULATE, SUMX, iterators, and performance optimization techniques.
• Hands-on experience with Power BI data modeling, Power Query (M Language), and Row-Level Security (RLS).
• Advanced SQL expertise including complex joins, Common Table Expressions (CTEs), window functions (RANK, DENSE_RANK), query optimization, and stored procedure development.
• Strong proficiency in Python programming and scripting for automation, reporting, and data analysis.
• Expertise in Advanced Excel including PivotTables, Power Pivot, XLOOKUP/INDEX-MATCH, Power Query, and workflow automation.
• Good understanding of ETL processes, data transformation concepts, and data warehousing fundamentals.
• Strong analytical, problem-solving, and stakeholder communication skills.

Preferred Qualifications

• Experience designing enterprise reporting solutions within Power BI Service and Microsoft Fabric environments.
• Knowledge of dimensional modeling concepts including Star Schema and Snowflake Schema design.
• Experience integrating data from ERP, CRM, ticketing, or operational management systems.
• Familiarity with Azure Data Services, SQL Server Integration Services (SSIS), or other ETL platforms.
• Experience implementing reporting governance, data quality frameworks, and dashboard performance tuning.
• Ability to present complex analytical findings and recommendations to non-technical stakeholders.
• Experience working in fast-paced, time-critical business environments with multiple stakeholders and competing priorities.