Remote Campaign Analyst
Group O · Milan, IL · United States Of America · Remote
About the job
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.
Education:
- Bachelor’s Degree/Equivalent, or 3-5 years related experience.
- 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.
- 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 in a List Management or generation: can work well with business clients to gather requirements and successfully translate requirements into code.
- 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.
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.