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

4 Minutes Ago
Remote or Hybrid
United States
88K-118K Annually
Senior level
88K-118K Annually
Senior level
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Lead buy- and sell-side Quality of Earnings engagements: analyze financials, assess earnings quality, working capital, and net debt; prepare diligence reports and presentations; manage VDRs; mentor junior staff; support valuation, deal structuring, integration planning, and business development.
Top Skills: ExcelFinancial DatabasesVirtual Data Rooms
4 Minutes Ago
Remote or Hybrid
United States
107K-160K Annually
Mid level
107K-160K Annually
Mid level
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Provide controller-level advisory to skilled nursing clients: oversee financial reporting, budgeting, forecasting, KPI/benchmarking analysis, technical accounting support, operational improvement recommendations, and lead and coach client teams to improve financial stability and reporting quality.
Top Skills: PointclickcareQuickbooks OnlineSage Intacct
4 Minutes Ago
Remote or Hybrid
United States
117K-158K Annually
Senior level
117K-158K Annually
Senior level
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Lead transaction advisory engagements by performing financial analysis and modeling, evaluating deal structures and valuations, managing multiple projects, liaising with clients and cross-functional teams, preparing clear reports and presentations, and reviewing junior team members' work to ensure accuracy and high-quality deliverables.
Top Skills: ExcelFinancial Databases

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account