Senior Analyst, Data-Marts - Data Reporting & Insights – Digital Data Analytics Innovation - Deloitte Support Services India Private Limited
Are you a quick learner with a willingness to work with new technologies? Data-Marts team offers you a particular opportunity to be an integral part of the Data-marts – CoRe Digital | Data | Analytics | Innovation Group. The principle focus of this group is the research, development, maintain and documentation of customized solutions that e-enable the delivery of cutting-edge technology to firm's business centers.
Work you will do
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: Data-mart Solution Senior Analyst
As a Data-mart Solution Analyst, you will be responsible for delivering technical solutions on building high performing data-mart and reporting tools using tools/technologies like Microsoft SQL Server, MSBI Suite, MS Azure SQL, Tableau, .Net.
Your Key responsibilities includes:
• 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 for transferring data between various systems.
• Create, schedule and monitor SQL jobs.
• 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, HTML, CSS, jQuery, JavaScript, Ajax.
Qualifications and experience Required:
• Educational Qualification: B.E/B.Tech or MTech (60% or 6.5 GPA and above)
• Should be proficient in understanding of one or more of the following Technologies: Knowledge in DBMS concepts, exposure to querying on any relational database preferably MS SQL Server, MS Azure SQL, SSIS, Tableau.
• Knowledge on any of the coding language like C#. NET or VB .Net would be added advantage.
• Understands development methodology and life-cycle.
• Excellent analytical skills and communication skills (written, verbal, and presentation)
• Ability to chart ones’ own career and build networks within the organization
• Ability to work both independently and as part of a team with professionals at all levels
• Ability to prioritize tasks, work on multiple assignments, and raise concerns/questions where appropriate
• Seek information / ideas / establish relationship with customer to assess any future opportunities
Total Experience:
• 4-7 years of overall experience
• At least 3 years of experience in data base development. ETL and Reporting
Skill set:
Required: SQL Server, MS Azure SQL, Azure Data factory, SSIS
Preferred: Tableau, .Net
Good to have: HTML 5, CSS, Jquery, JavaScript
Location: Hyderabad
Work hours: 2 p.m. – 11 p.m.
At Deloitte, we have invested a great deal to create a rich environment in which our professionals can grow. We want all our people to develop in their own way, playing to their own strengths as they hone their leadership skills. And, as a part of our efforts, we provide our professionals with a variety of learning and networking opportunities—including exposure to leaders, sponsors, coaches, and challenging assignments—to help accelerate their careers along the way. No two people learn in exactly the same way. So, we provide a range of resources, including live classrooms, team-based learning, and eLearning. Deloitte University (DU): The Leadership Center in India, our state-of-the-art, world-class learning center in the Hyderabad office, is an extension of the DU in Westlake, Texas, and represents a tangible symbol of our commitment to our people’s growth and development. Explore DU: The Leadership Center in India.
Benefits
At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you
#EAG-Core
#CA-PC