The EIM Campaign Specialist is responsible for supporting the CRM promotional campaigns, ensuring that all related data pipelines, Python scripts and campaign workflows running on the platforms (eg. Airflow, Adobe Campaign) are operational. This role involves supporting ETL processes to extract customer profiles and transactional data from various databases, including SQL Server, MongoDB, ClickHouse, and Redis etc. The specialist monitors data integrity, addresses inquiries from various departments, collaborates with marketing teams, and conducts quality assurance testing before production rollouts. The EIM Specialist will also address queries regarding CRM promotional campaigns from various departments and communicates vital information within the team while being available for on-call support and working shift schedules as required.

Key Responsibilities

• Provide support for data integration processes to ensure seamless Extraction, Transformation, and Loading (ETL) of data from multiple sources
• Ensure that all CRM promotional campaign scripts or workflow in the campaign platform like Airflow or Adobe Campaign etc are running smoothly and troubleshoot any issues that arise
• Actively monitor and validate ETL processes to maintain data integrity and accuracy
• Serve as the primary contact for inquiries related to CRM promotional campaigns from various departments
• Collaborate with marketing teams to understand campaign requirements
• Develop and execute test plans to validate data integration processes, ensuring all functionalities meet business requirements
• Perform quality assurance testing on all campaign-related scripts and ETL processes before rollout to production
• Maintain the performance of data warehouse/data lake environments by identifying and resolving conflicts or inefficiencies in data management
• Communicate essential information within the team to foster collaboration and maintain the knowledge base about promotional campaign and the experience of the related support cases
• Availability for on-call support during critical production issues related to CRM campaigns
• Willingness to work on shift schedules as required to provide continuous support for CRM campaigns

Competencies and Requirements:

Experience: Minimum 1 years working in an IT related position
Education: Diploma or degree in Information Technology or a related field.
Language Ability: Multilingual capabilities in English, Mandarin, and Cantonese preferred.
Knowledge/Certificates:
Knowledge of SQL queries, SQL Server Integration Services (SSIS), Python programming are required
Understanding of database management systems and ETL (Extract, transform, load) framework
Experience with Airflow for workflow management are significant advantage
Strong analytical mindset with problem-solving aptitude
Ability to work under tight deadlines both independently and as part of a team
Willingness to learn new technologies and adapt to changing business needs
Familiar with IT processes and procedures
Excellent verbal and written communication skills

For enquiries, please contact us at (853) 8986 6222 during office hours
From Monday to Friday between 9:00am and 6:00 pm