2+ SQL Server Analysis Services (SSAS) Jobs in Mumbai | SQL Server Analysis Services (SSAS) Job openings in Mumbai

Project context

Summary

A new GIT platform will be created in our existing Captive in India (CASPL) and it will operate some activities of Digital Centre of Excellence (DEC)

Digital Centre of Excellence (DEC) manages a transverse offer of digital products and delivers IT services through its centers of excellence.

Activities encompass development of reusable components (building blocks), development and maintenance of business solutions that leverage on multiple expertise.

It requires professionals having technical competencies and noticeable experience on critical services in the context of an investment bank.

Working in DEC requires ability to extensively collaborate across geographies with other IT professionals and non-IT functions as well as a strong motivation on supporting the digital transformation of the bank.

Key Responsibilities

•Design & Develop Microsoft BI solutions to answer business needs

•Support existing BI application on their evolution / fixes based on the urgency

•Visualize, interpret, and report data findings and may create dynamic data reports as well

•Deliver code according to the specifications; follow code standards, versioning and branching

•Maintain a high standard of delivery quality

•Interact with business analysts in order to provide business focused solutions

•Interact with tech-leads, architects to ensure good design and code quality

•Work closely with the team, internal stakeholders and other cross functional teams

•Ensure documentations are up to date (technical design, deployment guide, release notes, etc.)

•Follow the user acceptance test and coordinate the prioritization with project manager

•Diagnose & resolve application/configuration/code level technical issues

•Create / amend necessary CI/CD pipelines using Azure DevOps

•Innovate and look for new solutions/components

•Build POCs to demonstrate new usage and present them in senior audience

•Perform regular peer-reviews, maintain low technical debts, assess & up-skill junior staffs

•Implement any possible automation of a recurrent process

Communication Key Internal Contacts

•GIT CASPL DEC – Operation manager

•GIT CASPL DEC – Squad leader

•GIT ISAP DEC – Product manager

Legal and Regulatory Responsibilities

•Comply with all applicable legal, regulatory and internal Compliance requirements, including, but not limited to, the local Compliance manual and the Financial Crime Policy. Complete any mandatory training in line with legal, regulatory and internal Compliance requirements.

•Maintain appropriate knowledge to ensure to be fully qualified to undertake the role. Complete all mandatory training as required to attain and maintain competence.

•Refrain from taking any steps which could lead to the removal of certification of fitness and properness to perform the role.

•Undertake all necessary steps to satisfy the annual certification process.

•Comply with all applicable conduct rules as prescribed by the relevant regulator.

ROLE REQUIREMENTS:

•Minimum 8+ years of experience with Microsoft BI stack components

•Experience and knowledge of SDLC or Agile development framework and methodologies

•Strong experience on data warehousing design, modelling and historization

•Experience with CI/CD practices using AzureDevOps

Degree holder in Computer Science or related discipline / relevant experience with MSBI technology A total of 8+ years in IT industry with a minimum of 6+ years of related working experience, in financial/banking environment.

Mandatory skills

•Experience with SQL Server (2017 / 2022)

•Experience in SQL query optimization; complex data retrievals and manipulations.

•Design and development of SSRS, PowerBI, ETL (SSIS)

•MDX/DAX, SSAS Tabular modelling

•C# experience for SSIS

Nice to have (Optional)

•Exposure with data processing pipelining using Python, PySpark, Airflow, etc

•Cloud development using Kubernetes, micro-services

•MPP database like Vertica

•Scripting using PowerShell

Data visualization tools Cognos, Tableau or Qlik

C#, SSRS, SQL Query Optimization, SQL Server (2017/2022), Microsoft Power BI