DataJobs.io
← Back to all jobs

Job Description

Support campaign operations and production workflows with hands-on SQL, data quality checks, and cross-team incident resolution.

Responsibilities

  • Monitor campaign execution to confirm processing, quality checks, and delivery activities complete accurately.
  • Assist with campaign setup changes, including data mapping, cost refreshes, reruns, and production corrections.
  • Review processing requirements and dependencies prior to campaign execution.
  • Track campaign schedules, end dates, and processing eligibility.
  • Coordinate validated outputs and operational handoffs to downstream teams.
  • Run quality checks on campaign outputs and investigate data anomalies.
  • Validate processing results using record counts, trends, and data accuracy checks.
  • Support QC for portal files and monthly data extracts.
  • Investigate discrepancies and coordinate resolutions with relevant teams.
  • Maintain QC documentation and support continuous improvement of operational controls.
  • Act as an onshore point of contact for production issues, failed jobs, data discrepancies, and operational questions.
  • Conduct initial troubleshooting and determine when technical escalation is needed.
  • Collect supporting evidence for investigations, including logs, SQL queries, and screenshots.
  • Coordinate retesting and validation after production fixes.
  • Track incidents through resolution and communicate updates to stakeholders.
  • Support root-cause analysis and recurring issue management.
  • Collaborate with Data Management, Product Support, Development, Data Ingestion, Client Engagement, and other technical teams.
  • Translate business and operational issues into clear technical support requests.
  • Coordinate campaign exceptions, missing inputs, mapping decisions, reruns, and redeliveries.
  • Communicate operational status, risks, blockers, and downstream impacts.
  • Participate in operational meetings, campaign reviews, and issue discussions.
  • Maintain operational trackers, support tickets, processing statuses, and issue documentation.
  • Maintain standard operating procedures and production support documentation.
  • Identify recurring issues and opportunities for automation and process improvement.
  • Support new operational controls and transition new capabilities into production support.
  • Follow established approval and change-control procedures.

Requirements

  • Experience in Data Operations, Production Support, Application Support, Campaign Operations, Analytics Operations, or a similar data-intensive environment.
  • Strong hands-on SQL skills to query large datasets and investigate data discrepancies.
  • Experience supporting scheduled production workflows, batch processing, or data pipelines.
  • Strong troubleshooting skills for first-level issue analysis.
  • Experience with data validation, reconciliation, and quality-control processes.
  • Excellent written and verbal communication skills.
  • Ability to manage multiple concurrent deliverables, production incidents, and operational priorities.
  • Strong attention to detail, problem-solving ability, and an ownership mindset.

Technologies

  • Snowflake
  • SQL
  • ETL / Production Data Pipelines
  • Workflow Scheduling and Orchestration Tools
  • Power BI or similar reporting and QC tools
  • SFTP and File-Based Integrations
  • Jira / Confluence

Position Details

  • Job title: Data Operations & Production Support Analyst
  • Pay rate: $70-$74/hr on W2
  • Location: 100% Remote (onsite interview required)
  • Duration: 6+ contract
  • Candidate location: must be located in PA, NJ, or NY
  • Location listing: New Providence, NJ (remote)

Preferred Technical Skills

  • Snowflake
  • SQL
  • ETL / Production Data Pipelines
  • Workflow Scheduling and Orchestration Tools
  • Power BI or similar reporting and QC tools
  • SFTP and File-Based Integrations
  • Jira / Confluence
  • Campaign Operations or Digital Measurement Data

Similar Jobs