Provide autonomous CRM operations and Power BI reporting support for a contracting executive: maintain Salesforce data hygiene, pull and QA reports, organize multi-state contracts, track key terms, produce market analysis and executive PowerPoint decks, document SOPs, and recommend process improvements.
About the Client
Our client is a national healthcare services organization specializing in specialty infusion and patient-centered care delivered across home and ambulatory settings. Their multidisciplinary teams collaborate to coordinate pharmacy, nursing, and benefits support across multiple U.S. states. They are mission-driven to improve patient outcomes with compassionate, accountable care while scaling partnerships and contracts nationwide.
Why does this role exist?
The client’s contracting/business development executive is stretched thin across multi-state initiatives, including Salesforce CRM hygiene, Power BI reporting, market analysis, SOP documentation, and multi-state contract organization. This role exists to independently run the backend operations—keeping CRM and reporting current, structuring complex payer/contract data, and preparing executive-ready deliverables—so the executive can focus on high-value, revenue-generating work. With active revamps underway across partner organizations, the assistant will provide reliable, proactive support to keep operations moving smoothly.
The Impact you’ll make
Salesforce CRM management and sales operations
- Update contacts, accounts, and opportunities; maintain data hygiene and completeness
- Track pipeline stages, notes, and activities; ensure timely follow-ups and accurate metadata
- Create and maintain basic CRM views/reports; document processes and data definitions
Power BI reporting and analytics
- Pull recurring and ad-hoc reports; refresh datasets and validate numbers against source data
- Create or refine views for presentations; support market comparisons and payer analytics
- QA dashboards for accuracy, filters, and refresh schedules; flag outliers and trends
Contract organization and compliance support
- Organize and index multi-state contracts; standardize naming and folder structures
- Compare Power BI/CRM data to contract folders to ensure alignment and completeness
- Track key contract terms, effective/renewal dates, and requirements; surface upcoming actions
Market analysis and executive presentations
- Compile market research, payer comparisons, and competitor snapshots
- Build executive-level PowerPoint decks with clear narratives and visuals
- Draft and maintain SOPs/process docs that support scale and continuity
Administrative and revamp support
- Provide general administrative support, documentation, and scheduling of deliverables
- Partner with the executive during organizational revamps to capture requirements and updates
- Identify process gaps; recommend small automations or templates to streamline work
Skills, Knowledge and Expertise
Required:
- Proven hands-on Power BI experience (report pulling, basic DAX/Power Query, dashboard refresh/QA)
- CRM operations experience; Salesforce strongly preferred or demonstrable ability to learn quickly
- Advanced Excel/Google Sheets (lookups, pivots, data cleanup) and strong data hygiene discipline
- Prior experience as an executive assistant or operations assistant working autonomously and handling confidential documents
Your superpowers are...
- Technical: Power BI, Salesforce (or similar CRM), Excel/Google Sheets, Google Workspace, Microsoft Office, executive-level PowerPoint, basic data QA; familiarity with AI tools (e.g., Claude) for research/drafting
- Operational: Meticulous organizer who maintains clear folder structures, naming conventions, and SOPs across multi-state work
- Analytical: Comfortable reconciling datasets, spotting inconsistencies, and summarizing insights for decisions
- Communication: Clear, concise writer; proactive status updates; strong stakeholder coordination
- Personal traits: Proactive, critical thinker, problem solver, dependable, and able to execute with minimal supervision
WFH Set-Up:
- Computer with at least 8GB RAM, an Intel i5 core processor/AMD Ryzen 5 Processor and up.
- Internet speed of at least 40MBPS
- Headset with an extended mic that has noise cancellation and a webcam
- Back-up computer and internet connection
- Quiet, dedicated workspace at home
You should apply if...
- You thrive in a healthcare context and enjoy bringing order to complex contract and payer data
- You can independently run recurring reporting/CRM cadences and anticipate what’s needed next
- You’re energized by turning scattered inputs into clear dashboards, SOPs, and executive-ready slides
- You value compassion, accountability, and teamwork, and you’re comfortable partnering closely with a busy executive
What to expect...
Work Setup:
- Remote position
- Must have a reliable internet connection and a quiet workspace
- Required to provide own computer with Intel Core i5 or something similar or higher operating system
Working Hours:
- 40 hours per week
- Monday–Friday, 9:00 am–5:00 pm Central Standard Time
Compensation:
- $7 per hour
- No benefits package included
Benefits
About
Magic has connected top remote talent with fast-growing businesses for over 10 years.Founded in San Francisco in 2015, we now have thousands of remote workers around the world. Magic is backed by Sequoia Capital and Y Combinator.
Similar Jobs
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Lead the CFC CRM product for HCP/HCO-facing colleagues, define roadmap, translate stakeholder needs into prioritized enhancements, write requirements and user stories, partner with engineering, UX, vendors and compliance to deliver scalable global CRM solutions and measure business impact.
Top Skills:
Crm PlatformsLife Sciences CloudOceSalesforceVeeva
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead large Oracle Field Service implementation projects as a Solutions Architect senior manager. Design and deploy Oracle Fusion Service and Field Service Cloud solutions, guide assessment and future-state planning, interact with senior clients, coach teams, apply delivery methodologies and accelerators, and drive continuous improvement.
Top Skills:
Oracle Customer ExperienceOracle EpmOracle Field Service CloudOracle FinOracle Fusion ServiceOracle HcmOracle Lead ManagementOracle Marketing AutomationOracle Sales AutomationOracle Scm
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead end-to-end product lifecycle for internal and commercial software products, drive product strategy and commercialization, collaborate with cross-functional teams, apply Agile methods, coach teams, validate client outcomes, and execute roadmaps and go-to-market plans.
Top Skills:
Agile MethodologyProduct Lifecycle Management
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
