CAMPAIGN DATA ANALYST
Blend360
Contractsenior
Job description
<p><strong>What is this position about?</strong></p><ul><li>Translate campaign requirements into segmentation logic, SQL queries, and executable workflows</li><li>Execute campaign code and generate list pulls using established frameworks</li><li>Validate campaign outputs through reconciliation checks, exploratory analysis, and edge case detection</li><li>Perform statistical checks to confirm segment distributions, thresholds, and suppression logic</li><li>Write, optimize, and maintain SQL queries for large-scale extraction and analysis</li><li>Support ETL workflows in SSIS (Visual Studio), including job monitoring and troubleshooting</li><li>Use Tableau and Looker for data validation and analytical slicing (not dashboard development)</li><li>Identify opportunities to automate campaign execution and validation to improve reliability and reduce risk</li><li>Ensure secure delivery and compliance through SFTP transfers, encryption/decryption, and governance standards</li></ul>
<ul><li>Strong SQL skills for segmentation, extraction, and analytical validation</li><li>Hands-on experience with SSIS and Visual Studio for ETL workflow execution</li><li>Proven experience validating large datasets and performing analytical QA checks</li><li>Familiarity with secure data transfer processes (SFTP, encryption/decryption)</li><li>Background in marketing, CRM, customer data, or campaign operations</li><li>Knowledge of Python and libraries such as pandas, NumPy, or SciPy is a plus</li><li>Experience with version control workflows (Git) and modernizing legacy data processes is preferred</li></ul><p><strong>What about languages?</strong></p><p>English: Advanced (required for effective communication with global teams)</p><p><strong>How much experience must I have?</strong></p><p>5+ years of experience in data analytics, campaign segmentation, data validation, or operational analytics roles, with strong hands-on SQL and ETL execution skills.</p>
<p><strong>Our Perks and Benefits:</strong></p><p>๐ Learning Opportunities:</p><ul><li>Certifications in AWS (we are AWS Partners), Databricks, and Snowflake.</li><li>Access to AI learning paths to stay up to date with the latest technologies.</li><li>Study plans, courses, and additional certifications tailored to your role.</li><li>Access to Udemy Business, offering thousands of courses to boost your technical and soft skills.</li><li>English lessons to support your professional communication.</li></ul><p>๐จ๐ฝโ๐ป Travel opportunities to attend industry conferences and meet clients.</p><p>๐ฉโ๐ซ Mentoring and Development:</p><ul><li>Career development plans and mentorship programs to help shape your path.</li></ul><p>๐ Celebrations & Support:</p><ul><li>Special day rewards to celebrate birthdays, work anniversaries, and other personal milestones.</li><li>Company-provided equipment.</li></ul><p>โ๏ธ Flexible working options to help you strike the right balance.</p><p>Other benefits may vary according to your location in LATAM. For detailed information regarding the benefits applicable to your specific location, please consult with one of our recruiters.</p><p>So what are the next steps?</p><p>Our team is eager to learn about you! Send us your resume or LinkedIn profile below and we'll explore working together!</p>