Senior Data Operations Specialist

Our agency client is looking for a freelance Senior Data Operations Specialist. The Data Operations Specialist will be responsible for the technical execution of data integrations, pipeline creation, and data cleansing, ensuring high-quality, accessible data for internal strategy teams. This position is vital for maintaining data integrity and providing a reliable data infrastructure, allowing the company’s internal teams to deliver accurate insights and recommendations to clients without needing to focus on campaign performance analysis themselves. This is a remote, adhoc role approx 10-20 hours per week for 2+ months. Responsibilities: Set up and connect data integrations from various sources (e.g., Google Ads, LinkedIn, GA4). Create and manage data pipelines to ensure efficient data flow. Cleanse and manipulate raw data to normalize and standardize it for analysis. Push processed data into storage environments such as Google Sheets, Microsoft Excel, BigQuery, or Microsoft Azure. Collaborate with internal data and strategy teams to understand data requirements. Ensure data quality and accessibility for internal analysis. Assist with setting up triggers, events, and tags in platforms like Google Tag Manager. Technical Skills: Advanced SQL and Python (Pandas, API integration, ETL development) Experience consuming REST APIs, including OAuth authentication, pagination, and JSON parsing Experience building automated data pipelines using Python, Azure Functions, GitHub Actions, or cloud automation tools Familiarity with CRM, marketing, and analytics platform APIs (Salesforce, HubSpot, Google Ads, Meta, LinkedIn, GA4, etc.) Experience connecting data sources to BI platforms (Power BI, Tableau, Looker) Git version control and collaborative development practices Bonus: JavaScript/TypeScript, dbt, Airflow/Prefect, GraphQL Bonus++: Clay, Demandbase #LI-ES1