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