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
Big Data • Fintech • Mobile • Payments • Financial Services
Design and implement CIAM backend services for registration, authentication, and account management across B2C and B2B platforms, utilizing security standards and automation practices.
Top Skills:
AWSCi/CdGitKotlinOauth 2.0OidcPythonSAMLScimTerraform
Big Data • Fintech • Mobile • Payments • Financial Services
This role involves leading strategic finance initiatives, influencing revenue strategies, managing financial planning, and developing models for user growth and monetization in a fast-paced environment.
Top Skills:
Data Visualization ToolsSQL
.png)
Cloud • Insurance • Payments • Software • Business Intelligence • App development • Big Data Analytics
The Enterprise Account Executive will focus on acquiring new business in the insurance sector, managing client relationships, and collaborating with sales teams to enhance reach.
Top Skills:
CRMSalesforce
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
