Responsibilities: • Responsible for administering, supporting, monitoring, and tuning the Power BI reporting environment • Design, extend, and enhance Power BI data models and development of new cubes • Designing and developing advanced multidimensional and tabular SSAS models based on business requirements. • Leading efforts to design and implement efficient and scalable data models using SSAS multidimensional and tabular models. • Optimizing cube performance by fine-tuning measures, aggregations, partitions, and processing strategies. • Develop, test, and deploy DAX-based scripts, queries, and functions in Power BI • Creating and optimizing complex DAX expressions for tabular models to meet analytical needs. • Design and develop Power BI dashboards and reports. • Works closely with Power BI report users to tune and optimize Power BI reports and dashboards. • Serves as Best Practices resource for Power BI initiatives in the organization. • Conducts training and user-group sessions on Power BI. • Acts as the escalation point for Power BI-related issues. • Creating comprehensive documentation for SSAS models, DAX expressions, Power BI reports, and Paginated Reports to facilitate knowledge sharing within the team. • Mentoring and guiding junior team members on SSAS, DAX, Power BI, and Paginated Reports development best practices.
Required Skills and Experience • Bachelor's degree in Computer Science, Information Technology, or a related field. • 5+ years of BI Developer experience (SSAS, DAX, Power BI, Paginated Report, Power BI Gateway, Service, Security) • 5+ overall industry experience in Data Analytics & Dashboarding/Reporting. • Strong proficiency in SQL, SSAS/AAS tabular modeling, DAX, Power BI, and Paginated Reports. • Experience working with Azure-based BI solutions, including Azure SQL, Azure Synapse, Data Factory, Blob Storages & Data Lakes. • Excellent problem-solving and analytical skills. • Strong communication and collaboration skills. • Ability to work effectively in a team and independently. • Relevant certifications (e.g., Microsoft Certified: Data Analyst Associate, Microsoft Certified: Azure Data Engineer Associate, Microsoft Certified: Power BI, etc.) are a plus.