Company: Union Bank of the Philippines Position: Data Analyst - Campaigns Office Location: UnionBank Square - Eastwood, Libis, Quezon City 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.