About Deloitte
Deloitte refers to one or more of Deloitte Touche Tohmatsu Limited, a UK private company limited by guarantee (“DTTL”), its network of member
firms, 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. Certain services may not be available to attest
clients under the rules and regulations of public accounting. Please see www.deloitte.com/about to learn more about our global network of member
firms.
Copyright © 2017 Deloitte Development LLC. All rights reserved.
Senior Analyst, Data-Marts & Reporting - Reporting and Analytics – 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 and Reporting team offers you a particular opportunity to be an integral part of the Datamarts & Reporting – 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: 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.
The team
CoRe - Digital Data Analytics Innovation (DDAI) sits inside Deloitte’s global shared services organization and serves
About Deloitte
Deloitte refers to one or more of Deloitte Touche Tohmatsu Limited, a UK private company limited by guarantee (“DTTL”), its network of member
firms, 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. Certain services may not be available to attest
clients under the rules and regulations of public accounting. Please see www.deloitte.com/about to learn more about our global network of member
firms.
Copyright © 2017 Deloitte Development LLC. All rights reserved.
Deloitte’s 10 largest member firms worldwide. The Reporting and Analytics team creates user experiences that delivers relevant content and connections, enables the discovery of impactful knowledge and delights users by delivering innovative applications that use emerging technologies.
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 lifecycle.
• 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-6 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, Azure Synapse, Data warehousing & BI Preferred: Tableau, .Net
Good to have: MVC .Net, Sharepoint front end solutions.
How you will grow 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.
About Deloitte
Deloitte refers to one or more of Deloitte Touche Tohmatsu Limited, a UK private company limited by guarantee (“DTTL”), its network of member
firms, 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. Certain services may not be available to attest
clients under the rules and regulations of public accounting. Please see www.deloitte.com/about to learn more about our global network of member
firms.
Copyright © 2017 Deloitte Development LLC. All rights reserved.
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.
Deloitte’s culture
Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture that is inclusive, invites authenticity, leverages our diversity, and where our people excel and lead healthy, happy lives. Learn more about Life at Deloitte.
Corporate citizenship
Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people, and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our communities. Learn more about Deloitte’s impact on the world.
Disclaimer: Please note that this description is subject to change basis business/project requirements and at the discretion of the management.