Campaign Analyst &ndash (SQL QuerySAS) (Montreal)

Campaign Analyst &ndash (SQL QuerySAS)

The start date of this job is flexible and in order to find the best candidate the job may remain open much longer than the date mentioned on this posting .. or you may be asked to start sooner than the expected start date if you are able to do so URGENT Please read the job description below. If this interests you please send a MS-Word version copy of your updated resume (ASAP) along with your salary expectations first available date and a telephone contact number E-mail to piritheep(at)teamrecruiter.com Please mention the job title above in the subject line The recruiter in charge of this role is Piritheep AFTER you have submitted your resume via e-mail (when you have a moment) please apply online to match your resume to the job with following link s www.stafftrak.net ApplyOnline teamrecruiter.web tt JD& jobId 010553 If you do not think you are a match for this opportunity but know someone who is feel free to forward this email to them and you will be eligible for a referral bonus upon a successful hire. My client is a well-established Major Bank located in Toronto ON. They are looking for a Campaign Analyst (SQL Query SAS) This is a 9 Month contract position with a strong possibility of an extension. Campaign Analyst Mandate The Campaign Analyst is responsible for working with Lead Management clients to document develop and prepare new campaign production and development programs for execution. These programs will encompass anything from communication to fulfillment to measurement for both customers and prospects. ACCOUNTABILITIES 1. Determine from a given business objectives what combination of Leads Management processes (25 Lane Highway CVM Trillium etc.) are required to achieve the required goal.2. Document the technical details of a given Leads program in the appropriate format.3. Develop code to execute program data requirements and prepare appropriate input files for each of the Campaign Production & Development processes.4. Communicated detailed project plans to clients.5. Manage a Leads Campaign project through the development workflow. Group - Campaign Production and Development - Execute marketing campaigns for all lines of business except Credit cards - Build campaigns target customers creating contact channels and submit leads - Hybrid Technical business Day to day - Running 20-30 campaigns a month - Majority of the day is spent on information gathering - Accessing database for customer information - Developing the query coding SQL (creating rules) - Peer audits validating campaigns all of the requirements have been captured correctly - Process improvement working with the database looking for and creating efficiencies added value for process efficiency - All of this is related to marketing data - Database management and manipulation sensitive customer information - High level of discretion with information Must haves - SAS and SQL intermediate to advanced level (2-4 years) - Excel based macros pivot tables v-lookup - Experience working with large databases & Business Intelligence systems - Know how to manipulate an aggregate information and make this presentable - Marketing campaign knowledge this would be an asset. Please note that this is the most up to date version of job description available at this time During Client Interview you will receive additional information variance may apply When you have some time please register in our database (5 minute process) to be considered for future openings the link is available on our website at www.teamrecruiter.com in the Candidate section. We thank all applicants for their interest. Only those who meet the qualifications will be contacted through telephone email. You are encouraged to register with us in our database to be considered for future positions available. Have a great day. ......At Teamrecruiter.com we offer some of the most highly qualified professionals in the workforce. We dedicate an industry trained recruitment specialist to the following areas IT Finance Admin Sales Executive Search and Contractors. If you would like to learn more about our full-service recruiting firm please visit our website at www.teamrecruiter.com. CAMSC and ACSESS certified ..All Offers are conditional on Client Post-Offer Conditions being met and removed by end client prior to written offer signing