Campaign Data Analyst

This is a fully remote position, open to applicants in Chile.

📋 Description

• Convert campaign requirements into segmentation logic, SQL queries, and actionable workflows.

• Execute campaign code and generate list pulls utilizing established frameworks.

• Confirm the accuracy of campaign outputs through reconciliation checks, exploratory analysis, and edge case detection.

• Conduct statistical checks to validate segment distributions, thresholds, and suppression logic.

• Develop, optimize, and maintain SQL queries for extensive data extraction and analysis.

• Assist with ETL workflows in SSIS (Visual Studio), including job monitoring and troubleshooting.

• Utilize Tableau and Looker for data validation and analytical slicing, not for dashboard development.

• Recognize opportunities to automate campaign execution and validation to enhance reliability and minimize risk.

• Ensure secure data delivery and compliance through SFTP transfers, encryption/decryption, and governance standards.

⛳️ Requirements

• Proficient SQL skills for segmentation, extraction, and analytical validation.

• Practical experience with SSIS and Visual Studio for executing ETL workflows.

• Demonstrated experience in validating large datasets and conducting analytical QA checks.

• Understanding of secure data transfer methods, including SFTP and encryption/decryption.

• Background in marketing, CRM, customer data, or campaign operations.

• Familiarity with Python and libraries such as pandas, NumPy, or SciPy is advantageous.

• Experience with version control workflows like Git and modernizing legacy data processes is preferred.

• Advanced English proficiency required for effective communication with global teams.

• Over 5 years of experience in data analytics, campaign segmentation, data validation, or operational analytics roles, with strong hands-on SQL and ETL execution capabilities.

🏝️ Benefits

• Opportunities to obtain certifications in AWS, Databricks, and Snowflake.

• Access to AI learning paths.

• Customized study plans, courses, and additional certifications relevant to the role.

• Access to Udemy Business.

• English language lessons.

• Travel opportunities to attend industry conferences and engage with clients.

• Career development plans and mentorship programs.

• Special day rewards for birthdays, work anniversaries, and other personal milestones.

• Company-provided equipment.

• Flexible working arrangements.

• Additional benefits may vary by location in LATAM.