Remote Campaign Analyst

Job Details

Job Location

Milan, IL

Remote Type

Fully Remote

Position Type

Full Time

Salary Range

$90,000.00 - $110,000.00 Salary/year

Job Shift

1st Shift

Job Category

Business Analytics

Description

The candidate will create design for customer selection in regards to direct marketing and campaign lists.

Primary Tasks

• Adeptly facilitate meetings to capture requirements
• Provide recommendations and valuable insights to clients to assist with the design and development of the targeted marketing request and campaigns.
• Create use cases and test scenarios as needed to communicate the approach and validate the solution.
• Develop functional specifications and system design specifications in conjunction with marketing, legal and other consultative roles.
• Assist in timeline/schedule enforcement, testing strategies, and issue tracking.
• Advanced SQL coding skills, to understand campaign GUI backend processing & for troubleshooting.
• Perform quality checks on other team members campaign with 100% accuracy.
  
  

Qualifications

Education:

• Bachelor’s Degree/Equivalent, or 3-5 years related experience.
  
  

Training

• Ability to write/run SQL queries in a large database environment on demand for investigations.
• Must be a strong SQL Coder with Data Mining Skills (Understands complex coding processes, i.e. joins-inner & outer, aggregating data, building temp tables, formatting data, and import & export processes).
• ETL (Extract, Transfer & Load) processing preferred
• Expert knowledge of aggregating data using complex SQL code. i.e., using functions such as SUM, COUNT, CASE statements, etc.
  
  

Skills

• Ability to work independently and within teams with a focus on detail and can work on several projects at the same time. Ability to think outside of the box and excel in problem solving.
  
  

Experience

• Experience in a List Management or generation: can work well with business clients to gather requirements and successfully translate requirements into code.
  
  

Desired Skills

• Manage campaign workflows using Aprimo Enterprise 8.0.
• 2+ years' experience in various Campaign tools- Creating campaign target designs using Affinium Campaign, version 8.2 or related software.
• Crystal Reports - Business Objects, Silver Pop, Roojoom and other similar GUI campaign programs and platforms.
• At least one-year experience in Marketing campaign management or list generation.
• Ability and drive to do data research on questions without receiving specific directions.
• Background in CRM or direct marketing, with a strong aptitude for program management.
• Demonstrated strong analytic and fact-based decision-making skills, especially as related to CRM campaign design.
• Possess outstanding computer skills and be proficient using Microsoft Office products including Outlook, Word, PowerPoint and Excel.
• Excellent communication and relationship building skills.
• Must be self-motivated and capable of working with minimal supervision in a highly-matrixed, fast paced, evolving organization.
  
  

Group O is committed to providing equal employment opportunities to all employees and applicants for employment. We prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, and sexual orientation. If you require accommodations to participate in the job application process, please contact [email protected], we will work with you to meet your needs. Information provided by applicants will be treated with the utmost confidentiality. We respect your privacy and will handle your application data in accordance with our privacy policy.

Grow With Group O

At Group O, it’s our employees who we value most. That’s why we provide a supportive environment where employees are given every opportunity to excel. Group O offers a wide variety of careers with room for professional growth and advancement, and we are always looking for motivated individuals to join our team. At Group O, our employees’ health and well-being is equally as important as the work they perform. We back up that philosophy by providing a competitive benefits package that supports now and for their future.

In 1974, Bob Ontiveros saw an opportunity to live the American dream and build a company for himself and his family. 50 years later, the packaging company he originally founded out of the back of his station wagon - Group O is ranked by the United States Hispanic Chamber of Commerce as one of the top five Latino-owned businesses in the country. Group O has gained prestige for helping Fortune 500 companies like Samsung, Michelin, Caterpillar, and PepsiCo turn their most complex business challenges into centers of profitability and efficiency. Headquartered in Milan, IL, Group O employs over 1,200 employees.