Associate Consultant, Gurgaon, India

Technical Responsibilities

• Design and build full-stack forecasting and simulation platforms using modern web technologies (e.g., React, Node.js, Python) hosted on AWS infrastructure (e.g., Lambda, EC2, S3, RDS, API Gateway).
• Automate data pipelines and model workflows using Python for data preprocessing, time-series modeling (e.g., ARIMA, Exponential Smoothing), and backend services.
• Develop and enhance product positioning, messaging, and resources that support the differentiation of Viscadia from its competitors. Conduct research and focus groups to elucidate key insights that augment positioning and messaging
• Replace legacy Excel/VBA tools with scalable, cloud-native applications, integrating dynamic reporting features and user controls via web UI.
• Use SQL and cloud databases (e.g., AWS RDS, Redshift) to query and transform large datasets as inputs to models and dashboards.
• Develop interactive web dashboards using frameworks like React + D3.js or embed tools like Power BI/Tableau into web portals to communicate insights effectively.
• Implement secure, modular APIs and microservices to support modularity, scalability, and seamless data exchange across platforms.
• Ensure cost-effective and reliable deployment of solutions via AWS services, CI/CD pipelines, and infrastructure-as-code (e.g., CloudFormation, Terraform).

Business Responsibilities

• Support the development and enhancement of forecasting and analytics platforms tailored to the needs of pharmaceutical clients across various therapeutic areas
• Build in depth understanding of pharma forecasting concepts, disease areas, treatment landscapes, and market dynamics to contextualize forecasting models and inform platform features
• Partner with cross-functional teams to ensure forecast deliverables align with client objectives, timelines, and decision-making needs
• Contribute to a culture of knowledge sharing and continuous improvement by mentoring junior team members and helping codify best practices in forecasting and business analytics
• Grow into a client-facing role, combining an understanding of commercial strategy with forecasting expertise to lead engagements and drive value for clients

• Bachelor’s degree (B.Tech/B.E.) from a premier engineering institute, preferably in Computer Science, Information Technology, Electrical Engineering, or related disciplines
• 2+ years of experience in full-stack development, with a strong focus on designing, developing, and maintaining AWS-based applications and services

Technical Skills

• Proficient in Python, with practical experience using libraries such as pandas, NumPy, matplotlib/seaborn, and statsmodels for data analysis and statistical modeling
• Strong command of SQL for data querying, transformation, and seamless integration with backend systems
• Hands-on experience in designing and maintaining ETL/ELT data pipelines, ensuring efficient and scalable data workflows
• Solid understanding and applied experience with cloud platforms, particularly AWS; working familiarity with Azure and Google Cloud Platform (GCP)
• Full-stack web development expertise, including building and deploying modern web applications, web hosting, and API integration
• Proficient in Microsoft Excel and PowerPoint, with advanced skills in data visualization and delivering professional presentations

Soft Skills

• Excellent verbal and written communication skills, with the ability to effectively engage both technical and non-technical stakeholders
• Strong analytical thinking and problem-solving abilities, with a structured and solution-oriented mindset
• Demonstrated ability to work independently as well as collaboratively within cross-functional teams
• Adaptable and proactive, with a willingness to thrive in a dynamic, fast-growing environment
• Genuine passion for consulting, with a focus on delivering tangible business value for clients

Domain Expertise (Good to have)

• Strong understanding of pharmaceutical commercial models, including treatment journeys, market dynamics, and key therapeutic areas
• Experience working with and interpreting industry-standard datasets such as IQVIA, Symphony Health, or similar secondary data sources
• Familiarity with product lifecycle management, market access considerations, and sales performance tracking metrics used across the pharmaceutical value chain