Pearson Senior Marketing Data Management Analyst in Bloomington, Minnesota
Senior Marketing Data Management Analyst
At Pearson, we’re committed to a world that’s always learning and to our talented team who makes it all possible. From bringing lectures vividly to life to turning textbooks into laptop lessons, we are always re-examining the way people learn best, whether it’s one child in our own backyard or an education community across the globe. We are bold thinkers and standout innovators who motivate each other to explore new frontiers in an environment that supports and inspires us to always be better. By pushing the boundaries of technology — and each other to surpass these boundaries — we create seeds of learning that become the catalyst for the world’s innovations, personal and global, large and small.
We are looking for a highly motivated, self-starting individual in our marketing analytics and business metrics area to provide insights for data-based decision making. The individual should be strategically focused and able to not only generate data, but be able to synthesize and interpret it for various members of the marketing team and provide recommendations based on the findings. Candidate will use multiple tools and analytical techniques across multiple databases. This position involves building queries directly from an ERP system and accessing data warehouses so solid SQL experience is a requirement. Experience with Oracle would be a plus.
Design data plan, extract data and analyze results for ad-hoc reports used in data-based decision making within various aspects of the business, based on specifications from management.
Provide actionable analytical insights and recommendations based on findings aligned to business objectives. Provide written reports and/or data visualizations and present findings to key stakeholders.
Generate complex customer and prospect list segmentations using SQL queries to combine/merge data sources and extract relevant data for marketing campaigns such as email, direct mail, and call lists.
Work collaboratively with marketing management to develop evaluation parameters for marketing campaign performance. Based on these parameters, extract relevant customer performance data; Evaluate, synthesize and summarize marketing campaign performance using appropriate analytical methods.
Provide guidance to product management, marketing and other stakeholders to both report on campaign performance and provide guidance to improve future campaign efforts. Periodically present findings to key stakeholders.
Establish campaign data quality control processes to verify expected results and ensure requirements are met; coordinate campaign deliverables with marketing management which include distribution lists and reporting on complex campaigns.
Ability to work effectively with team members and with cross-functional team members from other parts of the business.
Other duties and special projects as assigned.
Some travel (less than 5%) is required.
Bachelor’s degree in quantitative field such as statistics, mathematics, economic, computer science, or engineering. Alternative, Bachelor’s degree in Business Administration with an emphasis in quantitative discipline or Marketing. Master’s degree preferred.
Minimum 5 years’ experience with data mining in a data analyst role creating reports, metrics development, database querying, preferably within a marketing or ecommerce setting.
Minimum 5 years’ experience using SQL and SQL\
Plus (preferably in an Oracle environment) and using SQL Developer or similar database management tool. Experience with querying relational database systems required.
Analytic and problem-solving skills with an attention to detail especially while working with large data sets from multiple sources.
Ability to synthesize and summarize complex analytical issues, highlighting implications for the business.
An understanding of basic statistical methods.
Working knowledge of advanced functions, graphing, and macro programming in Excel.
Experience with other data aggregation and data visualization tools such as Alteryx or Tableau.
Excellent written and oral communications skills.
Prefer experience with Adobe Analytics (Site Catalyst), Google Analytics, Marketing Cloud (or similar eMarketing deployment tool analytics), and similar marketing database tools.
Familiar with marketing automation and email deployment tools such as Pardot or similar software.
Experience working with Business Objects or similar ERP data mining tool.
Pearson is an Equal Opportunity and Affirmative Action Employer and a member of E-Verify. All qualified applicants, including minorities, women, protected veterans, and individuals with disabilities are encouraged to apply.
Primary Location: US-TX-San Antonio
Other Locations US-MN-Bloomington
Work Locations: US-TX-San Antonio-19500 Bulverde 19500 Bulverde Road San Antonio 78259
Organization: Assessments Clinical
Employee Status: Regular Employee
Job Type: Standard
Shift: Day Job
Job Posting: Aug 1, 2017
Req ID: 1713201