SSAS (MDX) Lead

2 months ago

bangalore, India Infosys Full time
We are seeking a highly experienced Senior SSAS (MDX) Lead to join our team. The ideal candidate will have extensive expertise in developing SSAS cubes, implementing dimensional modeling, optimizing OLAP performance, integrating security measures, and proficiency in ETL and DAX queries. This role involves collaborating with stakeholders to design, develop, and deploy efficient analytical solutions using SQL Server Analysis Services (SSAS) Multi-Dimensional Cubes.
Responsibilities:
Design, develop, and optimize SSAS Multi-Dimensional Cubes solutions to meet business requirements.
Implement robust security measures, including role-based security and row-level security, to ensure data confidentiality and integrity.
Collaborate with stakeholders to gather security requirements and translate them into technical specifications.
Develop and maintain ETL processes to extract, transform, and load data into SSAS cubes securely.
Configure row-level security to restrict access to sensitive data based on user roles and permissions.
Integrate SSAS Multi-Dimensional Cubes with Tabular models to leverage the strengths of both technologies.
Perform performance tuning and optimization of SSAS cubes for efficient query processing while maintaining security standards.
Conduct troubleshooting and resolve security-related issues in SSAS cubes and underlying data sources.
Document security designs, procedures, and best practices for SSAS development and maintenance.
Stay current with industry trends and best practices in SSAS Multi-Dimensional Cubes development and security implementation.
Key Responsibilities:
Participate in building architecture and design.
Develop, test, and deploy data integration solutions.
Provide data management knowledge to deliver the most architecturally efficient.
Must Skills:
Primary: MDX, MOLAP
Secondary: SQL, DAX (Tabular)
Data Modeling, Data Warehousing, ETL
Nice to Have Skills: Azure Analysis Services, Power BI, SSAS, Power Apps
Qualifications:
Bachelor's degree in Computer Science, Information Systems, or related field.
Minimum of 7 years of experience in SSAS development, with a focus on MDX.
Proficiency in SQL and experience with DAX for Tabular models is preferred.
Strong understanding of dimensional modeling concepts and methodologies.
Experience with implementing security measures in SSAS, including role-based security and row-level security.
Experience integrating SSAS Multi-Dimensional Cubes with Tabular models.
Experience with ETL tools and processes, particularly SSIS (SQL Server Integration Services).
Excellent problem-solving skills and attention to detail.
Ability to communicate effectively with technical and non-technical stakeholders.
Proven track record of delivering high-quality SSAS solutions on time and within budget.
If you have a passion for SSAS development, strong domain knowledge in Retail, and the ability to lead projects effectively, we encourage you to apply and join our team at Infosys

  • SSAS (MDX) Lead

    2 months ago

    Bangalore, India Infosys Full time

    We are seeking a highly experienced Senior SSAS (MDX) Lead to join our team. The ideal candidate will have extensive expertise in developing SSAS cubes, implementing dimensional modeling, optimizing OLAP performance, integrating security measures, and proficiency in ETL and DAX queries. This role involves collaborating with stakeholders to design, develop,...

  • SSAS (MDX) Lead

    3 weeks ago

    Bangalore, India Infosys Full time

    We are seeking a highly experienced Senior SSAS (MDX) Lead to join our team. The ideal candidate will have extensive expertise in developing SSAS cubes, implementing dimensional modeling, optimizing OLAP performance, integrating security measures, and proficiency in ETL and DAX queries. This role involves collaborating with stakeholders to design, develop,...

  • SSAS (MDX) Lead

    2 months ago

    bangalore, India Infosys Full time

    We are seeking a highly experienced Senior SSAS (MDX) Lead to join our team. The ideal candidate will have extensive expertise in developing SSAS cubes, implementing dimensional modeling, optimizing OLAP performance, integrating security measures, and proficiency in ETL and DAX queries. This role involves collaborating with stakeholders to design, develop,...

  • Ssas (mdx) lead

    1 week ago

    Bangalore City, India Infosys Full time

    We are seeking a highly experienced Senior SSAS (MDX) Lead to join our team. The ideal candidate will have extensive expertise in developing SSAS cubes, implementing dimensional modeling, optimizing OLAP performance, integrating security measures, and proficiency in ETL and DAX queries. This role involves collaborating with stakeholders to design, develop,...

  • SSAS (MDX) Lead

    3 weeks ago

    bangalore, India Infosys Full time

    We are seeking a highly experienced Senior SSAS (MDX) Lead to join our team. The ideal candidate will have extensive expertise in developing SSAS cubes, implementing dimensional modeling, optimizing OLAP performance, integrating security measures, and proficiency in ETL and DAX queries. This role involves collaborating with stakeholders to design, develop,...

  • SSAS (MDX) Lead

    2 months ago

    bangalore, India Infosys Full time

    We are seeking a highly experienced Senior SSAS (MDX) Lead to join our team. The ideal candidate will have extensive expertise in developing SSAS cubes, implementing dimensional modeling, optimizing OLAP performance, integrating security measures, and proficiency in ETL and DAX queries. This role involves collaborating with stakeholders to design, develop,...

  • SSAS (MDX) Lead

    3 weeks ago

    bangalore, India Infosys Full time

    We are seeking a highly experienced Senior SSAS (MDX) Lead to join our team. The ideal candidate will have extensive expertise in developing SSAS cubes, implementing dimensional modeling, optimizing OLAP performance, integrating security measures, and proficiency in ETL and DAX queries. This role involves collaborating with stakeholders to design, develop,...

  • SSAS (MDX) Lead

    2 months ago

    bangalore, India Infosys Full time

    We are seeking a highly experienced Senior SSAS (MDX) Lead to join our team. The ideal candidate will have extensive expertise in developing SSAS cubes, implementing dimensional modeling, optimizing OLAP performance, integrating security measures, and proficiency in ETL and DAX queries. This role involves collaborating with stakeholders to design, develop,...

  • Ssas Lead

    4 days ago

    bangalore, India Infosys Full time

    We are seeking a highly experienced Senior SSAS (MDX) Lead to join our team. The ideal candidate will have extensive expertise in developing SSAS cubes, implementing dimensional modeling, optimizing OLAP performance, integrating security measures, and proficiency in ETL and DAX queries. This role involves collaborating with stakeholders to design, develop,...

  • Lead BI Analyst

    3 weeks ago

    Bangalore, Karnataka, India Nilasu consulting Full time

    Job Description :Nilasu Consulting Services Pvt Ltd is seeking a talented and experienced Lead BI Analyst to join our team. As the Lead BI Analyst, you will be responsible for developing and maintaining data models and ETL processes using Power BI tools such as Power Query and Power Pivot. You should have expertise in Power BI Desktop, Power Query, Power...

  • Technical Lead

    1 day ago

    bangalore, India Sapiens Full time

    Roles & Responsibilities: - Lead the design, development, testing, implementation, and maintenance of complex reports and dashboards using the Power BI. Additional Reporting Tool Knowledge is advantageous. - Develop and execute strategic plans for data solutions, ensuring alignment with organizational goals and objectives. - Mentor and guide a team of...

  • MSBI Lead

    1 month ago

    Bangalore, India T D Newton Full time

    Urgent requirement for MSBI Lead for Bangalore Location.Experience : 8-12 YrsJob Location : BangaloreJob Description :- 8-12 years of Good knowledge and experience in designing and implementing technical architecture based on SQL/SSIS/SSAS technologies.- Good communication and Good interpersonal skills.- Comfortable to work as a team and share information...

  • Lead SQL Developer

    4 weeks ago

    bangalore, India GyanSys Inc. Full time

    The I.T. Professional should have at least 10 years of experience in Microsoft SQL Server development.- They should have a good understanding of SQL commands such as DDL, DML, DCL, and TCL.Experience in performance tuning is mandatory- They should have experience with SQL joins and set operators to retrieve data from multiple tables and combine results from...

  • Lead sql developer

    4 weeks ago

    Bangalore, India GyanSys Inc. Full time

    The I. T. Professional should have at least 10 years of experience in Microsoft SQL Server development. - They should have a good understanding of SQL commands such as DDL, DML, DCL, and TCL. Experience in performance tuning is mandatory - They should have experience with SQL joins and set operators to retrieve data from multiple tables and combine...

  • Technical Lead

    2 days ago

    Bangalore, India Sapiens Full time

    Roles & Responsibilities: Lead the design, development, testing, implementation, and maintenance of complex reports and dashboards using the Power BI. Additional Reporting Tool Knowledge is advantageous. Develop and execute strategic plans for data solutions, ensuring alignment with organizational goals and objectives. Mentor and guide a team of...

  • Technical Lead

    1 day ago

    bangalore, India Sapiens Full time

    Roles & Responsibilities: Lead the design, development, testing, implementation, and maintenance of complex reports and dashboards using the Power BI. Additional Reporting Tool Knowledge is advantageous. Develop and execute strategic plans for data solutions, ensuring alignment with organizational goals and objectives. Mentor and guide a team of developers...

  • Senior Business Intelligence Developer

    3 weeks ago

    Bangalore, India Nilasu consulting Full time

    Job Title: Lead BI AnalystJob Summary:Nilasu Consulting Services Pvt Ltd is seeking a highly skilled and experienced Lead BI Analyst to develop and maintain data models and ETL processes using Power BI tools such as Power Query and Power Pivot.Key Responsibilities:Develop and maintain data models and ETL processes using Power BI tools such as Power Query and...

  • Lead SQL Developer

    1 month ago

    bangalore, India GyanSys Inc. Full time

    The I.T. Professional should have at least 10 years of experience in Microsoft SQL Server development. - They should have a good understanding of SQL commands such as DDL, DML, DCL, and TCL. Experience in performance tuning is mandatory - They should have experience with SQL joins and set operators to retrieve data from multiple tables and combine results...

  • Sapiens | Technical Lead

    2 days ago

    bangalore, India Sapiens Full time

    Roles & Responsibilities: Lead the design, development, testing, implementation, and maintenance of complex reports and dashboards using the Power BI. Additional Reporting Tool Knowledge is advantageous. Develop and execute strategic plans for data solutions, ensuring alignment with organizational goals and objectives. Mentor and guide a team of developers...

  • Sapiens | Technical Lead

    2 days ago

    bangalore, India Sapiens Full time

    Roles & Responsibilities:Lead the design, development, testing, implementation, and maintenance of complex reports and dashboards using the Power BI. Additional Reporting Tool Knowledge is advantageous.Develop and execute strategic plans for data solutions, ensuring alignment with organizational goals and objectives.Mentor and guide a team of developers...