Opendate Logo

Opendate

Data Migration / Integrations Specialist

Reposted 28 Days Ago
In-Office or Remote
Hiring Remotely in Chicago, IL
Junior
In-Office or Remote
Hiring Remotely in Chicago, IL
Junior
Own customer data migration projects end-to-end: review, clean, map, import, validate, and QA records (events, tickets, customers, orders, donations, opt-ins, seating). Troubleshoot and monitor integrations (POS, CRM, marketing, reporting) using SQL, CSVs, APIs, webhooks, logs and admin tools. Build repeatable playbooks, documentation, and processes to reduce engineering dependency and ensure production data accuracy.
The summary above was generated by AI

About the Role

The Data Migration / Integrations Specialist will own the operational and technical work required to move customers onto Opendate and keep key integrations running reliably. This role sits at the intersection of customer onboarding, data operations, support, product, and engineering.

You will work with exports from legacy systems, clean and validate data, import events, customers, orders, donations, holds, ticket types, seating-related data, marketing opt-ins, and historical records, and help troubleshoot integrations with systems like POS, marketing platforms, CRM tools, reporting tools, and third-party ticketing/distribution partners.

This is a great fit for someone who is detail-oriented, technically curious, comfortable with messy data, and able to communicate clearly with both internal teams and customers.

What You’ll Do

Data Migration & Customer Onboarding

  • Own customer data migration projects from kickoff through QA and launch.
  • Review customer exports from legacy ticketing, CRM, POS, and marketing systems.
  • Clean, normalize, and map data into Opendate’s structure.
  • Import and validate records such as:
     
    • Events and recurring events
    • Ticket types and pricing
    • Customers, fans, and contacts
    • Orders, donations, and transaction history
    • Marketing opt-ins and audience segments
    • Holds, comps, guest lists, and venue-specific notes
    • Seating-related data where applicable
  • Build repeatable migration checklists, QA processes, and rollback plans.
  • Identify data inconsistencies before they become customer-facing issues.
  • Partner with customer success and implementation teams to ensure customers understand what was imported, where it lives, and how to use it.

Integrations Support

  • Help configure, monitor, and troubleshoot integrations across Opendate’s ecosystem.
  • Support integrations involving systems such as POS, marketing tools, CRM platforms, calendars, reporting tools, SMS/email tools, advertising pixels, and distribution partners.
  • Investigate sync failures, missing records, duplicate records, broken mappings, stale data, and API/webhook issues.
  • Work with engineering to diagnose root causes and escalate issues with clear reproduction steps, logs, examples, and business impact.
  • Help define integration requirements based on real customer workflows.
  • Create internal documentation for common integration setup and troubleshooting paths.

Data Operations & Production Support

  • Run and validate approved scripts, imports, backfills, and data correction workflows.
  • Use SQL, CSV tooling, admin tools, logs, and internal dashboards to investigate support escalations.
  • Help resolve production data issues involving events, orders, ticket counts, opt-ins, payouts, reports, imports, and sync jobs.
  • Create repeatable processes for common one-off fixes so they become less dependent on engineering.
  • QA migration and integration work in staging and production environments.
  • Maintain a high bar for data accuracy, customer communication, and operational safety.

Process & Documentation

  • Build migration playbooks for common source systems.
  • Maintain field mapping documentation and import templates.
  • Document known edge cases, validation rules, and customer-specific requirements.
  • Create internal guides for customer success, support, and implementation teams.
  • Recommend product/admin tooling improvements that reduce manual migration and support work over time.

What We’re Looking For

  • 2+ years of experience in data operations, technical implementation, integrations support, customer onboarding, solutions engineering, technical support, or a similar role.
  • Strong comfort working with spreadsheets, CSVs, exports, messy customer data, and structured records.
  • Ability to investigate technical issues across APIs, logs, dashboards, admin tools, and customer reports.
  • Strong attention to detail and comfort validating large sets of data.
  • Clear written communication and strong ownership of follow-through.
  • Ability to work with both technical and non-technical stakeholders.
  • Comfort operating in a fast-moving startup environment where priorities can shift quickly.
  • Strong judgment around production data, customer impact, and when to escalate.

Nice to Have

  • Experience with ticketing, live events, venues, promoters, concerts, festivals, or event operations.
  • Experience migrating data from legacy SaaS platforms.
  • Experience with Ruby on Rails applications or reading application code.
  • Experience with Postgres, BigQuery, Looker, Metabase, Retool, or similar tools.
  • Experience with APIs, webhooks, OAuth, background jobs, or integration monitoring.
  • Experience with platforms such as Twilio, Stripe, Toast, Clover, Meta Ads / Conversions API, Google Calendar, HubSpot, or similar systems.
  • Experience supporting seating charts, ticketing inventory, orders, payouts, CRM records, or marketing automation.
  • Basic scripting ability in Ruby, Python, or JavaScript.

You’ll Be Successful If You

  • Can take a messy customer export and turn it into clean, usable data in Opendate.
  • Catch problems before customers do.
  • Communicate clearly when something is blocked, risky, incomplete, or ready for launch.
  • Make repeatable processes out of one-off migration work.
  • Reduce the amount of migration and integration work that has to go directly to engineering.
  • Build trust with customer success, support, product, and engineering teams.
  • Care about getting the details right because small data issues can create real customer pain.

Example Projects

  • Import historical customers, orders, donations, and marketing opt-ins from a legacy ticketing platform.
  • Troubleshoot why POS sales did not sync into an event report.
  • Validate ticket counts and order data after a migration.
  • Clean and import a venue’s upcoming event calendar.
  • Help configure SMS, email, advertising, or CRM-related integrations.
  • Investigate duplicate records, missing transaction history, or incorrect reporting totals.
  • Create a reusable migration checklist for a new legacy system.
  • Work with engineering to define better admin tools for import rollback, validation, and customer data review.

Why Join Opendate

You will play a critical role in helping venues and promoters move onto Opendate successfully. This role has direct customer impact, high visibility across the company, and the opportunity to shape the way Opendate scales onboarding, integrations, and data operations.

If you like solving messy real-world data problems, working across teams, and making complex customer transitions feel simple, we’d love to talk.

Similar Jobs

2 Hours Ago
Easy Apply
Remote
United States
Easy Apply
173K-255K Annually
Senior level
173K-255K Annually
Senior level
Big Data • Fintech • Mobile • Payments • Financial Services
Lead product for Affirm's 1:Many Distribution Partnerships, owning partner portfolio, building repeatable partner acceleration capabilities, defining roadmaps, metrics, and go-to-market strategies, and coordinating cross-functional teams to launch and scale platform integrations that drive merchant growth.
Top Skills: Figma
4 Hours Ago
Remote
United States
110K-130K Annually
Mid level
110K-130K Annually
Mid level
AdTech • Artificial Intelligence • Big Data • Digital Media • eCommerce • Machine Learning • Marketing Tech
Plan and execute regional and large-scale industry events, design executive-level activations, manage partner marketing and budgets, track lead flow and ROI, collaborate with Sales/Product/Global Marketing, and standardize event and partner marketing processes.
Top Skills: AsanaCRMRoi DashboardsSpreadsheets
8 Hours Ago
Remote
United States
253K-275K Annually
Senior level
253K-275K Annually
Senior level
Blockchain • Software • Cryptocurrency • Web3
Design, build, test, and deploy smart contracts and decentralized applications. Maintain blockchain integrations and backend services, optimize for security and gas efficiency, contribute to architecture and technical strategy, conduct code reviews, mentor junior engineers, and collaborate with product, frontend, and security teams.
Top Skills: AnchorAvalancheBnb ChainCi/CdCloud InfrastructureDaosDatabasesDefiEthereumEthers.JsFoundryGitGoHardhatNftsNode.jsPolygonPythonRustSmart ContractsSolanaSolidityTruffleTypescriptWallet IntegrationsWeb3.Js

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

  • Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
  • Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
  • Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
  • Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account