SQL Server Analytics

1 day 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

    2 weeks 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 days 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

  • SQL Server Database Administrator

    4 weeks ago

    Bengaluru, Karnataka, India Coders Brain Technology Private Limited Full time

    About the Role :We are looking for an experienced SQL Server Database Administrator to join our team. The ideal candidate will be responsible for the installation, configuration, performance tuning, security, backup/recovery, and high availability of SQL Server environments. You will play a critical role in ensuring database reliability, scalability, and...

  • MS SQL Server DBA

    3 weeks ago

    Bengaluru, Karnataka, India Align Technology Full time

    Job DescriptionWe are looking for a MS SQL Server DBA to be onboarded urgently on an engagement for immediate requirement.JD for the role is as below.- 5+ years MS SQL Server Administration experience required.- Proficiency in writing complex SQL queries, stored procedures, triggers, and functions.- Experience with Performance Tuning and Optimization (PTO),...

  • 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 DBA Professional

    4 weeks ago

    Bengaluru, Karnataka, India Qualitest Full time

    Job DescriptionJob description- Minimum 5-10 years MS SQL Server Administration and preferably 2022 V11 experience required2) Perform regular database maintenance activities by following internal processes (data loads, data fixes, schema updates, database copies, software installs, upgrades and patches)- Running daily database checks- Technical knowledge of...

  • 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...

  • Ms Sql Server Database Administrator

    1 week ago

    Bengaluru, Karnataka, India Headsnminds Consultants Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    MS SQL SERVER DBA ( 6 positions)Job location - BengaluruExps range - 4 to 8 yrsOur client is hiring an experienced Senior SQL Server Database Administrator with knowledge of AWS Cloud technologies. The ideal candidate will have a deep understanding of SQL Server administration coupled with expertise in AWS services, particularly AWS RDS SQL Server/Aurora and...