Marketing Data and BI Analyst

The Timberline Group; St. Louis (MO); Hybrid; USD 80,000 - 120,000; Full time

Job summary

The Timberline Group's Journey & Touchpoint Analytics team defines and implements data collection, reporting, and self-service analytics across campaigns and channels, enabling stakeholders to measure business impact. This role focuses on transforming data into actionable insights and guiding marketing measurement strategies.

You will design dashboards, collaborate with marketers and technologists, migrate to Google Analytics 4, and work with Snowflake, Oracle, Tableau, and Marketing Cloud tools

Qualifications

• Understanding omni-channel measurement and attribution for marketing campaigns.
• Advanced Excel skills to blend multiple data sets into reports.
• Experience querying Oracle SQL or Snowflake databases.
• Proficient in BI visualization with Tableau and Power BI.
• Experience analyzing campaigns or channels and presenting insights.
• Able to learn new analytics and MarTech platforms quickly.
• Ability to deliver results in a fast-paced environment with deadlines.
• 3–5 years of relevant work experience.

Responsibilities

• Design, create and deliver project team and management-level reports and visualizations.
• Perform analysis to transform data into actionable insights for decision-making.
• Develop measurement plans and supporting deliverables to measure performance.
• Consult on data and tagging requirements to align with marketing measurement framework.
• Support IT projects related to digital marketing prototypes and data requirements.
• Coordinate analytics platform training with vendors and project teams.
• Onboard data from marketing tools to support dashboards.
• Query data from Oracle or Snowflake to support outreach and reporting needs.

Skills

Omni-channel attribution

Advanced Excel

SQL / Snowflake querying

Tableau / Power BI

Marketing campaigns analysis

MarTech platform learning

Fast-paced environment

3-5 years experience

Education

Bachelor's degree in finance, business, economics, data science, math, analytics or marketing preferred.

Tools

Tableau

Power BI

Salesforce Marketing Cloud Intelligence (Datorama)

Snowflake

Oracle SQL

Impala

Hive

Job description

Opportunity Overview

The Journey & Touchpoint Analytics Team within the department 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.

• Journey & Touchpoint Analytics 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 are responsible for consulting with the marketing strategists, copywriters, channel managers and leadership to:
• Understand their business objectives, strategies, business questions and coach them on measures of success/KPIs
• Define measurement plans, data requirements, benchmarks and forecasts, and utilize analytics tool suite to meet their needs
• Deliver reports, research, analysis or custom insights and present findings to teams
• Advise teams on how they might apply learnings to their channels, campaigns, projects to optimize the client experience and improve business results

Responsibility Summary/Job Description

• 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.

Project Details

Journey & Touchpoint Analytics supports the Experience, Brand & Marketing division's measurement, analytics, data and reporting needs to measure and optimize the experience of potential clients, current clients and the branch teams who serve them.

Experience Measures is a fast-growing team with high visibility across platform. Given the critical need for data and insights to deliver measurable business outcomes for our clients and the firm, this role will directly enable the measurement of our many websites and digital touchpoints. 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.

Client is in the midst of a firm transformation to becoming a purpose-driven organization. We're partnering with our clients and colleagues to create positive impact on everyone's lives - bettering our communities and society. Client is at the leading edge of this transformation, championing better tools, data and insights to measure and enhance the experience of our clients and branch teams. This role will directly contribute to enhancing Clients' web analytics capabilities across multiple digital properties.

Team Details

The Team has 6 full-time associates, two full-time contractors and a team leader. We also lead a matrixed analytics team, through which two additional analysts, a data scientist and 3 partner vendors work as a part of our team. We focus on behavioral data in digital tools and help make the experience our clients have and the experience our branches have serving them the best it can be.

We work alongside two sister teams that focus on first-party research, including surveys and focus groups.

Client is headquartered in St. Louis, but our team works from all around the country. We work flexibly to support work/life balance.

Position Requirements

Required Qualifications

• 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

Preferred Qualifications

• 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