Sr. Business Analyst
Description
- 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.
- Bachelors 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.
- 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.
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.