FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in analytics within the pharmaceutical market access domain, utilizing MySQL and advanced Excel for data manipulation and analysis. Capable of translating complex business needs into actionable data methodologies and insights while ensuring quality control and validation of deliverables.
Highest-signal resume keywords
8+ Years Analytics ExperienceMySQL Querying And ValidationPharmaceutical Market Access KnowledgeAdvanced Microsoft Excel SkillsClient Communication And Presentation Skills
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data AnalysisData ValidationAnalytical MethodologiesData IntegrationData Quality AssuranceTroubleshooting MySQL QueriesData Requirements TranslationAI Data Process StreamliningFormulary Coverage AnalysisPharmaceutical Data Expertise
Soft Skills
Critical ThinkingProblem SolvingCross-Functional CollaborationClient CommunicationPresentation Skills
Tools & Technologies
MySQLMicrosoft ExcelPower BISVNGitPerforceIQVIAMMITSymphony HealthVeeva
Industry Keywords
PharmaceuticalLife SciencesMarket AccessManaged MarketsPayer StructuresUtilization ManagementHCP DataClaims DataGeographic AttributionPBM Relationships
Tech Stack
Tools & technologiesMySQLSubversion
About the role
Key responsibilities & impact- Lead timely implementation of data solutions for proprietary market access products, field-facing tools, and custom client analytics
- Integrate and analyze formulary and coverage data, prescription and medical claims, HCP data, payer and plan hierarchies, lives, geographic alignment, and CRM data
- Translate complex business questions into analytical methodologies, business rules, data requirements, and scalable solutions
- Use MySQL, advanced Microsoft Excel, Power BI, and other analytical tools to manipulate, integrate, analyze, and validate large datasets
- Apply pharmaceutical reimbursement knowledge to develop market access solutions
- Develop methodologies translating market access data into HCP-, account-, payer-, geographic-, and national-level insights and field-facing messages
- Own quality control and validation of methodologies and client deliverables
- Serve as analytics and market access subject matter expert across requirements, development, testing, validation, launch, migrations, refreshes, and enhancements
- Partner with development, UX, account, strategy, production, and external data-provider teams
- Serve as senior analytics subject matter expert in client meetings and pre- and post-sale discussions
- Establish repeatable processes and standards for analytical rigor and quality
- Investigate data, troubleshoot MySQL queries, perform Excel analyses, validate methodologies, and resolve complex data challenges
Requirements
What you’ll need- 8+ years of analytics experience within pharmaceutical, life sciences, market access, managed markets, or a closely related data environment
- Understanding of pharmaceutical market access and reimbursement, including commercial, Medicare, and Medicaid channels, payer and plan structures, formulary coverage, and utilization management
- Significant experience with pharmaceutical data, including formulary/coverage, prescription or medical claims, HCP, payer/plan, and lives data
- 5+ years of hands-on MySQL skills, including querying, joining, transforming, aggregating, troubleshooting, and validating large datasets
- Advanced Microsoft Excel skills and ability to analyze, validate, and present complex data
- Experience harnessing AI to streamline data processes
- Experience designing analytical methodologies and translating business needs into detailed data and product requirements
- Understanding of data quality, integration, attribution, aggregation, and validation methodologies
- Experience using a revision control system in a production environment, such as SVN, Git, or Perforce
- Exceptional client communication and presentation skills for non-technical audiences
- Ability to collaborate cross-functionally and manage multiple complex workstreams
- Strong critical-thinking and problem-solving skills
- Bachelor's degree required
- STEM degree, advanced degree, or equivalent experience preferred
- Preferred: Experience with IQVIA, MMIT, Symphony Health, or similar pharmaceutical data platforms
- Preferred: Experience developing HCP- or account-level market access analytics and field-facing solutions
- Preferred: Familiarity with Veeva or other pharmaceutical CRM/field enablement platforms
- Preferred: Experience with payer hierarchies, PBM relationships, geographic attribution, HCP alignment, product launches, or major data migrations
Benefits
Comp & perks- Competitive benefits package
- Tools and support needed to succeed
- Autonomy to seek out new paths and better ways of doing things
- Support from expert colleagues across the Ogilvy network
- Opportunities to do meaningful work with supportive teammates
- Equal opportunity workplace
- Reasonable accommodation during the application process