Data Analyst - Campaigns

Job Description

Job Description

Job Summary: The Data Analyst is responsible for the design, development, implementation, and maintenance of the organization's whitelist base generation process. This role focuses on collaborating with cross-functional teams to ensure the accurate and timely delivery of whitelist base reports aligned with business objectives and requirements.

Duties and Responsibilities:

• Transformation SQL Development: Develop and optimize SQL transformations to process campaign data efficiently, ensuring accurate and targeted whitelist base generation for marketing campaigns.
• Data Integration and Pipeline Support: Develop and maintain data pipelines that support campaign segmentation, audience targeting, and personalization using cloud-based ETL solutions (e.g., AWS services).
• Monitoring and Troubleshooting: Proactively monitor and resolve issues related to campaign data pipelines, ensuring seamless data processing and timely campaign execution.
• Compliance and Best Practices: Ensure all campaign-related data processes comply with industry standards, regulatory requirements, and internal data governance policies.
• Documentation and Reporting: Maintain up-to-date documentation of campaign data processes, transformations, and outputs. Provide reports on whitelist base generation, audience segmentation, and campaign performance insights.
• ETL Process Optimization: Design and implement efficient ETL workflows that transform raw customer data into actionable insights, enabling data-driven campaign strategies.
• Data Mapping: Ensure accurate data mapping between campaign data sources, customer databases, and output files to facilitate seamless campaign execution and reporting.

Qualifications:

• BS in Computer Science, Information Technology, Computer Engineering, or related courses
• SQL Development certifications (Oracle, MS SQL, Hive, or similar technologies).
• Cloud technologies certification (AWS, Azure, or similar).
• Additional training related to technical skills or certifications in relevant areas.
• Familiarity with Snowflake or other cloud-based data warehousing solutions.
• Python programming for data processing and ETL development.
• Requirements gathering to collaborate with business to finalize the requirements.

Required Skills:

• Strong communication and collaboration skills, with the ability to work effectively with cross-functional teams.
• Exceptional problem-solving and analytical skills.
• Ability to manage and prioritize multiple tasks while ensuring deadlines are met.
• Highly detail-oriented, with a commitment to maintaining high-quality data management standards.