Campaign Data Analyst
RemoteChile
Job Summary
Translate campaign requirements into segmentation logic, SQL queries, and executable workflows. Execute campaign code, generate list pulls, and validate outputs through reconciliation checks and edge case detection. Write, optimize, and maintain SQL queries for large-scale extraction while supporting ETL workflows in SSIS, including job monitoring and troubleshooting. Perform statistical checks to confirm segment distributions and ensure secure delivery via SFTP transfers and encryption standards. Use Tableau and Looker for data validation and analytical slicing. Identify opportunities to automate campaign execution and validation to improve reliability and reduce risk.
Required 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
- English: Advanced (required for effective communication with global teams)
- 5+ years of experience in data analytics, campaign segmentation, data validation, or operational analytics roles, with strong hands-on SQL and ETL execution skills
Desired Qualifications
- 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
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.