Note: The job is a remote job and is open to candidates in USA. Strategus is a CTV-first, fully managed service partner focused on programmatic Connected TV and data-driven advertising. The Senior Data Operations Analyst owns the systems and workflows supporting client reporting, campaign delivery, and month-end billing, while troubleshooting data issues, managing custom requests, and coordinating across business and technology teams.
Responsibilities
- Own and prioritize data requests based on urgency, client impact, and revenue risk
- Build and maintain Sigma workbooks, Snowflake views, data models, and supporting data assets; troubleshoot issues across Salesforce, Fivetran, Snowflake, Sigma, and downstream reporting
- Manage reporting access, user permissions, onboarding, account changes, offboarding, external Snowflake shares, and client Data Dictionaries
- Maintain synchronization between Salesforce orders and DSP campaigns; resolve reporting and month-end exceptions involving campaign data, delivery, invoices, and product setup
- Maintain partner data feeds and support new data connections as business needs evolve
- Develop dashboards and custom analyses; resolve data-quality issues involving geography, campaign classification, conversion data, and delivery
- Automate repetitive processes, maintain documentation and training materials, and coordinate resolution with Ad Ops, Account Management, Sales, engineering partners, support teams, and vendors
Skills
- Strong SQL and Snowflake experience, including views, data shares, schemas, dependencies, and troubleshooting
- Advanced Sigma or comparable business-intelligence experience, including workbook design, data modeling, and client reporting
- Working knowledge of Salesforce, data pipelines, and SaaS connections such as Fivetran
- Familiarity with programmatic advertising, DSP data, campaign delivery, reporting, reconciliation, and attribution
- Experience supporting client reporting, permissions, onboarding, and external data delivery
- Strong prioritization, communication, documentation, and cross-functional problem-solving skills
- Data automation or scripting experience, including Python or a similar language
- Ad tech, media analytics, or programmatic advertising experience
- Billing reconciliation and month-end exception-management experience
Benefits
- A generous performance-based bonus program
- A full benefits package
- Remote work in the USA
- Strategus invests in your development
Company Overview