Marketing Campaign Operations Analyst

100% REMOTE (U.S. only)
Job Terms:
$40-45 / hr. + great benefits!
Start date:
Posted By:
Vicki Schuch

Job Description:

The Marketing Analytics team is looking for a Marketing Campaign Operations Analyst that will be responsible for supporting marketing efforts from key utility programs (Residential Demand Response, Demand Response, Pilots, and Energy Waste Reduction) within sectors (Residential, Small Business, and Large Commercial and Industrial). The marketing campaigns for these products and programs are executed by both Consumers Energy employees and external third-party contractors. This support will be in the form of identifying, extracting, cleansing, and transforming customer data to produce audience extracts, primarily in support of customer marketing campaigns.


  • Work with marketing managers and vendors to understand requirements of marketing campaigns
  • Pull customer audience extracts using various criteria and from multiple sources (SQL databases, HANA databases, Excel files, flat files, etc.) to support the marketing campaigns
  • Work with vendors to place lists in secure FTP locations
  • Track and measure results of campaigns
  • Create Customer Segments and Journeys in Microsoft Dynamics CRM
  • Work with Microsoft Dynamics CRM team to develop and maintain analysis of volume of communication consumers are receiving and establishing best practices on communication volume and frequency for optimal performance
  • Develop charts and visualizations to support key metrics of campaigns
  • Look for ways to innovate and improve processes
  • Comply with all data privacy and security protocols
  • Able to meet Service Level Agreements and deadlines
  • Write scripts to pull data from internal and external data sources to compile into campaign lists
  • Identify ways to improve data reliability, efficiency and quality
  • Propose solutions to improve processes and proactively drive resolution to those solutions
  • Contribute to presentations for senior management.

Skills and Qualifications

  • Must understand marketing and database concepts
  • Understanding of data relationships, and data extraction techniques (like SQL)
  • Experience with Microsoft Dynamics, Excel
  • Must be able to work with multiple data sources
  • Bachelor's Degree in Business, IT or related field
  • 5+ years overall experience required
  • 2+ years of demonstrable experience working with data
  • Strong business acumen
  • Good communication skills, adept at virtual collaboration
  • Demonstrated exceptional attention to detail – including establishing QA processes
  • Strong commitment to meeting deadlines
  • Self-starter and intellectually curious
  • Comfortable in pushing the conventional thinking to drive change and innovation
  • Passion for data and analytics
  • Works well with technical, marketing and management teams
  • Understanding of the relationship between business requirements and business objectives to actionable recommendations
  • Comfortable with metrics, measurements
  • Ability to assist in the development of the measurement strategy
  • Must be a fit with our team culture
  • Familiarity with Lean processes are a plus

Client Description:

Our client is an award winning public utility that has provided natural gas and electricity to 6+ million residents for over a century! They are leading the clean energy transformation and are using automation and analytics to help them get there! Our client is focused on providing sustainable energy, conducting life-changing research on renewable energy sources and investing in responsible demand response programs. As a leader in the industry, they are also pledging to deliver industry-leading zero-coal, net-zero carbon and renewable energy to customers resulting in a healthier planet. Impressed? Us too!

The company culture is unmatched! Being awarded one of America's Best Places to Work by Forbes is no easy task yet it's done effortlessly! The company values are focused on three things: the people, the planet, and prosperity. Working with this client will allow you to use your digital expertise to create something magical! You will collaborate with incredible teams, gain new experiences, sharpen your current skills and implement new ones, expand your portfolio and the chance to work in an amazing company! Do you want to work for a company that is paving the way toward a brighter tomorrow? Apply today to see what exciting opportunities we have waiting for you!