Senior Business Analyst

EY; Thiruvananthapuram; On-site; INR 3,000,000 - 6,000,000; Full time

Job summary

EY in India seeks a Senior Business Analyst, Assistant Director, with advanced SQL and data warehousing expertise to design end-to-end data integrations. You will collaborate with business stakeholders, data engineers and product teams to convert business requirements into practical data solutions.

Experience with cloud data platforms is a nice-to-have. The role emphasizes gathering complex requirements, designing integrated solutions, and leveraging Talent-related data to support business

Qualifications

• 12+ years of experience in data analytics / BI fields.
• Strong SQL skills for complex queries and data modeling.
• Background in Data Warehousing concepts and ETL processes.

Responsibilities

• Work with stakeholders to collect and define data requirements.
• Translate business needs into integration specifications and data models.
• Lead data quality validation and profiling activities.
• Define KPIs, dashboards, and support reporting requirements.
• Present findings to technical and non-technical audiences.

Skills

SQL

Data Warehousing

ETL

Data Mapping

ISD

Education

Bachelor's degree

SAP SuccessFactors knowledge

Tools

Power BI

Databricks

SAP SuccessFactors

Job description

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

Job Title: Senior Business Analyst, Assistant Director

Role Overview

We seek a Data Business Analyst with advanced skills in SQL, Data Warehousing concepts, ETL processes and Data Mapping. Highly experienced Integration & Data Solutions professional to design, document, and deliver end-to-end data integrations. This role involves working directly with business stakeholders, data engineers, and product teams to convert business requirements into practical data solutions. Experience with cloud data platforms is considered beneficial.

The opportunity

We are seeking an experienced Senior Business Analyst with experience implementing global projects and programs with a high level of competency in Talent systems. The ideal candidate will play a key role in gathering complex requirements, designing integrated solutions, and contributing to the strategic use of Talent data to support business objectives.

Your key responsibilities

• Work with business stakeholders to collect and define data requirements
• Convert business needs into functional specifications, data models, and process flows - Convert business needs into integration specifications, data models, and process flows
• Conduct in-depth data analysis using advanced SQL queries
• Coordinate with ETL and data engineering teams to verify data pipelines and transformations
• Support Data Warehousing projects
• Create and update data mapping documents and source-to-target (S2T) specifications
• Validate, profile, and check data quality to maintain accuracy
• Define KPIs, build dashboards, and support reporting requirements
• Present findings and insights to both technical and non-technical audiences
• Utilize cloud data services (AWS, Azure, GCP) for data ingestion, storage, and processing (nice to have)

Requirements

• 12+ years of experience
• Strong SQL skills for writing complex queries
• Solid understanding of Data Warehousing concepts
• Background in ETL processes and data transformation logic
• Hands-on experience in:
  • ETL processes and data transformation
  • Data mapping and S2T documentation
  • Integration design and documentation (ISD)
• Strong analytical and problem-solving abilities
• Excellent communication and documentation skills

Skills And Attributes For Success

• In-depth knowledge of Talent processes, system functionalities, data integration methodologies, and best practices
• Proficiency in data analysis and tools, database query languages (e.g., SQL), and data visualization tools (e.g., Power BI)
• Strong analytical skills, with the ability to synthesize complex data into actionable insights
• Excellent documentation and presentation skills, with the ability to communicate complex technical concepts to non-technical stakeholders
• Strong project management capabilities, including the ability to lead and manage cross-functional teams
• Positive attitude, adaptability, and the ability to thrive in a dynamic, fast-paced environment
• Results-oriented, with a focus on achieving project objectives and driving positive outcomes
• Strong negotiation and conflict resolution skills
• Ability to work virtually with global teams

To qualify for this role

• Bachelor's degree in a relevant field; additional certifications in business analysis or SAP SuccessFactors preferred
• Proven experience as a Senior Business Analyst with a focus on Talent systems, SAP SuccessFactors, and data integration
• As a Senior Business Analyst, 8 to 10 years of industry experience with exposure to Talent management, HR systems, workforce analytics, or people data initiatives.

Nice to have

• SuccessFactors knowledge.
• Understanding of Databricks.

What We Offer

• Dynamic teamwork: You’ll work with brilliant and innovative professionals who are devoted to building a better working world.
• Continuous learning: You’ll develop the mindset and skills to navigate whatever comes next
• Success as defined by you: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way
• Transformative leadership: We’ll give the insights, coaching and confidence to be the leader the world needs
• Diverse and inclusive culture: You’ll be embraced for who you are and empowered to use your voice to help others find theirs

EY | Building a better working world

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets. Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate. Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.