Business Data Analyst (SQL, ETL & Data Modeling) | EY | Bangalore or NCR

EY; Indien; Remote; INR 1.200.000 - 1.800.000; Vollzeit

Zusammenfassung

EY Technology Consulting in India seeks an experienced Business Data Analyst to own data modeling, ETL design, and cross-functional engineering, with responsibilities spanning analytics solution delivery and scalable ETL/DWH pipelines. You will work with SQL, Python, and BI tools, collaborating with stakeholders and product squads.

Notice period flexibility (Nov/Dec or immediate joiners) is preferred, with eligibility for Bangalore or NCR relocation.

Qualifikationen

• BS or MS in CS, Analytics, IT, Statistics, or related field.
• 4+ years of hands-on data analysis and analytics solutions.
• Strong SQL, ETL data warehousing, and data modeling experience.
• Practical Python and BI tools (Power BI, Tableau).
• Ability to communicate technical findings to executives.
• Notice period availability Nov/Dec or immediate joiners.
• Legal work authorization and willingness to work in Bangalore or NCR.

Aufgaben

• Conduct comprehensive business and data analysis to support analytics solutions.
• Design, develop, and maintain robust ETL pipelines and enterprise data warehouse architectures.
• Architect and optimize logical/physical data models, star/snowflake schemas.
• Write complex SQL queries, stored procedures, and data scripts for large data sets.
• Integrate Python scripts and BI analytics for enhanced reporting.
• Collaborate with cross-functional teams and stakeholders.
• Ensure data quality, privacy compliance, and security standards.
• Translate requirements into scalable data architectures and dashboards.
• Maintain technical documentation, data dictionaries, and ETL runbooks.
• Participate in client workshops, sprint planning, and design reviews.

Kenntnisse

SQL proficiency

ETL design

Data modeling

Python programming

BI analytics

Stakeholder communication

Ausbildung

Bachelor's or Master's in CS/Analytics/IT/Statistics

Tools

Snowflake

Azure Synapse

AWS Redshift

dbt

Airflow

Jira

Confluence

Jobbeschreibung

Position Summary

Driving advanced business data analysis, ETL pipeline architecture, enterprise data warehousing, and digital transformation in Bangalore or NCR (open for relocation), EY (Ernst & Young) Technology Consulting is actively seeking experienced Business Data Analysts with 4+ years of professional experience for a permanent full-time engagement, prioritizing professionals currently serving notice (Nov/Dec or immediate joiners). In this vital data and business intelligence role, you will take full operational, tactical, and technical ownership of data analysis, data warehousing (DWH), ETL workflows, data modeling, BI analytics solutions building, and cross-functional product development. Bringing strong technical proficiency in SQL, ETL architectures, and data modeling—coupled with preferred industry experience in Pharma, CPG, or Retail—you will empower an elite global technology consulting enterprise to achieve uncompromised data integration, high-performance reporting pipelines, and superior business decision-making.

Detailed Job Description

As a Business Data Analyst supporting EY Technology Consulting on a professional basis in Bangalore or NCR (open for relocation), you will take full operational, tactical, and technical ownership of data modeling, ETL design, business analysis, and cross-functional engineering collaboration. Your day-to-day responsibilities include designing, developing, and deploying robust data and analytics solutions, building scalable ETL/DWH pipelines, architecting logical and physical data models utilizing strong SQL proficiency, incorporating Python or BI analytics capabilities where required, collaborating proactively with business stakeholders, product development squads, and technical recruitment leadership like Rohil Gandhi at EY, adhering to strict corporate data governance standards, ensuring alignment with notice period availability (serving notice in Nov/Dec or immediate joiners preferred).

Key Responsibilities

• Conduct comprehensive business and data analysis to support enterprise analytics solutions and product building initiatives.
• Design, develop, and maintain robust ETL (Extract, Transform, Load) pipelines and enterprise data warehouse (DWH) architectures.
• Architect and optimize logical and physical data models, star schemas, snowflake schemas, and relational database structures.
• Write highly complex SQL queries, stored procedures, and data transformation scripts for high-volume datasets.
• Integrate Python scripts and Business Intelligence (BI) analytics frameworks to enhance reporting capabilities.
• Collaborate proactively with cross-functional consulting, product development, and client stakeholder squads.
• Ensure strict adherence to data quality standards, privacy regulations, and enterprise security compliance frameworks.
• Translate complex business requirements into scalable data architectures and actionable reporting dashboards.
• Maintain meticulous technical documentation, data dictionary records, ETL runbooks, and version control repositories.
• Participate actively in client discovery workshops, sprint planning, and architectural design reviews.

Required Qualifications & Skills

• Bachelor’s or Master’s degree in Computer Science, Business Analytics, Information Technology, Statistics, or a related technical discipline.
• Minimum of 4+ years of progressive professional hands-on experience in data analysis, business analysis, and data/analytics solutions.
• Strong, demonstrable operational proficiency in advanced SQL, ETL data warehousing, and relational data modeling.
• Comprehensive working knowledge and practical hands-on experience with product building and analytics solution development.
• Solid practical grasp of Python programming and BI analytics tools (Power BI, Tableau) as strong complementary skills.
• Proven ability to manage end-to-end data integration projects and communicate technical findings to executive stakeholders.
• Serving notice period availability (Nov/Dec or immediate joiners preferred).
• Mandatory legal work authorization and physical availability for professional operations in Bangalore or NCR (open for relocation).

Nice-to-Have Skills

• Prior professional working experience in domain verticals such as Pharmaceuticals, Consumer Packaged Goods (CPG), or Retail industries.
• Professional vendor certifications such as AWS Certified Data Analytics, Microsoft Certified: Azure Data Engineer, or TOGAF Architecture.
• Hands-on familiarity with cloud data platforms (Snowflake, Azure Synapse, AWS Redshift) and modern data stack tools (dbt, Airflow).
• Experience utilizing enterprise agile tracking and IT service desk platforms (Jira, Confluence, ServiceNow).
• Active participation in data architecture user groups, business intelligence forums, or technical conferences.

Application Information

• Recruiter: EY Technology Consulting Recruitment Division
• Contact Name: Rohil Gandhi - Senior Manager - Technology Consulting - I Data & AI
• Email: [e-mail]
• Company Website: https://www.ey.com
• Salary/Rate: Market Competitive / Enterprise Data Consulting Package
• Work Schedule: Professional Consulting Operations (Bangalore or NCR / Open for Relocation)
• Deadline: Open until filled (Urgent Business Data Analyst Opening)
• Notice Period: Serving Notice Period (Nov/Dec or Immediate Joiners Preferred)
• Contract Duration: Permanent / Full-Time Employment