JOB PURPOSE :
The Marketing Analyst - Automation position will proactively help expand Midco services to new and existing customers. This collaborative position will play the lead role in gathering, verifying, optimizing, and analyzing customer and prospect data to ensure Bestness in the delivery and performance of communications and marketing campaigns. Midco's company footprint is growing, and our goal is to be the best company for current and new customers.
KEY FUNCTIONS :
- Pull and verify customer and prospects lists in a timely fashion to ensure that the right information gets to the right audience at the right time.
- Collaborate with Marketing, IT, and Operational partners to verify and optimize data across campaigns and automate list pulls through Adobe Campaign Classic.
- Collect, cleans, analyze and distribute significant amounts of information with an emphasis on detail and accuracy.
- Work closely with marketing teams to coordinate the successful execution of projects specifically around audience creation (list pulls) and audience performance tracking.
- Connect Adobe to data visualization software (such as PowerBI) to provide real-time reporting, transparency and insights to marketing and operational partners.
- Create opportunities to connect project team members with analytic resources outside of marketing to help create open lines of communication and collaborate across boundaries.
- Provide quality assurance and user acceptance testing support.
- Partner with the Marketing Automation Specialist and internal product owners to integrate and automate data between the marketing automation platform and various other systems (Adobe Campaign Classic, CRM, external vendor partners, custom / in-house applications, etc.)
- Use data-informed insights including propensity scoring to provide lists for both business and residential segments.
- Make recommendations on audience selection to support and elevate marketing growth and lifecycle strategies.
- Collaborate with analysts across the enterprise to stay informed and aligned with changes throughout the company that may impact existing processes.
- Document and store logic to ensure accuracy, transparency and historical data.
- Partner with Data Engineering to support the extract, transform, and load process from various data sources using SQL.
- Verify that incoming data requests have all information required to begin work. Proactively gather missing information and regularly follow up on inquiries to keep work moving. Execute data requests in a timely manner.
- Follow and serve as a role model in displaying Midco's Core Values and Leadership Success Drivers.
- Adhere to Midco privacy guidelines to ensure each customer's privacy.
- Maintain regular attendance as required by your position.
ADDITIONAL FUNCTIONS AND RESPONSIBILITIES :
Analytical and logical mind-set.Effectively communicate with other departments to handle escalating issues in a timely manner.Support the mission, vision and values of Midco.Collaborate effectively with internal and external customers to ensure exceptional service.Demonstrate courage by tackling tough issues while acknowledging own limitations without compromising integrity.Remove obstacles for team members. Encourage creative solutions.Apply personal ethics, honesty, initiative, flexibility, responsibility and confidentiality in all areas of responsibility.Communicate clear expectations that set a high bar while holding team members accountable to reach these goals.Demonstrate business acumen by using data to drive decisions and actions.Model flexibility, resiliency and change management skills by staying self-aware, constantly learning, and finding ways to cut through ambiguous problems.Identify root causes of problems and implement solutions while keeping a holistic and long-term perspective in mind.Actively follow Midco policies and procedures.Perform other duties as assigned.Note : Management reserves the right to assign or reassign functions and responsibilities to this job description at any time.
EXPERIENCE AND EDUCATION :
Bachelor's degree or equivalent work experience required. Focus in business, marketing analytics or data science preferred.Minimum of 3 years analytics or related relevant experience required.Minimum of 1-3 years SQL experience preferred.Experience with marketing automation systems such as Adobe Campaign.Expertise using MS-Excel pivot tables, lookups and advanced functions is required.Experience with PowerBI or other analytic / data visualization reporting software.Proven ability to manage multiple projects and deadlines simultaneously.WORK ENVIRONMENT AND PHYSICAL & MENTAL QUALIFICATOINS :
The employee is occasionally required to reach with hands and arms, stoop, kneel, or crouch.The noise level in the work environment is moderate.Employees may be required to work in excess of 40 hours per week and other than normal business hours, such as holidays, evenings and weekends as business demands.