Data Analyst (Only W2)

Job Title: Data Analyst Job# AMAGJP00015019 Location: Thousand Oaks, CA (100% Remote, worker MUST physically reside within U.S. for the entire duration of the contract assignment) Terms: Contract W2 Duration: 12 Months Contract (Will Get Extended for Long) Intake notes: I want to highlight Prior Challenges for hiring this role Previous candidates lacked hands-on expertise with required data tools Manager does not have capacity to train a junior or learning-on-the-job candidate candidates could not “speak data” or execute independently Resulted in delayed deliverables and no meaningful output Required Tools & Technologies (Non-Negotiable) Must Have (Hands-On, Expert Level): • Power BI • Power Automate • Power Apps • Excel (advanced) • SharePoint (including SharePoint Lists) Strongly Preferred / Nice to Have: • Tableau, Spotfire (at least one visualization tool required) • Smartsheet • UI Path (not a deal breaker) • Microsoft ecosystem fluency overall Candidates must demonstrate real-world, hands-on usage, not theoretical or surface-level familiarity. Core Skill Expectations • Advanced data literacy (able to understand and communicate data concepts clearly) • Strong process automation capability • Ability to work independently with minimal direction • Fast execution and responsiveness • Ability to manage multiple concurrent analytics asks • Comfort owning projects end-to-end after onboarding period Industry & Domain Preferences • Preferred industries: o Biopharmaceutical o Biotech o Medical Device • Functional experience a plus: o R&D o Supply Chain / Supplier Management Candidate Experience Bachelor’s degree required Minimum 2+ years of relevant experience (more experience is acceptable) No upper cap on experience level Skill Sets: 1. Data Visualization & Analytics – Proficiency in Power BI and Tableau (or Spotfire), with the ability to create clear, compelling dashboards and visualizations that drive insight and action. 1. Data Transformation & Management – Strong experience processing, filtering, cleaning, standardizing, and restructuring large datasets, including the ability to pivot and reform data based on evolving business needs (e.g., MS Lists, Power Apps) 1. Automation, AI & Advanced Tools – Experience with process automation (e.g., Power Automate, UiPath), applied AI use cases, and strong working knowledge of Microsoft Excel. 1. Experience in biotech, biopharma, medical device OR R&D environments is a strong plus (Will consider first during hiring processes) Description: Fully remote Location Preference: US-based only; West Coast preferred but not required Seeking a hands-on Data Analyst with strong experience in the Microsoft analytics ecosystem to support R&D Business Operations. The ideal candidate has proven expertise using Power BI, Power Automate, Power Apps, Excel, and SharePoint to pull, clean, automate, and visualize complex datasets. This role requires real-world execution skills, not entry-level or theoretical experience. Candidates should be able to independently build automated data comparisons, dashboards, alerts, and master datasets, and deliver analytics solutions quickly. Candidates will complete a practical data exercise as part of the interview process to validate technical proficiency. The position focuses on using data, automation, and process innovation to optimize supplier management, enhance operational workflows, and support business decisions. Working closely with cross-functional stakeholders, this role will develop digital tools, monitor supplier performance metrics, and drive efficiency through AI and automation initiatives. This is a hands-on manager role that blends technical innovation, process optimization, and project coordination, with a clear mandate to deliver measurable improvements in supplier oversight and business outcomes. Preferred Traits • Passion for exploring, organizing, and making sense of large and complex datasets • Strong intellectual curiosity with the ability to learn new concepts, scripts, tools, and analytical methods • Ability to manage multiple, competing priorities simultaneously • Proven ability to deliver work in an organized, accurate, and on-time manner • Comfort working in highly collaborative, cross-functional environments Day to Day Responsibilities: • Design, build, and maintain dashboards and visualizations to support supplier performance tracking and business insights • Prototype and customize analytical applications, often leveraging outputs from data science models • Partner closely with business stakeholders to iteratively refine analyses and dashboard designs • Collaborate with IS and Data Engineering teams to ensure data models and pipelines are robust and aligned with business requirements • Develop, monitor, and report on supplier performance metrics • Identify and implement opportunities for automation and AI-driven solutions to improve workflows and decision-making • Explore and evaluate new tools, techniques, and methodologies to enhance analytics and data processing capabilities • Coordinate analytics and automation initiatives to ensure timely, high-quality delivery