Opendate Logo

Opendate

Data Migration / Integrations Specialist

Reposted One Month 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

10 Minutes Ago
Remote or Hybrid
United States
129K-174K Annually
Senior level
129K-174K Annually
Senior level
Artificial Intelligence • Consumer Web • Edtech • Enterprise Web • HR Tech • Social Impact • Generative AI
Lead and execute SEO strategy to grow organic visibility across web, AI search, and emerging discovery platforms. Own technical and content SEO roadmaps, partner with Product, Engineering, and Content to optimize indexing, performance, structured data, and site architecture. Measure and report visibility, traffic, engagement, and conversion; influence cross-functional stakeholders to scale SEO impact.
Top Skills: AhrefsBi ToolsGoogle AnalyticsGoogle Search ConsoleLookerProfoundPromptwatchPythonScreaming FrogSemrushSQLTableau
10 Minutes Ago
Remote or Hybrid
United States
156K-236K Annually
Expert/Leader
156K-236K Annually
Expert/Leader
Artificial Intelligence • Consumer Web • Edtech • Enterprise Web • HR Tech • Social Impact • Generative AI
Lead strategy and roadmap for AI-powered learning products, drive high-priority AI initiatives from concept to scale, partner cross-functionally to deliver responsible AI solutions, define success metrics and experimentation frameworks, and advise leadership on AI trends and opportunities.
Top Skills: Agentic SystemsAi AgentsExperimentation FrameworksGenerative AiIntelligent AutomationLarge Language ModelsPersonalizationRecommendations
52 Minutes Ago
Remote or Hybrid
United States
Entry level
Entry level
Artificial Intelligence • Healthtech • Logistics • Social Impact • Software • Telehealth
Provide after-hours and weekend travel support: monitor channels, handle flight/hotel/transport disruptions, rebook travel per SOPs, escalate high-impact issues, document actions, and hand off unresolved items to weekday Logistics.
Top Skills: SlackTravel Booking Platforms

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

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account