Campaign Data Analyst

Blend; Santiago; Híbrido; CLP 25.000.000 - 42.000.000; Jornada completa

Descripción de la vacante

Blend is seeking a Campaign Data Analyst to translate campaign requirements into segmentation logic, write and optimize SQL queries, and support ETL workflows. You will validate outputs, perform QA checks, and use Tableau/Looker for data validation.

Experience with SSIS and Visual Studio is essential, as is a background in marketing or CRM data. English proficiency is required for collaboration with global teams, and the role emphasizes automation to improve campaign reliability while ensuring

Formación

• Strong SQL for segmentation, extraction, and validation.
• Hands-on experience with SSIS/Visual Studio for ETL workflows.
• Proven ability to validate large datasets and perform QA checks.
• Familiarity with secure data transfers (SFTP, encryption/decryption).
• Background in marketing, CRM, customer data, or campaign operations.

Responsabilidades

• Translate campaign requirements into segmentation logic and SQL queries.
• Execute campaign code and generate lists using established frameworks.
• Validate outputs through reconciliation checks and exploratory analysis.
• Write, optimize, and maintain SQL queries for large-scale extraction.
• Support ETL workflows in SSIS including monitoring and troubleshooting.
• Use Tableau and Looker for data validation and analytical slicing (not dashboards).
• Identify automation opportunities to improve campaign execution reliability.
• Ensure secure delivery and governance of data via SFTP transfers.

Conocimientos

SQL

Python

Git

Data QA

Campaign operations

Herramientas

SSIS

Visual Studio

Tableau

Looker

Descripción del empleo

Blend is a premier AI services provider, committed to co-creating meaningful impact for its clients through the power of data science, AI, technology, and people. With a mission to fuel bold visions, Blend tackles significant challenges by seamlessly aligning human expertise with artificial intelligence. The company is dedicated to unlocking value and fostering innovation for its clients by harnessing world-class people and data-driven strategy. We believe that the power of people and AI can have a meaningful impact on your world, creating more fulfilling work and projects for our people and clients. For more information, visit www.blend360.com

We are seeking a Campaign Data Analyst to contribute to our next level of growth and expansion.

What is this position about?

• Translate campaign requirements into segmentation logic, SQL queries, and executable workflows
• Execute campaign code and generate list pulls using established frameworks
• Validate campaign outputs through reconciliation checks, exploratory analysis, and edge case detection
• Perform statistical checks to confirm segment distributions, thresholds, and suppression logic
• Write, optimize, and maintain SQL queries for large-scale extraction and analysis
• Support ETL workflows in SSIS (Visual Studio), including job monitoring and troubleshooting
• Use Tableau and Looker for data validation and analytical slicing (not dashboard development)
• Identify opportunities to automate campaign execution and validation to improve reliability and reduce risk
• Ensure secure delivery and compliance through SFTP transfers, encryption/decryption, and governance standards

Qualifications

• Strong SQL skills for segmentation, extraction, and analytical validation
• Hands-on experience with SSIS and Visual Studio for ETL workflow execution
• Proven experience validating large datasets and performing analytical QA checks
• Familiarity with secure data transfer processes (SFTP, encryption/decryption)
• Background in marketing, CRM, customer data, or campaign operations
• Knowledge of Python and libraries such as pandas, NumPy, or SciPy is a plus
• Experience with version control workflows (Git) and modernizing legacy data processes is preferred

What about languages?

English: Advanced (required for effective communication with global teams)

How much experience must I have?

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

Additional Information

Our Perks and Benefits:

Learning Opportunities

• Certifications in AWS (we are AWS Partners), Databricks, and Snowflake.
• Access to AI learning paths to stay up to date with the latest technologies.
• Study plans, courses, and additional certifications tailored to your role.
• Access to Udemy Business, offering thousands of courses to boost your technical and soft skills.
• English lessons to support your professional communication.

Travel opportunities

Travel opportunities to attend industry conferences and meet clients.

Mentoring and Development

• Career development plans and mentorship programs to help shape your path.

Celebrations & Support

• Special day rewards to celebrate birthdays, work anniversaries, and other personal milestones.
• Company-provided equipment.

Flexible working options

Flexible working options to help you strike the right balance.

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.