Opendate Logo

Opendate

Data Migration / Integrations Specialist

Reposted 3 Hours Ago
In-Office or Remote
Hiring Remotely in Chicago, IL, USA
Junior
In-Office or Remote
Hiring Remotely in Chicago, IL, USA
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

48 Minutes Ago
Remote
United States
145K-175K Annually
Senior level
145K-175K Annually
Senior level
Fintech • Financial Services
Lead IT operations and support for a rapidly growing fintech: maintain and upgrade systems, manage endpoints (Mac/Windows/ChromeOS), run MDM and Google Workspaces, mentor staff, define metrics, lead large IT projects, manage vendors and office technology, implement cybersecurity controls, expand support coverage, and travel internationally twice yearly.
Top Skills: Av SystemsCall Center SystemsCamerasCard Access SystemsChromeosEmail SystemsGoogle WorkspacesHosted Telephony/PbxmacOSMdm (Mobile Device Management)NetworkingSmsTeleconferencingWindows
An Hour Ago
Remote
USA
Junior
Junior
eCommerce • Retail
Provide real-time resolution for escalated and high-effort customers via inbound/outbound calls and email. Own customer experiences, document action items, use Five9/Intercom/GSuite/Slack/Asana, share frontline insights, and act as a brand ambassador to improve satisfaction and retention.
Top Skills: AsanaFive9Google SuiteIntercomSlack
An Hour Ago
Remote
United States
Mid level
Mid level
Edtech • Fintech • Payments • Social Impact • Financial Services • Big Data Analytics
Modernize a large fintech platform by building NestJS services and Next.js UIs, migrate transactional data to relational schemas, write comprehensive tests, identify and fix legacy problems, design scalable solutions that coexist with legacy systems, and use AI tooling responsibly to increase engineering velocity.
Top Skills: AWSBackboneCiClaude CodeCypressDockerExpressFastifyGithub CopilotJavaScriptJestKafkaKubernetesMarionetteMaterial-UiMongoDBMongooseMySQLNestjsNext.JsNode.jsPlaywrightPostgresRabbitMQReactReduxSQLSqsSupertestTypescript

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account