Data Engineer
Job Description
This Data Operations & Production Support Analyst role supports campaign operations and data-intensive production workflows, with a focus on processing accuracy, data quality, and issue resolution. The position requires strong SQL troubleshooting, validation experience, and coordination across technical teams.
Key Responsibilities
- Monitor campaign execution to ensure processing, quality checks, and delivery activities complete accurately.
- Support campaign setup updates, including data mapping, cost refreshes, reruns, and production corrections.
- Review processing requirements and dependencies prior to campaign execution.
- Monitor campaign schedules, end dates, and processing eligibility.
- Coordinate validated outputs and operational handoffs to downstream teams.
- Perform quality checks on campaign outputs and investigate data anomalies.
- Validate processing results, record counts, trends, and overall data accuracy.
- Support QC of portal files and monthly data extracts.
- Investigate discrepancies and coordinate resolutions with the 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.
- Provide initial troubleshooting to determine when technical escalation is required.
- Collect logs, SQL queries, screenshots, and supporting evidence for technical investigations.
- Coordinate retesting and validation following production fixes.
- Track incidents through resolution and communicate updates to stakeholders.
- Support root-cause analysis and manage recurring issues.
- 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.
Required Qualifications
- Experience in Data Operations, Production Support, Application Support, Campaign Operations, Analytics Operations, or a similar data-intensive environment.
- Strong hands-on SQL skills, including querying large datasets and investigating data discrepancies.
- Experience supporting scheduled production workflows, batch processing, or data pipelines.
- Strong troubleshooting and first-level issue analysis skills.
- 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 ownership mindset.
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
Role Details
- Job Title: Data Operations & Production Support Analyst
- Company: Experis
- Location: New Providence, NJ (100% remote; onsite interview required)
- Contract Duration: 6+ contract
- Pay Rate: USD 70 - 74 per hour on W2
- Candidate Location: Must be located in PA, NJ, or NY
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