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.
