Technical Business Analyst-Consultant/Senior Consultant

Your potential, unleashed.India’s impact on the global economy has increased at an exponential rate and Deloitte presents an opportunity to unleash and realize your potential amongst cutting edge leaders, and organizations shaping the future of the region, and indeed, the world beyond.At Deloitte, your whole self to work, every day. Combine that with our drive to propel with purpose and you have the perfect playground to collaborate, innovate, grow, and make an impact that matters.The Team Deloitte’s Technology & Transformation practice can help you uncover and unlock the value buried deep inside vast amounts of data. Our global network provides strategic guidance and implementation services to help companies manage data from disparate sources and convert it into accurate, actionable information that can support fact-driven decision-making and generate an insight-driven advantage. Our practice addresses the continuum of opportunities in business intelligence & visualization, data management, performance management and next-generation analytics and technologies, including big data, cloud, cognitive and machine learning. Your work profile:As a Consultant/Senior Consultant in our T&T Team you’ll build and nurture positive working relationships with teams and clients with the intention to exceed client expectations: -We are looking for a Technical Business Analyst (Tech BA) who can bridge the gap between business requirements and technical implementation. The ideal candidate will combine strong business acumen with deep technical expertise in SQL, AWS data services, and BI tools, while also leading requirement gathering, solution design, and delivery oversight.Key Responsibilities:Lead requirement gathering, KPI definition, and business alignment in collaboration with Product Managers and stakeholders.Architect and implement end-to-end data pipelines (ETL/ELT) using AWS services (Redshift, Athena, Glue, Data Net, S3).Drive SQL query optimization to enhance pipeline performance and dashboard responsiveness.Build and maintain scalable BI solutions (Quick Sight preferred) for executives and business teams.Mentor and guide engineers/analysts, resolve blockers, and ensure smooth delivery.Translate complex business challenges into actionable, data-driven insights that influence decision-making.Required Skills & Experience:Advanced SQL expertise (Joins, Window Functions, CTEs, Stored Procedures, Indexing, Query Optimization, Execution Plans).Strong experience in AWS Data Stack (Redshift, Athena, Glue, Data Net).Proven ability to design scalable ETL/ELT pipelines and data models.Hands-on experience with BI tools (Quick Sight preferred; Power BI, Tableau a plus).Strong business problem-solving, leadership, and stakeholder management skills.Location and way of working:Base location: BangaloreThis profile involves occasional travelling to client locations. Hybrid is our default way of working. Each domain has customized the hybrid approach to their unique needs.How you’ll growConnect for impactOur exceptional team of professionals across the globe are solving some of the world’s most complex business problems, as well as directly supporting our communities, the planet, and each other. Know more in our Global Impact Report and our India Impact Report.Empower to leadYou can be a leader irrespective of your career level. Our colleagues are characterized by their ability to inspire, support, and provide opportunities for people to deliver their best and grow both as professionals and human beings. Know more about Deloitte and our One Young World partnership.Inclusion for allAt Deloitte, people are valued and respected for who they are and are trusted to add value to their clients, teams and communities in a way that reflects their own unique capabilities. Know more about everyday steps that you can take to be more inclusive. At Deloitte, we believe in the unique skills, attitude and potential each and every one of us brings to the table to make an impact that matters. Drive your careerAt Deloitte, you are encouraged to take ownership of your career. We recognise there is no one size fits all career path, and global, cross-business mobility and up / re-skilling are all within the range of possibilities to shape a unique and fulfilling career. Know more about Life at Deloitte.Everyone’s welcome… entrust your happiness to us Our workspaces and initiatives are geared towards your 360-degree happiness. This includes specific needs you may have in terms of accessibility, flexibility, safety and security, and caregiving. Here’s a glimpse of things that are in store for you. Interview tipsWe want job seekers exploring opportunities at Deloitte to feel prepared, confident and comfortable. To help you with your interview, we suggest that you do your research, know some background about the organization and the business area you’re applying to. Check out recruiting tips from Deloitte professionals.