ENVIRONMENT:

DRIVE strategic business outcomes while translating complex business requirements into scalable technical solutions as the next Technical Lead sought by a dynamic Healthcare Platform. You will serve as the primary technical expert and customer liaison for data management, business intelligence, and analytics solutions within Pharmaceutical organizations. The ideal candidate will have extensive experience in Pharmaceutical data ecosystems, strong technical capabilities across Microsoft Azure, Azure Data Factory, and Databricks & SQL Server BI stack, and modern data platforms, with the proven ability to translate complex business requirements into scalable technical solutions that drive strategic business outcomes.

DUTIES:

Client Engagement & Project Leadership -

• Serve as primary technical point of contact for pharmaceutical clients on all data management and analytics deliverables.
• Lead direct negotiations with customers on timelines, technical requirements, resources, and project scope.
• Provide strategic guidance to Sales teams, Market Access teams, and Marketing Departments on leveraging data assets.
• Lead ad-hoc business deep dive analysis and present findings to senior leadership.
• Collect, analyse, and share data to help make strategic product decisions.
• Manage service performance metrics and implement continuous process improvements.
• Serve as escalation point for complex technical and data-related issues.

Data Warehousing & BI Solutions -

• Specify, design, build, and support data warehousing and business intelligence solutions.
• Design and maintain data models used for reporting and analytics.
• Create dashboards and KPIs to show business performance to management.
• Build various data visualizations to tell the story of trends, patterns, and outliers.
• Monitor and tune BI tools to ensure optimum level of performance.
• Ensure data accuracy by validating data for new and existing tools.
• Support upgrades, configuration and troubleshooting for business intelligence tools.
• Modify existing reports, extracts, and dashboards as necessary.

Technical Solution Design & Development -

• Design and implement end-to-end data solutions using Azure SQL, Azure Data Factory, and Databricks.
• Develop complex SQL queries, stored procedures, and data transformation logic for pharmaceutical datasets.
• Build ETL/ELT pipelines using SSIS and Azure Data Factory to integrate data from multiple pharmaceutical sources.
• Create analytical reports and dashboards using SSRS, Power BI, and other visualization tools.
• Develop Python and R-based data processing and analytics solutions.
• Design and implement cloud infrastructure solutions with focus on Azure networking and security.
• Optimize Databricks workflows for large-scale pharmaceutical data processing.
• Responsible for program design, coding, testing, debugging and documentation.
• Own the design and development of automated solutions for recurring reporting and in-depth analysis.
• Develop and execute ad hoc queries upon request for data.

Analytics & Strategic Insights -

• Help the broader team identify new features and business opportunities through your analysis.
• Identify development needs to improve and streamline operations.
• Conduct comprehensive Data Analysis to support strategic decision-making.
• Translate complex analytical findings into actionable business recommendations.

Pharmaceutical Domain Expertise -

• Demonstrate deep understanding of pharmaceutical commercial operati