Job Description

SQL Server Analytics & Power BI Developer_Full-Time_Noida, Pune, Mumbai, Delhi, Chennai, Bangalore Job Title: SQL Server Analytics & Power BI Developer Location: Noida, Pune, Mumbai, Delhi, Chennai, Bangalore Job Type: Full-Time Experience: 5-10 Years Skills: SQL Server Analytics Service (SSAS), Basic Power BI, Strong SQL Knowledge Job Description: We are seeking an experienced Senior SQL Server Analytics & Power BI Developer to design and optimize high-performance data models and reporting solutions leveraging SQL Server Analytics Services (SSAS), Power BI, and advanced SQL techniques. The successful candidate will have expertise in multidimensional modeling, complex query optimization, and data visualization, along with a deep understanding of how to architect solutions that integrate with larger data ecosystems. Key Responsibilities: Design and Implement SSAS Cubes: Architect, develop, and optimize OLAP cubes for reporting and analytics using SQL Server Analysis Services (SSAS), focusing on performance tuning, security, and usability. Advanced Data Modeling: Develop complex data models within SSAS, ensuring they are scalable and optimized for reporting efficiency. Employ best practices in dimensional modeling (star and snowflake schemas) to deliver high-performing datasets. Power BI Integration: Design Power BI reports with complex visualizations, integrating SSAS cubes and custom SQL queries for enhanced data insights. Implement advanced DAX calculations and Power Query transformations. ETL and Data Processing: Design, implement, and optimize ETL processes to populate SSAS models from heterogeneous data sources, ensuring data integrity, validation, and consistency. Performance Optimization: Apply advanced query tuning, indexing, partitioning, and caching techniques to optimize both SSAS cubes and SQL queries for fast, responsive reporting. Collaborate with Stakeholders: Work closely with business analysts, architects, and stakeholders to translate complex business requirements into scalable data solutions. Qualifications: Extensive experience with SQL Server (T-SQL, SSIS, SSRS, SSAS). Proficient in building and optimizing SSAS multidimensional models, including cube design, MDX, and query optimization. Expertise in Power BI with advanced DAX, Power Query, and report optimization techniques. Strong understanding of data warehousing concepts and performance tuning techniques. Hands-on experience with large-scale, enterprise-level data architectures. Solid knowledge of advanced SQL query writing and optimization strategies.