About Medallion

As one of the fastest-growing healthcare technology companies—ranked No. 3 on Inc. Magazine’s 2024 Fastest-Growing Private Companies in the Pacific Region, No. 5 on LinkedIn's 2024 Top Startups in the US, a Glassdoor Best Place to Work in 2024 & 2025, and featured on The Today Show—Medallion is revolutionizing provider network management. Our CEO, Derek Lo, has been named one of the Top 50 Healthcare Technology CEOs of 2024 by The Healthcare Technology Report. Backed by $85M in funding from world-class investors like Sequoia Capital, Google Ventures, Optum Ventures, and Salesforce Ventures, we’re on a mission to transform healthcare at scale.

We prioritize candidate safety. Please be aware that official communication will only come from @medallion.co email addresses.

About the role:
As part of your role, you will engage hands-on with customers during a critical phase in their customer journey and collaborate with colleagues in Customer Success, Operations, EPD, and Sales. You will work with complex and varied client data models, quickly assess data quality, and build tailored solutions to meet each client’s migration needs.You will also build evergreen integrations between internal and external systems to support workflow automation.

This role reports to the Head of Technical solutions and base compensation may land between $125,000-$165,000. In addition to base salary, Medallion offers equity, and benefits as part of the total compensation package. Many factors are considered when determining pay including: market data, geographic location, skills, qualifications, experience, and level.

Responsibilities:

• Support our largest customers to strategize how they will migrate their existing data to Medallion
• Owning the end-to-end data migration process, including data extraction from legacy systems, cleansing, transformation, and loading into target platforms
• Engaging directly with clients or stakeholders to gather data requirements, resolve data discrepancies, and communicate migration progress or risks
• Become the SME on our customers’ data while tracking milestones throughout the implementation
• Build evergreen integrations from scratch to support the automation of workflows
• Write SQL queries for data extraction, transformation, and reporting, with a focus on clean, maintainable code
• Work with complex and varied client data models, quickly assess data quality, and build tailored solutions to meet each client’s migration needs
• Set customer expectations/timelines, perform data validation, and migrate complex datasets into Medallion
• Identify any blockers that could delay an implementation; partner with the appropriate internal and external teams to resolve
• Build Python-based automation scripts for data ingestion, transformation, reconciliation, and migration validation
• Partner with the EPD team to productize repetitive aspects of implementations that can be automated

Requirements:

• 6+ years of experience in data modeling and/or migration, ideally with complex data sets
• 4+ years of experience working directly with enterprise clients
• Proven experience writing complex SQL queries and Python scripts, not just modifying existing code
• • Additional coding languages are a plus
• Ability to build bi-directional integrations between external and internal platforms
• Ability to design, build, and optimize queries and data pipelines end-to-end, including data extraction, transformation, and loading (ETL) processes
• Familiarity with relational databases (PostgreSQL, MySQL, SQL Server, or Oracle) in a migration or data pipeline context
• Experience at a rapidly growing SaaS company, ideally at a B2B startup
• Ability to motivate and maintain enthusiasm throughout the onboarding engagement
• Experience in coordinating multiple complex data projects simultaneously