About the Role
Axtria helps leading life sciences companies modernize their commercial data and AI platforms. Our AI & Data practice is growing its Snowflake capability to support large-scale programs that move legacy cloud and on-premise data stacks to modern, governed, AI-ready commercial data platforms serving brand analytics, field reporting, incentive compensation, and downstream consuming applications.
Role overview
We are seeking a Functional Lead for a strategic transformation program modernizing an enterprise pharmaceutical data platform on Snowflake and enabling governed, trusted, AI-ready data products.
The Functional Lead will serve as the primary bridge between business stakeholders, data owners, and technology teams. This person will translate business needs into clear functional requirements, define data products and business rules, and ensure that migration and enhancement releases support downstream business processes accurately.
The role requires strong pharmaceutical domain knowledge, hands-on data analysis skills, and experience leading requirements, validation, and stakeholder alignment across complex enterprise programs.
Key responsibilities
- Business engagement and functional ownership
- Lead discovery workshops with Commercial, Sales Operations, Marketing, Market Access, Medical, and Analytics stakeholders.
- Understand existing business processes, data consumption patterns, pain points, and future requirements.
- Translate business needs into functional specifications, user stories, process flows, and measurable acceptance criteria.
- Data product definition and business semantics
- Lead functional definition of data products covering customer engagement, brand performance, patient dynamics, payer and market access, and related domains.
- Define business entities, data grain, dimensions, measures, relationships, refresh expectations, and consumption requirements.
- Partner with architects and engineers on source-to-target mappings and functional review of data models.
- Maintain alignment across source systems, common data layers, curated data products, and downstream applications.
- Business rules and data quality
- Document and validate transformation, alignment, affiliation, attribution, aggregation, and exception-handling rules.
- Partner with business owners and data stewards to define data quality checks, thresholds, severity, and business impact.
- Translate recurring data issues into improvements to requirements, controls, and operating processes.
- Migration reconciliation and user acceptance testing
- Lead functional impact assessments for migration from the existing AWS/Redshift platform to Snowflake.
- Identify downstream dependencies across reporting, incentive compensation, forecasting, analytics, and other consumption use cases.
- Define reconciliation criteria and acceptable variances for source-to-target validation and parallel runs.
- Own user acceptance testing (UAT) planning and coordination, including business scenarios, expected results, defect prioritization, and readiness tracking.
- Support cutover decisions and post-release validation through documented functional readiness.
- Delivery governance and stakeholder management
- Own the functional backlog and coordinate priorities with product owners, program leadership, and engineering leads.
- Assess change requests for business value, dependencies, downstream impact, and acceptance requirements.
- Maintain functional decisions, assumptions, dependencies, and risks.
- Lead functional reviews and communicate issues and decisions clearly to business and technical audiences.
- Guide business analysts and functional subject matter experts across onshore and offshore teams.
- Consumer adoption and operational readiness
- Partner with change management teams on consumer impact assessments, migration guidance, FAQs, and training content.
- Explain changes to data structures, business rules, KPIs, access, and consumption processes.
- Ensure operations teams receive complete functional documentation, exception scenarios, and support guidance.
- Support business adoption and incorporate consumer feedback into the enhancement backlog.
- Required qualifications and experience
- Significant experience in pharmaceutical commercial data, analytics, or enterprise data platform programs.
- Strong understanding of several relevant domains: sales and prescription data, claims, customer master, affiliations, territory alignment, field activity, incentive compensation, payer data, or omnichannel engagement.
- Demonstrated experience leading business requirements and functional delivery across multiple stakeholder groups.
- Experience defining data products, business rules, KPI logic, data mappings, and data quality requirements.
- Hands-on SQL proficiency for data profiling, validation, reconciliation, and issue investigation.
- Working knowledge of Snowflake, cloud data platforms, dimensional modeling, and data integration concepts.
- Experience leading UAT and business acceptance for data migration or modernization programs.
- Strong communication, workshop facilitation, analytical problem-solving, and stakeholder management skills.
- Experience coordinating delivery across distributed business, engineering, QA, and operations teams.
- Bachelor’s degree in engineering, computer science, information systems, business, or a related field.
Preferred qualifications
- Experience with pharmaceutical datasets and platforms such as IQVIA, claims providers, Veeva CRM, and Reltio.
- Exposure to AWS, Redshift, and Snowflake.
- Experience with data catalogs, lineage, stewardship, business glossaries, and semantic layers.
- Familiarity with AI-assisted data quality, business rule management, and natural-language analytics.
- Experience supporting governed access to sensitive healthcare and commercial data.
- Prior consulting or client-facing leadership experience in large pharmaceutical organizations.
- Success measures
- Clear, approved requirements and business rules with limited downstream rework.
- Consistent definitions across data products, KPIs, and consuming applications.
- Timely UAT completion and documented business acceptance.
- Successful migration reconciliation with explained and approved variances.
- Fewer production defects caused by gaps in functional requirements or business logic.
- Effective consumer adoption and smooth transition to operations.
Pay Transparency Laws
Salary range or hourly pay range for the position
The salary range for this position is $131,200 to $174,975 annually. The actual salary will vary based on applicant’s education, experience, skills, and abilities, as well as internal equity and alignment with market data. The salary may also be adjusted based on applicant’s geographic location.
The salary range reflected is based on a primary work location of Berkeley Heights, New Jersey. The actual salary may vary for applicants in a different geographic location.
Job description provided by Axtria.
View the original posting