Senior Analyst – Data Engineering – The Reporting Hub – Deloitte Support Services India Pvt. Ltd.
The Organization
Central Business Services (CBS) is part of the Enabling Functions (EF) service line supporting the whole of Deloitte UK. It provides services to the UK Firm including HR, Quality, IT, Sourcing and Service Management.
The Reporting Hub sits within the Service Management capability of CBS and was created through consolidating smaller reporting teams across the UK and India into a single entity to create resilience, knowledge and economies of processing. It provides Reporting Services to CBS including:
- Data Engineering-Design, build, and maintain scalable data pipelines and storage solutions, ensuring data quality and integration from various sources. They optimize data workflows for performance, collaborate with stakeholders, and implement security measures.
- DEVELOP – Report development using standard tools including Excel, PowerPoint, PowerBI, Tableau and ServiceNow.
- RUN Processing – Data extraction, processing and reports distribution.
- Insights – Perform the role of Business Partner by managing all central data, reporting, and analytical requirements, ensuring seamless integration and actionable insights for informed decision-making.
The role will:
· The Senior Analyst will play a pivotal role in ensuring the success of the team acting with others to ensure data is processed on time using a variety of different technologies and methods. The delivery of the data to the Business is paramount to the success of the wider Reporting Hub Team.
· The role requires a high degree of engagement with the enabling service areas, effective teamwork, and ability to build strong relationships with stakeholders. This in turn will allow The Reporting Hub to recommend improvements to existing data and reporting methods in terms of time to execute and Customer Satisfaction.
The key qualities of the person are:
- A proactive hands-on style.
- To be inquisitive and push the boundaries to support the organization.
Work you’ll do
Stakeholder Engagement
· Establish and maintain positive working relationships with key stakeholders within the Business.
Data Privacy and Security
· Handle all data in line with agreed Data Privacy processes both physically and virtually.
Development
- Act as part of a multidisciplinary team either leading or participating in operational deliverables.
- Analyse issues & problems with the Business and document clear solution requirements for Client signoff.
- Develop reports and dashboards in-line with standard development methodologies.
- Test and Quality Assure work in line with agreed standards.
- Deploy solutions in line with agreed governance procedures.
Support
- Identification and timely escalation of issues.
- Ensuring all issues have appropriate remedial / mitigations in place to maintain successful operations.
- Supporting in the oversight and monitoring of key issues and providing key metrics.
Qualifications
Required:
- Education:
- Degree in business / engineering / math with a focus in quantitative methods and/or equivalent working experience in the data, reporting & analytics space
- Degree in business / engineering / math with a focus in quantitative methods and/or equivalent working experience in the data, reporting & analytics space
- Interpersonal Skills:
o Strong verbal and written communication skills in English
- Strong numerical and analytical skills
- Ability to use initiative and to work effectively under pressure, in the face of conflicting and/or short deadlines.
- Ability to focus on the end goal and quickly adapt to changing business priorities.
o Build relationships, share new ideas.
- Attention to detail with an ability to take ownership, make decisions, and execute them.
- Excellent team player with experience working in virtual teams.
- Professional Experience:
- Extensive (3+ Years) experience in designing, developing, and maintaining robust data pipelines using SSIS (SQL Server Integration Services), ensuring seamless integration and transformation of data from diverse sources.
- Proficient in implementing and monitoring data quality frameworks, performing data validation, cleansing, and reconciliation to ensure accuracy and reliability across integrated systems.
- Skilled in orchestrating end-to-end ETL processes, leveraging SSIS for data extraction, transformation, and loading, as well as automating workflows through CI/CD pipelines for streamlined deployment and maintenance.
- Advanced skills in DAX and M Query for complex data modeling, calculations, and transformation within Power BI.
- 2+ years of hands-on experience with MS SQL Server (2019/2022), including query optimization, transaction management, stored procedures, functions, triggers, and views, with a strong focus on performance tuning and troubleshooting.
- Proven ability to integrate and manage data from multiple sources, utilizing SSIS and other tools to support business intelligence and analytics initiatives.
- Advanced skills in DAX and M Query for complex data modeling, calculations, and transformation within Power BI.
- Experience in scheduling and managing data refresh cycles, optimizing report performance, and reducing data load times for enhanced user experience.
- Successfully delivered at least two end-to-end data engineering projects, from requirements gathering to deploying the product.
- Technical Skills Levels:
- Advanced Technical documentation
- Advanced SSIS & CI/CD
- Advanced MS Sql Server (2019/2022)
- Advanced PowerBI (Data Modeling)
- Intermediate Reporting Visualization techniques
- Advanced Knowledge of Relational Data Structures
- Desirable Skills:
- Experience of working in a professional services environment
- Data protection principles
- Risk and Information System Controls
- India - Hyderabad Timings: 2 PM to 11 PM
How you’ll grow
At Deloitte, we’ve 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. DU: The Leadership Center in India, our state-of-the-art, worldclass learning Center in the Hyderabad offices is an extension of the Deloitte University (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.
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.