Campaign Data Analyst
This role focuses on translating campaign requirements into scalable SQL workflows and ETL processes, ensuring data accuracy through validation checks and automation. The candidate will optimize existing frameworks while maintaining compliance with governance standards for secure data delivery.
Skills required
About this role
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
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 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 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.
So what are the next steps?
Our team is eager to learn about you! Send us your resume or LinkedIn profile below and we'll explore working together!
