Specialist – Enterprise Information Management

Department

IT – Shared Services Unit

Division

Information Technology

Job Description

Job Purpose

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

Auto req ID

3898BR

Position Title

Specialist – Enterprise Information Management

Property / Business Unit

Wynn Palace

Read Full Description