Technical Solutions Manager

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