SQL Server Analytics

3 weeks ago

Bengaluru Karnataka India, Karnataka Best Infosystems Ltd. Full time

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.

  • CISAMRMFRE- SQL Server

    1 week ago

    Bengaluru, Karnataka, India Infosys Full time ₹ 1,04,000 - ₹ 1,30,878 per year

    Educational RequirementsBachelor of EngineeringService LineCloud & Infrastructure ServicesResponsibilitiesExpertise in Database Administration on Production Servers with server configuration and management with troubleshooting capabilities.Hands on experience in configuration and management of SQL Server High Availability and DR strategiesProficiency and...

  • SQL Server Development DBA

    1 week ago

    Bengaluru, Karnataka, India Informica Technoservices Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Role & ResponsibilitiesAdminister and maintain SQL Server databases across development and production environments.Develop, optimize, and troubleshoot T-SQL queries, stored procedures, triggers, and functions.Perform database backup, recovery, migration, and ETL activities.Configure and manage SSIS / SSRS for integration and reporting.Monitor database...

  • SSAS (Sql Server Analysis services)

    3 weeks ago

    Bengaluru, Karnataka, India, Karnataka Tata Consultancy Services Full time

    TCS hiring!!Role: SSAS (Sql Server Analysis services)Location: BangaloreExperience: 4-6Must Have:SSAS (Sql server Analysis services), SSISMDB cube (Multi dimensional database) , supply chain domain knowledgedesigning, developing ,deploying and maintaining OLAP cubes, tabular models and related BI solution

  • PL/SQL Developer

    2 weeks ago

    Bengaluru, Karnataka, India, Karnataka Innover Digital Full time

    We are looking for an experienced PL/SQL Developer to join our team for a Sybase IQ to SQL Server migration project. The ideal candidate will have deep expertise in database development, data migration, and performance tuning, with proven experience converting complex Sybase stored procedures, triggers, and functions into SQL Server (T-SQL) equivalents.Key...

  • Microsoft Sql Server Developer

    6 days ago

    Bengaluru, Karnataka, India Uplers Full time ₹ 10,00,000 - ₹ 20,00,000 per year

    Microsoft SQL Server DeveloperExperience: 5-8 Years ExpSalary : ConfidentialPreferred Notice Period: less than or equal to 30 daysShift: 10:00 AM to 6:00 PM ISTOpportunity Type: Remote (India)Placement Type: Permanent(*Note: This is a requirement for one of Uplers' Clients)Must have skills required :Microsoft SQL Server Developer, SQL Queries, SQL Server...

  • SQL Server Database Administrator

    1 week ago

    Bengaluru, Karnataka, India HCL Technologies Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    CONSULTANT Experience 4.5-8 Years Skill (Primary) Data Center-DATABASE-MSSQL DBA Qualification BE/B.Tech (Hons) Location Bangalore Job Description (Posting). Microsoft SQL Server DBA with experience in large and critical environments.\\r\ Knowledge of performance tuning at both server level and query level. Candidate must have knowledge...

  • SQL Server Development Professional

    2 weeks ago

    Bengaluru, Karnataka, India IDESLABS PRIVATE LIMITED Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    We are looking for a skilled SQL Server developer with 6-9 years of experience to join our team in Bangalore. The ideal candidate will have strong SQL Server development skills and excellent understanding of Retail Architecture and IT Project Lifecycle.Roles and ResponsibilityDesign, develop, and implement database solutions using SQL Server.Write functions...

  • SQL Server Database Administrator

    2 weeks ago

    Bengaluru, Karnataka, India Lider Consultancy Services Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Job Description:Perform installations, upgrades and patching, backup and recovery, performance tuning, security, monitoring, and configuration.Define standards for physical data storage, maintenance, access, and security administration.Configure database parameters and define data repository requirements, data dictionaries, and warehousing...

  • SQL Database Administrator

    2 weeks ago

    Bengaluru, Karnataka, India, Karnataka Tata Consultancy Services Full time

    TCS hiring!!!Role: SQL DBALocation: BangaloreExperience: 8-10Must Have:Installation, configuration and troubleshooting of current and previous MS SQL server versions dating back to 2016SQL server maintenance tasksSQL server high availability / disaster recovery solutions especially SQL Cluster and Always On SQL server backup strategies and recovery of...

  • SQL Database Administrator

    3 weeks ago

    Bengaluru, Karnataka, India, Karnataka Tata Consultancy Services Full time

    Required Experience & Skillset:For E3- level -- More than 8 years of Experience in IT with a minimum 5 years in SQL administrationExpert knowledge of:Installation, configuration and troubleshooting of current and previous MS SQL server versions dating back to 2016SQL server maintenance tasksSQL server high availability / disaster recovery solutions...