Senior Analyst-KX Analytics-Datamart-Hyderabad

As a Senior Analyst, you will research and develop solutions built on varied technologies like Microsoft SQL Server, MSBI Suite, MS Azure SQL, Tableau, .Net. You will support a team which provides high-quality solutions to the customers by following a streamlined system development methodology. In the process of acquainting yourself with various development tools, testing tools, methodologies and processes, you will be aligned to the following role: 1. Role: Datamart Solution Senior Analyst As a Datamart Solution Analyst, you will be responsible for delivering technical solutions on building high performing datamart and reporting tools using tools/technologies like Microsoft SQL Server, MSBI Suite, MS Azure SQL, Tableau, .Net. Your key responsibilities include: • Interact with end users to gather, document, and interpret requirements. • Leverage requirements to design technical solution. • Develop SQL objects and scripts based on design. • Analyze, debug, and optimize existing stored procedures and views. • Leverage indexes, performance tuning techniques, and error handling to improve performance of SQL scripts. • Create and modify SSIS packages, ADF Pipelines for transferring data between various systems cloud and On-premise environments. • Should be able to seamlessly work with different Azure services. • Improve performance and find opportunities to improvise process to bring in efficiency in SQL, SSIS and ADF. • Create, schedule and monitor SQL jobs. • Build interactive visualizations in Tableau for leadership reporting. • Proactively prioritize activities, handle tasks and deliver quality solutions on time. • Communicate clearly and regularly with team leadership and project teams. • Manage ongoing deliverable timelines and own relationships with end clients to understand if deliverables continue to meet client's need. • Work collaboratively with other team members and end clients throughout development life cycle. • Research, learn, implement, and share skills on new technologies. • Understand the customer requirement well and provide status update to project lead (US/USI) on calls and emails efficiently. • Proactively prioritize activities, handle tasks and deliver quality solutions on time. • Guide junior members in team to get them up to speed in domain, tool and technologies we work on. • Continuously improves skills in this space by completing certification and recommended training. • Obtain and maintain a thorough understanding of the MDM data model, Global Systems & Client attributes. • Good understanding of MVC .Net, Sharepoint front end solutions. • Good to have knowledge on Full stack development.

Deloitte refers to one or more of Deloitte Touche Tohmatsu Limited, a UK private company limited by guarantee ("DTTL"), its network of memberfirms, and their related entities. DTTL and each of its member firms are legally separate and independent entities. DTTL (also referred to as "Deloitte Global") does not provide services to clients. In the United States, Deloitte refers to one or more of the US member firms of DTTL, their related entities that operate using the "Deloitte" name in the United States and their respective affiliates.