As an AdOps Analyst, you will be hands-on and will be expected to use analytical and problem-solving skills to analyze and transform big data. The primary function is to confirm a client campaign is properly launched on time and maintain the health of exposure collection during the campaign, in addition to analyzing data sets of our retailers and partners and identify potential inconsistencies. This function serves a critical role in the completion of product delivery to clients. When done properly, this function enables efficiency, analyzes raw data, contributes to revenue and strengthens relationships with clients.
Job Responsibilities
To be effective as an AdOps Analyst the candidate must have proven and demonstrable skills in the below key areas:
Manage data receipt from several external sources, contacting partners and customers to resolve data quality and data format issues whenever they arise.
Investigate and collaborate with other departments and clients to resolve reported data quality problems.
Responsible for performing proactive data integrity checks and reviewing data completeness and validation reports.
Responsible for data collection and exposure workflow – managing tagging related issues, facilitating collection and upload, and general QA across the workflow.
Setup, run, monitor, and troubleshoot production jobs.
Own full life-cycle tracking of reported data problems, data extraction, and investigative requests.
Document new and existing operational processes and services.
Monitor operational calendars to ensure clients and partners are meeting set milestones; notify management if schedule impacts are expected.
Actively support and enforce the company’s data privacy and security standards.
Review received raw data for quality, maintenance, and trends to understand changes or errors that may be occurring in the data
Maintain reports to evaluate data loads for completeness, accuracy, and timeliness
Maintain tracking reports to be a resource for questions regarding live and completed campaigns
Qualifications
Bachelor’s Degree in Business, Info Systems, Computer Science/Technology, or a related field
2+ years of relevant experience
Strong knowledge of Linux/Unix commands & shell scripting
Intermediate experience with composing and modifying SQL for ad-hoc data queries
Hands-on experience writing jobs for batch scheduling systems
Job/process performance monitoring, management, and recovery
Experience supporting file transfers of medium to large data sets using a variety of protocols such as SFTP, AWS, Snowflake, etc.
Analytical and problem-solving skills with a sense of proportion/importance for data anomalies
Ability to balance multiple projects, tasks, and priorities and to remain flexible when priorities or work direction change
Ability to quickly learn new technology and data concepts
Excellent written and verbal communication skills with demonstrated ability to communicate and collaborate with other teams to achieve desired results.
Circana Behaviors
Beyond technical skills, experience, and role-specific attributes, these shared behaviors are fundamental to our culture and success. We seek individuals who consistently demonstrate and champion these behaviors in their daily work:
Stay Curious: Being hungry to learn and grow, always asking the big questions
Seek Clarity: Embracing complexity to create clarity and inspire action
Own the Outcome: Being accountable for decisions and taking ownership of our choices
Center on the Client: Relentlessly adding value for our customers
Be a Challenger: Never complacent, always striving for continuous improvement
Champion Inclusivity: Fostering trust in relationships; engaging with empathy, respect, and integrity
Commit to Each Other: Contributing to making Circana a great place to work for everyone
Location
This position can be located in the following area(s): Mexico City, Remote/Hybrid