Marketing Data and BI Analyst

The Timberline Group • Saint Louis, MO

6d • Remote

About The Position

The Journey & Touchpoint Analytics Team is responsible for defining and implementing an approach to collecting behavior/interaction data, developing comprehensive reporting across journeys and touchpoints, and enabling self-service by other stakeholders. This team supports the Experience, Brand & Marketing division's measurement, analytics, data and reporting needs for paid, owned, earned and shared channels and numerous campaigns and projects. Analysts on the team consult with marketing strategists, copywriters, channel managers and leadership to understand their business objectives, strategies, business questions and coach them on measures of success/KPIs. They define measurement plans, data requirements, benchmarks and forecasts, and utilize the analytics tool suite to meet stakeholder needs. Analysts also deliver reports, research, analysis or custom insights and present findings to teams, advising them on how to apply learnings to optimize the client experience and improve business results. This role will support the migration to Google Analytics 4 and will be involved with a number of other technologies, including Salesforce Marketing Cloud, Marketing Cloud Intelligence (FKA Datorama), Tableau, Snowflake, Oracle, etc. The role will directly contribute to enhancing the client's web analytics capabilities across multiple digital properties.

Requirements

• Understanding of digital marketing campaigns, channels and best practices for measuring individual and omni-channel performance and principles of multi-touch attribution
• Advanced experience with Excel to blend/transform multiple data sets into interactive reports
• Experience querying data from databases such as Oracle SQL or Snowflake databases
• Experience with BI visualization tools such as: Tableau, Power BI, Salesforce Marketing Cloud Intelligence (formerly Datorama)
• Experience analyzing and delivering marketing campaigns or channels analysis, presenting to internal business receivers and influencing business decisions
• Self-starter with interest and ability to quickly learn new analytics and MarTech platforms and identify creative solutions to connect data across sources
• Ability to deliver results in fast-paced environment with varying scope and deadlines
• Bachelor's Degree required with an emphasis in finance, business, economics, data science, math, analytics or marketing preferred. Relevant work experience will be considered.
• 3-5 years of relevant work experience

Nice To Haves

• Experience with Salesforce products and reporting In particular, Marketing Intelligence Cloud (FKA Datorama), Tableau and Marketing Cloud products.
• Proficiency interacting with various database and file storage systems (DB2, IDMS, Oracle, Snowflake)
• Experience with data manipulation languages such as SQL, Impala, PL/SQL, Hive, Pig, XML
• Experience with statistical tools such as SAS, SPSS, R, or Python preferred.
• Clicktale/Contentsquare or similar tool experience
• Knowledge of marketing technology stack and best practices for integrating tools and data

Responsibilities

• Design, create and deliver project team and management-level reports and visualizations
• Perform analysis to transform data into actionable insights and inform decision-making and present findings to project team stakeholders and leaders
• Develop and deliver measurement plans and supporting deliverables to enable teams to measure performance of projects, channels and campaigns
• Consult on data and tagging requirements and best practices to ensure alignment and consistency with marketing's measurement framework
• Support IT projects related to development of new digital marketing prototypes, including data requirements, design, user acceptance testing, implementation and verification
• Coordinate analytics platform training with vendors and project teams
• Onboard data from marketing tools to support recurring dashboards
• Query data from internal databases (currently Oracle, eventually Snowflake) to support outreach and reporting needs.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level