Job Overview
Part of Business Focused IT, candidate needs would be in charge of scaling up and managing an Enterprise-Wide Data Platform that would support the analytical needs of the complete Pharma business(extensible to other businesses as required). The platform should be flexible to support business operations of the future and provide story telling type of intuitive analytics. This position would be a part of the Analytics Center of Excellence.
KEY STAKEHOLDERS: INTERNAL:
Corporate IT, Infra, Business Stakeholders, Site Teams
KEY STAKEHOLDERS: EXTERNAL:
Product Vendors, Consultants, Developers
Reporting Structure
Will report to – Corporate CIO
No of direct reports – 2+
Experience
- 10+ years of relevant experience with business background
- Understanding of principles of data management
- Knowledge in data taxonomies
- Knowledge of data systems and processes
- Similar hands-on experience of setting up data platforms from scratch in
In-depth understanding of Snowflake
- Captive analytics delivery team in a comparable business enterprise
- Experience in designing, building, and optimizing ETL pipelines using tools like Airflow, AWS Glue, PySpark.
- Experience with BI tools like Qlik, Power BI to design interactive dashboards and reporting solution.
Skills & Competencies
- Excellent Written and verbal communication
- Business case development
- Excellent inter-personal skills
- Team Player & team building capabilities
- Budgeting, forecasting & funds management
- Strong connects with OEMs and Cloud players in the space of next generation analytics
- Deep technical expertise in prominent ETL, DB, MDM, Analytical tool(s)
Exposure to SQL
- Strong expertise in Snowflake data platform (data modeling, ETL processes, performance optimization) and AWS services (S3, Glue, Lambda and more).
Key Roles & Responsibilities
- Responsible for developing and maintaining the global data marketplace (data lake)
- Manages the sourcing and acquisition of internal (including IT and OT) & external data sets
- Ensure adherence of data to both enterprise business rules, and, especially, to legal and regulatory requirements
- Define the data quality standards for cross functional data that is used in BI/analytics models/reports
- Provide input into data integration standards and the enterprise data architecture
- Responsible for modelling and designing the application data structure, storage and integration and leading the database analysis, design and build effort
- Review the database deliverables throughout development thereby ensuring quality and traceability to requirements and adherence to all quality management plans and standards
- Develop strategies for data acquisitions, dissemination and archival
- Manage the data architecture within the big data solution such as Hadoop, Cloudera, etc..
- Responsible for modelling and designing the big data structure, storage, integration and leading the database analysis, design, visualization and build effort
- Review the database deliverables throughout development thereby ensuring quality and traceability to requirements and adherence to all quality management plans and standards
- Work with partners and vendors (in a multi-vendor environment) for various capabilities
- Continuously review the analytics stack for improvements – performance improvements, reduce overall TCO through cost optimizations & better the predictive capabilities
- Bring in thought leadership with regards to analytics to make Piramal Pharma an analytics driven business; and help in driving business KPIs
- Preparation of Analytics Platform budgets for both CAPEX and OPEX for assigned initiatives and rolling out the initiatives within budget & projected timelines
- Drive MDM Strategy and Implementation initiative
- Responsible for overall delivery and customer satisfaction for Business services, interaction with business leads, project status management and reporting, implementation management, identifying further opportunities for automation within PPL
- Ensure IT compliance in all project rollouts as per regulatory guidelines
- Conduct Change Management and Impact Analysis for approved enhancements.
- Uphold data integrity requirements following ALCOA+ guidelines.
- Monitor SLAs and KPIs as agreed upon by the business, offering root-cause analysis and risk mitigation action plans when needed.
- Drive awareness & learning across Piramal Pharma in Enterprise Data Platform
Qualification
QUALIFICATIONS
- Graduation from Engineering discipline
- Post Graduate preferable
- Certification/ Degree in Analytics(or related stream) would be an advantage
- Experience in Pharma domain would be an added advantage
About Us
In the three decades of its existence, Piramal Group has pursued a twin strategy of both organic and inorganic growth.
Driven by its core values, Piramal Group steadfastly pursues inclusive growth, while adhering to ethical and values-driven practices.
Equal employment opportunity
Piramal Group is proud to be an Equal Employment Opportunity and Affirmative Action employer. We do not discriminate based upon race, ethnicity, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, genetics, or other applicable legally protected characteristics.
We base our employment decisions on merit considering qualifications, skills, performance, and achievements. We endeavor to ensure that all applicants and employees receive equal opportunity in personnel matters, including recruitment, selection, training, placement, promotion, demotion, compensation and benefits, transfers, terminations, and working conditions, including reasonable accommodation for qualified individuals with disabilities as well as individuals with needs related to their religious observance or practice.
About The Team
Piramal Pharma Limited (PPL) offers a portfolio of differentiated products and services through end-to-end manufacturing capabilities across 15 global facilities and a global distribution network in over 100 countries. PPL includes Piramal Pharma Solutions (PPS), an integrated Contract Development and Manufacturing Organization; Piramal Critical Care (PCC), a Complex Hospital Generics business, and the India Consumer Healthcare business selling over-the-counter products.
PPS offers end-to-end development and manufacturing solutions through a globally integrated network of facilities across the drug life cycle to innovators and generic companies. PCC’s complex hospital product portfolio includes inhalation anaesthetics, intrathecal therapies for spasticity and pain management, injectable pain and anaesthetics, injectable anti-infectives, and other therapies. The Indian Consumer Healthcare business is among the leading players in India in the self-care space, with established brands in the Indian consumer healthcare market. In addition, PPL has a joint venture with Allergan, a leader in ophthalmology in the Indian formulations market. In October 2020, the company received a growth equity investment from the Carlyle Group.
