Position: eCRM Executive
Company: Philip Morris
Experience required: no_exp
English level: intermediate

Philip Morris Ukraine is looking for an eCRM Executive to join our IQOS product team. We offer the opportunity to collaborate on eCommerce and CRM solutions for IQOS in Ukraine. In this role, you will take on the responsibility of constructing and streamlining communication workflows and customer interactions. Your contributions will encompass the development and rigorous testing of these communication processes.

Key responsibilities:
- Automate journeys for regular communication campaigns (trigger based)
- Setup and analyze ad-hoc communication campaigns
- Design survey flows
- Keep technical documentation for business processes 
- Performing integration testing and running UAT
- Analyze communication’s performance & efficiency

 Requirements:
 
- 1-2 years of experience in an eCRM executive role or similar.
- Strong skills in Corezoid development (building business processes) for at least 2 years.
- Proficiency in crafting complex SQL queries for at least 2 years.
- Practical experience with web services (REST, Web API) and adherence to best practices.
- Familiarity with Object-Oriented Programming (OOP) principles and Software Development Life Cycle (SDLC).
- Proficiency in BPMN notation and the ability to design web flows using tools like Cawemo, Figma, draw.io, etc.
- Familiarity with SCRUM/AGILE methodologies would be advantageous.
- Proficiency in working with databases, including Redshift, PostgreSql, MS SQL, Oracle, Sybase IQ.
- Experience in optimizing SQL query scripts and an understanding of query cost estimation and query planning.
- Experience in analyzing the efficiency of send-out campaigns.
- Intermediate (B1) or higher proficiency in English, and fluent in Ukrainian.
 
Will be an advantage:
 
- Corezoid specialist certification at the middle level or higher.
- Understanding of Corezoid bot platform usage.
- Familiarity with cloud services like AWS and Google Cloud.
- Knowledge of methods for marketing research of send-out campaigns.
- Experience in creating dashboard reports using tools like PowerBi and Quicksight.
- Proficiency in building highly scalable transactional processes.
- Experience in creating scheduled/triggered SQL CRON jobs and stored procedures.
- Ability to automate test coverage for business processes (based on SQL and Corezoid).
- Experience in using Git for version control.