Ernst & Young Advisory Services Sdn Bhd
EY - GDS Consulting - AI and DATA - Excel Model Developer - Senior
Ernst & Young Advisory Services Sdn Bhd, Saint Paul, Minnesota, United States
EY - GDS Consulting - AI and DATA - Excel Model Developer - Senior
Location: Pune
Other locations: Primary Location Only
Date: Sep 18, 2025
Requisition ID: 1613717
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.
Responsibilities
Develop data models using Excel, VBA and Python to support analytics and reporting; automate processes to streamline data manipulation and visualization.
Translate large datasets into actionable insights and drive business decision making through robust modeling and analytics.
Design and implement complex Excel workbooks with advanced formulas, macros and automation features.
Collaborate with cross-functional teams to understand data requirements and deliver scalable analytics solutions.
Qualifications
Strong analytical skills with experience working with large datasets to derive meaningful insights.
Experience applying statistical methods to analyze trends and patterns to support decision making.
Extensive experience developing models using Excel VBA and Python; optimizing data analysis and reporting processes.
Proven ability to design and implement complex Excel spreadsheets with advanced formulas, macros and automation.
Power Apps and Pharma Knowledge
Familiarity with Power Apps to build custom applications that enhance data interactivity and integrate with Excel-based models.
Understanding of pharmaceutical industry data types (e.g., HER, laboratory data, patient-reported outcomes) and regulatory considerations; ability to develop compliant models.
Data Analysis and SQL Proficiency
Proven experience in data analysis and manipulation using SQL; ability to write complex queries for data extraction, transformation and loading (ETL).
Skilled in data cleansing and preparation for modeling to ensure data accuracy and integrity.
Technical Skills
Modelling tools: Excel, VBA
Data analysis: SQL, Excel (advanced functions, pivot tables)
Statistical techniques: descriptive statistics, trend analysis, predictive modeling
Data sources: familiarity with pharmaceutical data sources including clinical trial databases and laboratory information systems
EY | Building a better working world
"route" is used for session stickiness; "careerSiteCompanyId" is used to send the request to the correct data center; "JSESSIONID" is placed on the visitor device during the session so the server can identify the visitor. EY refers to the global organization and may refer to one or more of the member firms of Ernst & Young Global Limited. Ernst & Young Global Limited is a UK company limited by guarantee and does not provide services to clients.
#J-18808-Ljbffr
Other locations: Primary Location Only
Date: Sep 18, 2025
Requisition ID: 1613717
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.
Responsibilities
Develop data models using Excel, VBA and Python to support analytics and reporting; automate processes to streamline data manipulation and visualization.
Translate large datasets into actionable insights and drive business decision making through robust modeling and analytics.
Design and implement complex Excel workbooks with advanced formulas, macros and automation features.
Collaborate with cross-functional teams to understand data requirements and deliver scalable analytics solutions.
Qualifications
Strong analytical skills with experience working with large datasets to derive meaningful insights.
Experience applying statistical methods to analyze trends and patterns to support decision making.
Extensive experience developing models using Excel VBA and Python; optimizing data analysis and reporting processes.
Proven ability to design and implement complex Excel spreadsheets with advanced formulas, macros and automation.
Power Apps and Pharma Knowledge
Familiarity with Power Apps to build custom applications that enhance data interactivity and integrate with Excel-based models.
Understanding of pharmaceutical industry data types (e.g., HER, laboratory data, patient-reported outcomes) and regulatory considerations; ability to develop compliant models.
Data Analysis and SQL Proficiency
Proven experience in data analysis and manipulation using SQL; ability to write complex queries for data extraction, transformation and loading (ETL).
Skilled in data cleansing and preparation for modeling to ensure data accuracy and integrity.
Technical Skills
Modelling tools: Excel, VBA
Data analysis: SQL, Excel (advanced functions, pivot tables)
Statistical techniques: descriptive statistics, trend analysis, predictive modeling
Data sources: familiarity with pharmaceutical data sources including clinical trial databases and laboratory information systems
EY | Building a better working world
"route" is used for session stickiness; "careerSiteCompanyId" is used to send the request to the correct data center; "JSESSIONID" is placed on the visitor device during the session so the server can identify the visitor. EY refers to the global organization and may refer to one or more of the member firms of Ernst & Young Global Limited. Ernst & Young Global Limited is a UK company limited by guarantee and does not provide services to clients.
#J-18808-Ljbffr